This intermediate Excel class focuses on powerful functions, including VLOOKUP, COUNTIFS, and SUMIFS, along with advanced sort and filter capabilities, and PivotTables for data analysis. You'll also master essential text features, including text splitting and joining, duplicate removal, and data validation. The course incorporates vital time-saving techniques such as Paste Special options, keyboard shortcuts, and efficient navigation methods.
Operating System Note:
A computer with Excel will be provided, and you may select your preferred operating system at checkout. The instructor will present using a PC and explain Mac differences for Mac students, with class materials clearly detailing the differences between platforms.
This Course has a Prerequisite:
You must have beginner-level 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.
