WCTC - 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. This workshop covers Microsoft Excel 2019.

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