Module 1: Advanced Formulas
This module explains how to work with formulas.
- Lessons:
- Using Named Ranges in Formulas
- Naming a Single Cell
- Naming a Range of Cells
- Naming Multiple Single Cells Quickly
- Using Formulas That Span Multiple Worksheets
- Using the IF Function
- Using AND/OR Functions
- Using the SUM IF, AVERAGE IF, and COUNT IF Functions
- Using the PMT Function
- Using the LOOKUP Function
- Using the V LOOKUP Function
- Using the HOOKUP Function
- Using the CONCATENATE Function
- Using the TRANSPOSE Function
- Using the PROPER, UPPER, and LOWER Functions
- The UPPER Function
- The LOWER function
- The TRIM Function
- Using the LEFT, RIGHT, and MID Functions
- The MID Function
- Using Date Functions
- Using the NOW and TODAY Functions
- Creating Scenarios
- Utilize the Watch Window
- Consolidate Data
- Enable Iterative Calculations
- What-If Analyses
- Use the Scenario Manager
- Use Financial Functions
- Lab : Advanced Formulas
- Using Named Ranges in Formulas
- Entering a Formula Using Data in Multiple Worksheets
- Using the IF Function
- Using the PT Function
- Using the V LOOKUP Function
- Using the CONCATENATE Function
- Using the PROPER Function
- Using the LEFT and RIGHT Functions
- Using the YEAR, MONTH, and DAY Functions
Module 2: Working with Lists
This module explains how to work with lists.
- Lessons:
- 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
- Grouping and Grouping Data in a List
- Lab : 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
Module 3: Working with Illustrations
This module explains how to work with illustrations.
- Lessons:
- Working with Clip Art
- Using Shapes
- Working with Smart Art
- Lab : Working with Illustrations
- Working with Clip Art
- Adding Shapes
Module 4: Visualizing Your Data
This module explains how to work with charts, objects, and text boxes.
- Lessons:
- Creating a Custom Chart Template
- Inserting Charts
- Add and Format Objects
- Insert a Text Box
- Create a Custom Chart Template
- Lab : Visualizing Your Data
- Inserting Charts
- Editing Charts
Module 5: Working with Tables
This module explains how to work with tables.
- Lessons:
- Format Data as a Table
- Move between Tables and Ranges
- Modify Tables
- Define Titles
- Lab : Working with Tables
- Creating and Modifying a Table in Excel
Module 6: Advanced Formatting
This module explains how work with formatting options in Excel.
- Lessons:
- Applying Conditional Formatting
- Working with Styles
- Creating and Modifying Templates
- Lab : Advanced Formatting
- Using Conditional Formatting
- Working with Styles
Module 7: Microsoft Excel Features that Were New in 2013
This module explains how to use some features that were new in 2013.
- Lessons:
- New Functions in Excel 2013
- Using New Chart Tools
- Using the Quick Analysis Tool
- Using the Chart Recommendation Feature
- Lab : Microsoft Excel Features that Were New in 2013
- Using the New Excel Functions
- Using the New Excel 2013 Chart Tools
- Using the Quick Analysis Tool
Module 8: Features New in 2016
This module explains how to use the new charts in 2016.
- Lessons:
- New Charts
- Tree map
- Sunburst
- Histogram
- Waterfall
- Box and Whisker
- Pareto
- Lab : None
