Advanced Formulas
o Using Named Ranges in Formulas
o Using Formulas That Span Multiple Worksheets
o Using the IF Function
o Using the PMT Function
o Using the LOOKUP Function
o Using the VLOOKUP Function
o Using the HLOOKUP Function
o Using the CONCATENATE Function
o Using the TRANSPOSE Function
o Using the PROPER, UPPER, and LOWER Functions
o Using the LEFT, RIGHT, and MID Functions
o Using Date Functions
o Creating Scenarios
Working with Lists
o Converting a List to a Table
o Removing Duplicates from a List
o Sorting Data in a List
o Filtering Data in a List
o Adding Subtotals to a List
Working with Illustrations
o Working with Clip Art
o Using Shapes
o Working with SmartArt
Visualizing Your Data
o Inserting Charts
o Add and Format Objects
o Insert a Text Box
o Create a Custom Chart Template
Working with Tables
o Format Data as a Table
o Move between Tables and Ranges
o Modify Tables
o Define Titles
Advanced Formatting
o Applying Conditional Formatting
o Working with Styles
o Creating and Modifying Templates
Microsoft Excel 2013 New Features
o New Functions in Excel 2013
o Using New Chart Tools
o Using the Quick Analysis Tool
o Using the Chart Recommendation Feature
