MAPS Basic Excel

MAPS virtual courses are highly participatory and interactive.

Our instructors engage the participants by using many of the features of Zoom: breakout rooms, chat window, polling, class discussions, and share screen. The MAPS online experience will be similar to MAPS in-person; your learning requires your involvement. 

To receive the best experience, please join from your own device with a microphone.

Course Overview

Course Description

Build a strong foundation in Excel by learning how to navigate the ribbon, worksheets, rows, columns, and cells. Participants will practice formatting data, cleaning a messy export into something a colleague can actually read, building tables and charts, and using simple formulas and functions to organize and analyze information. Through hands-on exercises you'll gain the confidence to work efficiently in Excel. Every session is taught inside a working Excel file rather than from slides, and you keep the workbooks, including a complete answer key for every exercise.

Prerequisites

• No prior or limited knowledge of Microsoft Excel is required.
• Basic computer literacy, including the ability to operate a keyboard and mouse, open and save files, and navigate standard software applications.

Intended Audience

This course is designed for individuals with little to no prior experience using Microsoft Excel who wish to build a solid foundation in spreadsheet skills for personal or professional use.   

Learning Outcomes

By the end of this course, you will be able to:

• Navigate a large worksheet efficiently, including moving and selecting data without using the mouse
• Turn a raw system export into clean, readable, sortable data — and recognize the problems that make data unusable
• Write and copy the core Excel functions, and explain what absolute and relative cell references do
• Choose an appropriate chart for a question, build it honestly, and defend the choices behind it
• Understand important limitations of Excel and best practices for ongoing data management and collaboration
• Recognize common spreadsheet errors before they reach a colleague or a decision-maker

Course Materials

A zoom link and course materials including pre-work will be emailed to you one week prior to the course.

*A computer or device with a working microphone is required
*A camera on your device or webcam is recommended

You do not need a Zoom account to attend MAPS through Zoom, but you will need to download the Zoom app (also known as Zoom Desktop Client). Download here: https://zoom.us/download

Instructor

Nego Jovanovich

Nego is an analytics leader with a strong background at the intersection of business, technology, and data strategy. He earned a bachelor’s degree in Economics and Marketing from The Ohio State University in 2013 and a master’s degree in Computer Information Systems from Boston University in 2016. His career began at Cardinal Health in sales analytics, followed by a role as a Solution Architect at Avaap. In 2023, he joined JP Morgan Chase, where he currently serves as Executive Director of Analytics, driving data-driven insights and strategy at scale.

FAQ's

Requirements for a Virtual Course

• A device that has a working microphone is required. A camera is strongly recommended. The online courses use features that enhance your experience with the use of your device’s camera and microphone for interaction and participation.
• Pre-work
  Virtual MAPS courses include approximately 2 hours of pre-work. Pre-work materials and instructions will be emailed to participants at least one week prior to the course date.

Follow these steps to make a cancellation:

1. Refer to your registration confirmation email
2. Scroll down to "Cancellation Policy"
3. Follow link in email
4. Enter the confirmation number from the registration email
5. At the top of the page, click on “Cancel Registration” button
6. Click Finish

Follow these steps to make a substitution: 

1. Refer to your registration confirmation email
2. Scroll down to "Substitutions"
3. Follow link in email
4. Enter the confirmation number from the registration email
5. At the top of the page, click on the “Substitute Registrant” button
6. Enter the name and email of the new registrant
7. Click Next
8. Click Confirm

CEU and CPE Policy 
Attendance in this course can earn:

• 0.6 Continuing Education Units (CEUs)
• 7.2 Continuing Professional Education Units (CPEs)

Attendance is recorded at check-in at the start of the day, and full CEU or CPE credit is awarded based on an honor system, with the expectation that participants are present and actively engaged for the full MAPS course

Course Certificate
Your course certificate will be emailed to you following the course. It will reflect your Continuing Education Units (CEUs) and Continuing Professional Education Units (CPEs) earned and your attendance of the course.

Waitlist
What happens if I am on a waitlist for a course? You will receive an email confirming you have been added to a waitlist. If a spot becomes available, you will be notified by email.

Photography
The Ohio State University may occasionally take pictures during educational events for use in program communication. If you do not want to be photographed during this course, please email the MAPS team at glenn-training@osu.edu.

MAPS Membership 
A MAPS member receives a discounted rate of $250 for each course with the initial purchase of at least 12 credits. Each credit equals one course for one individual.

To inquire about becoming a MAPS member, please fill out the MAPS Membership Form. A Glenn College Professional Development team member will reach out to you.

Questions or want to learn more?