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