MS Excel Level 3
- Live virtual or in person
- 7 hours
- Instructor-led
Live virtual or in person · 7 hours · Instructor-led
Advanced Excel training covering complex formulas, nested functions, advanced PivotTables, macros, data analysis tools, What-If analysis, and automation techniques for power users.
Upcoming sessions
Pick a date and register
Course outline
Topics covered
- Logical functions
- Conditional functions
- Financial functions
- Text functions
- Date functions
- Lookup functions
- Data Validation
- PivotTables
- Running and recording a macro
About this course
What this course covers
This Excel course is a day of finding ways to save time and energy digging into your data to get the desired result. You will be introduced to various functions that will quickly condense substantial amounts of data through a Pivot Table, pull out specific data through VLOOKUPs, conditional and logical functions, and save time through macros, data validation, and more. This class is a segue into our more focused courses for individual advanced Excel topics.
Before you attend. The course requires that you have successfully completed Excel I and II (or had more than six months using the software and are familiar with the concepts presented in Excel I and II). .
Your facilitators
Who teaches this course
Ken Worthy
Facilitator
Monica Lewis
Learning On Demand Consultant
Monica B. Lewis has been a contract trainer at Catapult for over a year. As a Microsoft Certified Trainer, she has delivered training in 34 countries and 45 U.S. states, reaching professionals and trainers across many industries. Her Catapult courses include Computer Basics, Outlook, PowerPoint, Word, Excel (including PivotTables and dashboards), and Teams.
See the full team of Catapult HR Advisors.
Good to know
Course questions
It is delivered live online and in person at the Charlotte Learning Center. Each session runs 7 hours.
A single seat is $459 for non-members and $339 for members. It is also included with a Class Pass.
Next: Oct 27 · 9 upcoming dates. Pick a date from the list above to register.
Yes. Private delivery is available for your organization, scheduled around your calendar, live online or on site.
Learners also liked
Courses learners usually take next
Related training
More Technology & Digital Skills training
MS Teams
Nov 4 · 1 date
Live virtual
$455 non-member · $339 member
Delivered live online nationwide, with select courses also meeting in person in Charlotte and Raleigh. Explore training by state: North Carolina · Georgia · Maryland · New Mexico · Texas · Arkansas
MS Word Level 1
Nov 5 · 2 dates
Live virtual or In person, Charlotte
$459 non-member · $339 member
MS Word Level 2
Dec 3 · 2 dates
Live virtual or In person, Charlotte
$459 non-member · $339 member
All Courses & Dates
Browse the full catalog of 101 live, instructor-led courses.
Browse the catalog →Technology & Digital Skills
All technology & digital skills courses with upcoming dates.
Explore →All HR Training
Every Catapult training topic and format.
Browse →Private Group Training
Bring this course to your team on your schedule.
Learn more →Register for MS Excel Level 3 today
Live online, open to your whole team. Or bring it in-house with private delivery.