Microsoft Excel – Level 2

This workshop is for individuals already knowledgeable of Microsoft Excel. It expands upon the beginner level foundation with an in-depth look at advanced formatting features and the utilization of functions.

Topics covered:

Advanced formatting—themes, cell styles, number formats, customizing page setup

Date functions and conditional formatting - date serial numbers, entering time information, graphics and custom rules

Financial functions and WHAT-IF analysis - creating financial functions, using WHAT-IF tools

Text and conditional functions, formula auditing - IF criteria, troubleshooting formulas

Lookup functions and outlines - introducing lookup functions, outline feature, subtotals