Course outline

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
Lab: Advanced Formulas Exercises

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
Lab: Work with Lists Exercises

Module 3: Working with Illustrations
• Working with Clip Art
• Using Shapes
• Adding Shapes
• Working with Icons
• Working with SmartArt
• Using Office Ink
Lab: Working with Illustrations Exercises

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
Lab: Visualizing Your Data Exercises

Module 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
Lab: Creating and Modifying a Table in Excel

Module 6: Advanced Formatting
• Applying Conditional Formatting
• Using Conditional Formatting
• Working with Styles
• Creating and Modifying Templates
Lab: Advanced Formatting Exercises