Topic 1

Creating Advanced Formulas

• Apply Range Names
• Use Specialized Functions

Topic 2

Analyzing Data with Logical and Lookup Functions

• Use Text Functions
• Use Logical Functions
• Use Lookup Functions
• Use Date Functions
• Use Financial Functions

Topic 3

Organizing Worksheet Data with Tables

• Create and Modify Tables
• Sort and Filter Data
• Use Subtotal and Database Functions to Calculate Data

Topic 4

Visualizing Data with Charts

• Create Charts
• Modify and Format Charts
• Create a Trendline
• Create Advanced Charts

Topic 5

Analyzing Data with PivotTables, Slicers, and Pivot Charts

• Create a PivotTable
• Filter Data by Using Slicers
• Analyse Data with Pivot Charts

Topic 6

Inserting Graphics

• Insert and Modify Graphic Objects
• Layer and Group Graphic Objects
• Incorporate SmartArt

Topic 7

Enhancing Workbooks

• Customize Workbooks
• Manage Themes
• Create and Use Templates
• Protect Files
• Preparing a Workbook for Multiple Audiences