Topic A: Formula Reference
Relative References
Absolute References
Mixed References

Topic B: Apply Range Names
Range Names
Adding Range Names Using the Name Box
Adding a Range Names Using Define Name
Adding multiple names using Create from Selection
Editing and Deleting Range Name Using Name Manager
Using Range Names in Formulas

Topic A: Data Summary with Function
COUNTA
AVERAGEA

Topic B: Conditional Data Summary 1
COUNTIF / COUNTIFS
AVERAGEIF / AVERAGEIFS
SUMIF / SUMIFS
MAXIF
MINIF

Topic C: Conditional Data Extraction
IFERROR
IF
IFS or Nested IF

Topic D: Conditional Data Summary 2
DSUM
DCOUNT / DCOUNTA
DAVERAGE
DMAX
DMIN

Topic A: Create and Modify Tables
Create table
Styles and Quick Style Sets
Removing Duplicate Values

Topic B: Sort and Filter Data
Sorting Data
Filtering Data
Advanced Filtering

Topic C: Use Subtotal to Calculate Data
Total Row with SubTotal Functions

Topic D: Data Validation
Data Validation Using Lists
Data Validation Using Whole Number / Decimal
Data Validation Using Date
Data Validation Using Formulas

Topic A: Conditional Formatting
Highlight Cell Rules
Data Bars
Icon Sets
Creating New Rules with Formula

Topic B: Create Charts
Chart Types
Chart Insertion Methods
Resizing and Moving the Chart
Adding Additional Data
Switching Between Rows and Columns

Topic C: Modify and Format Charts
Chart Elements
Minimize Extraneous Chart Elements
The Chart Tools Contextual Tabs
Formatting the Chart with a Style
Adding a Legend to the Chart

Topic D: Adding Sparklines
Adding Sparklines
Editing Sparkline Data
Removing Sparklines

Topic E: Editing Sparklines
Showing and Hiding Data
Changing the Style
Changing the Sparkline and Marker Color
Setting Axis Options

Topic A: Working with Different Views
Using Page Break Preview for Page Setup
Using Page Layout View for Express Header & Footer
Using Custom view

Topic B: Managing Multiple Windows
Arranging Workbooks
Comparing Workbooks Side by Side
Synchronous Scrolling and Resetting a Window