Module 1: Advanced Formulas
- Using Named Ranges in Formulas
- Using Formulas That Span Multiple Worksheets
- Entering a Formula Using Data in Multiple Worksheets
- Using the IF Function
- Using the PMT Function
- Using the LOOKUP Function
- Using the VLOOKUP Function
- Using the HLOOKUP Function
- Using the CONCAT Function
- Using the TRANSPOSE Function
- Using the PROPER, UPPER, and LOWER Functions
- Using the PROPER Function
- Using the LEFT, RIGHT, and MID Functions
- Using the LEFT and RIGHT Functions
- Using Date Functions
- Using the YEAR, MONTH, and DAY Functions
- Creating Scenarios
Module 2: Working with Lists
- Converting a List to a Table
- Removing Duplicates from a List
- Sorting Data in a List
- Filtering Data in a List
- Adding Subtotals to a List
Mobile 3: Working with Illustrations
- Working with Clip Art
- Using Shapes
- Adding Shapes
- Working with Icons
- Working with SmartArt
- Using Office Ink
Module 4: Visualizing Your Data
- Inserting Charts
- Using the Chart Recommendation Feature
- Editing Charts
- Using Chart Tools
- Using the Quick Analysis Tool
- Add and Format Objects
- Create a Custom Chart Template
Mobile 5: Working with Tables
- Format Data as a Table
- Move between Tables and Ranges
- Modify Tables
- Define Titles
- Creating and Modifying a Table in Excel
Module 6: Advanced Formatting
- Applying Conditional Formatting
- Using Conditional Formatting
- Working with Styles
- Creating and Modifying Templates