Intermediate Microsoft Excel (Live Online)

Master VLOOKUP, Pivot Tables, formulas and functions in this intermediate Excel course. Build on your basic Excel knowledge by learning more advanced techniques like Sort & Filter, logical functions, and time-saving tricks.The intermediate Excel class focuses on more advanced functions (including VLOOKUP, COUNTIFS and SUMIFs), Sort & Filter, and Pivot Tables. You'll also learn crucial text-related features like splitting and joining text, removing duplicates, and data validation. Embedded in the course are pivotal time-saving tricks like Paste Special, keyboard shortcuts, and navigation techniques.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.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.Learn more about Intermediate Microsoft Excel at NYC Career Centers.