Overview
Syllabus
Start
Flash Fill
List Design & Single Level Sorting
Multi-Level Sorting
Custom Sorting
Filtering
Multi-Level Filtering
Search Filtering
Format as Table
Table Style Options
Remove Duplicates
Convert to Range
Subtotal
Multi-Level Subtotaling
Remove Subtotals
Quick Analysis Charts
Inserting Data Charts
Formatting Data Charts
Chart Templates
Sparklines
Printing Charts
Importing From Web
MS Query
Exporting Overview
Pivot Tables
Multiple-Field Pivot Tables
Drill Down Reports
Pivot Charts & Grouping Fields
Slicer Tool
Data Validation
Additional Data Validation
Cell & Sheet Protection
File Encryption
Conditional Formatting
Linking Data
Inserting Comments
Taught by
Learnit Training