Excel Level II: Intermediate Course Online

Self-paced online training with expert support

Master intermediate Excel functions such as VLOOKUP and SUMIFs, along with techniques to summarize data using Pivot Tables, sort and filter databases, and split and join text. Develop the skills necessary to work with advanced Excel functions and prepare for more in-depth training.

$249 Start anytime

This course includes

  • 6 hours of project-based training from experts
  • Answers from real instructors
  • Proprietary workbook included
  • Access to class recordings (30 days)
  • Verified digital certificate of completion
  • Learn at an accredited institution

This course is self-paced. For live online or in-person instruction, take Excel Level II: Intermediate.

In this intermediate Excel class, you'll dive into powerful functions like VLOOKUP and SUMIFs, learn to summarize data with Pivot Tables, sort and filter databases, and manipulate text with split and join functions. You'll also have access to our innovative Excel video suite, allowing you to revisit the material anytime after the class.

Enroll in this class as part of the Excel Bootcamp and enjoy a 15% discount. The full package includes our Fundamentals, Intermediate, and Advanced Excel classes.

  • Split and join text, add data validation, and use named ranges
  • Utilize database functions like VLOOKUP and HLOOKUP
  • Apply logical functions such as AND, OR, and IF statements
  • Summarize large datasets quickly with Pivot Tables
  • Use statistical functions like Ranking, COUNTIFS, and SUMIFS
  • Create advanced combo charts combining multiple chart types
  • Reinforce key concepts with a final project

This course has a prerequisite

Attendees must have beginner Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, printing, formatting, basic charts, and tables.

set of printed construction documents
student learning civil 3d on computer
male student at computer workstation taking revit course
female student with phone
Yelp Facebook LinkedIn YouTube Twitter Instagram