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.
This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.
Upon registration, the instructor will send along additional information about how to log-on and participate in the class.
Also available in-person in NYC
