Go from beginner to experienced professional: summarize data with Pivot Tables, write advanced functions including VLOOKUP, and learn techniques to expedite your workflow. Split and join text, create dropdown menus, and sort and filter data. Use statistical formulas like COUNTIFS and SUMIFS to learn more about your data. At the end of this class, you'll unlock powerful techniques that will help you complete tasks more quickly.

Save 15% on Enrollment with Excel Bootcamp

Do you want to become an advanced Excel user in just 3 days? Sign up for our Microsoft Excel Bootcamp and get a 15% package discount. 

Operating System Note: A PC or Mac with Excel will be provided (choose your operating system at checkout). The instructor will present on a PC but will explain the differences for Mac students, and the class files clearly outline the differences.

warning-standard-solid 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.

What You'll Learn

  • Navigation tricks & shortcuts
  • Summarize data with Pivot Tables
  • VLOOKUP function
  • Join and split text
  • Create drop-down menus
  • Sort & filter data
  • Tricks to speed up workflow
  • Logical functions: IF, AND, OR

Upgrade to a bootcamp or certification program and save on tuition

  • Excel for Business Bootcamp Sign up
  • Excel Specialist Certification Program Sign up
  • Data Analytics Bootcamp Sign up