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 II: Intermediate
$249 6 Hours
Learn More
Download Syllabus
Overview
Learn intermediate Excel functions like VLOOKUP and SUMIFS, and how to summarize data with Pivot Tables, Sort & Filter databases, and split and join text. Gain the skills needed to utilize complex Excel functions and prepare for more advanced training.
Prerequisite
Attendees must have beginner Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, printing, formatting, basic charts, and tables.
Location
Live Online or Live Online
Schedule
Next start date: January 13, Tuesday, 10–5pm
Other scheduling options Weekdays, Sundays, or evenings
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

Those with familiarity with basic Excel, including basic formulas & functions, graphs, and tables, seeking to expand their skills to intermediate-level features, including VLOOKUP and Pivot Tables. The skills taught in the course apply to a variety of industries, including technology, financial services, retail, education, professional services, healthcare, non-profit, and more.
What You’ll Learn
  • Learn to split and join text, add data validation, and named ranges
  • Use database functions such as VLOOKUP and HLOOKUP
  • Add logical statements, including AND, OR, and IF statements
  • Create PivotTables to quickly summarize large databases
  • Use statistical functions such as RANK, COUNTIFS, and SUMIFS
  • Create advanced combo charts from multiple charts
  • Review key concepts by creating a final project

Add Class or Certificate to Compare