Compare Classes & Certificates

Which course is right for you? This tool allows you to compare any class or certificate program in our catalogue with the important information you need to make the right decision.

Remove
Key Information
Excel Level III: Advanced
$249 6 Hours
Learn More
Download Syllabus
Overview
Learn advanced Excel functions, macros, and data analysis to improve efficiency and manage complex data in any job setting. This advanced course is ideal for Excel power-users.
Prerequisite
Attendees must have Excel proficiency equivalent to our Intermediate Excel course, including VLOOKUP, Pivot Tables, and IF statements.
Location
Live Online or Live Online
Schedule
Next start date: January 21 & 26, Wednesday & Monday, 6–9pm
Other scheduling options Evenings, weekdays, or Sundays
View full schedule
Certification
Software Included
Microsoft Office (1 month)
Free Retake Within 1 Year See our class policies for more details
Workbook Included
Financing See our Climb Credit FAQ for more details
Target Audience

This class is meant for those with prior experience with basic and intermediate-level Excel skills looking to learn Excel’s most advanced functions and capabilities, including advanced lookup functions, Pivot Charts, and macros.
What You’ll Learn
  • Understand cell management, including cell locking, auditing, and hotkeys
  • Learn special formatting for calculating dates
  • Use advanced functions, such as nested IF statements
  • Learn advanced analytical tools for data consolidation, conditions to exclude data, and PivotCharts
  • Use advanced database functions, such as MATCH, VLOOKUP-MATCH, and INDEX-Double MATCH
  • Record macros and relative reference macros for ad-hoc reporting
  • Create a project that applies key concepts from the class

Add Class or Certificate to Compare