HR training course
MS Excel Level 3
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
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 $339 for members and $459 for non-members. It is also included with a Class Pass.
Next: Oct 27 · 5 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
Computer Basics: Windows and more
Oct 13 · 2 dates
Live virtual or In person, Charlotte
$339 member · $459 non-member
Delivered live online nationwide, with select courses also meeting in person in Charlotte and Raleigh. Explore training by state: North Carolina · Georgia · Massachusetts · New York · Utah · California
Customer Service Excellence
Dec 2 · 1 date
Live virtual
$339 member · $459 non-member
Cyber-Security Essentials
Dec 9 · 1 date
Live virtual
$339 member · $459 non-member
All Courses & Dates
Browse the full catalog of 72 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.