Excel is capable of doing much more than totaling numbers or printing reports. Commands like conditional formats, 3D formulas, subtotals, and database management let you take advantage of some of Excel’s most powerful features. Intermediate Excel is a hands-on class designed to give participants practice with some of Excel’s most useful, time-saving commands and features. Topics include applying conditional formats, 3D formulas, the IF function, filtering a list, subtotals, pivot tables and pivot charts, V and Hlookups, and goal seek. This is not an introductory level class. It is strongly advised that participants have previous experience with Excel topics such as data entry, creating formulas and relative and absolute references.
This course covers Excel 2016 and 2013.