Microsoft Excel Advanced (Level 2)

Begin automating spreadsheets and learn how to create linking formulas that automatically connect data over many different worksheets, allowing for easy one-time data entry. Grow your portfolio by adding a group of the most powerful formulas frequently used in Excel and then splash your spreadsheet with useful graphics and templates to highlight and connect key informational points. In this course, you will learn: (1) advanced formatting: themes, cell styles, customizing page setup, (2) date and time functions, conditional formatting, (3) advanced functions for text and analysis: IF criteria, troubleshooting formulas, and (4) introducing lookup functions and the outline features.