1.1. Structure of Excel

1.2. Open, Close Save, and Print Workbook
1.2.1. Open Workbook
1.2.2. Close Workbook
1.2.3. Save Workbook
1.2.4. Print Workbook

1.3. Unsaved Work Guide & Recover Previous File Version
1.3.1. Unsaved Work Guide
1.3.2. Recover Previous File Version

1.4. Excel Ready-to-Use Template

1.5. Excel User Interface Menu Overview & Keyboard Shortcuts
1.5.1. Excel User Interface Menu Overview
1.5.2. Keyboard Shortcuts

1.6. Customizing Quick Access Toolbar & Ribbon
1.6.1. Customizing Quick Access Toolbar
1.6.2. Customizing Ribbon 

2.1. Understanding Excel Data Types
2.1.1. Standard Data Types
2.1.2. Modern Data Types

2.2. Capture Data – Text, Number, Date, Time, and Autofill
2.2.1. Capture Text Data
2.2.2. Capture Numerical Data
2.2.3. Capturing Date Data
2.2.4. Capture Time Data
2.2.5. Autofill

2.3. Modify Content – Delete, Replace, Update, and Add Comments & Notes
2.3.1. Delete Content
2.3.2. Replace Content
2.3.3. Update Content
2.3.4. Add Comments & Notes

2.4. Formatting Data – Standard Cell Formatting
2.4.1. Font
2.4.2. Alignment
2.4.3. Number

2.5. Conditional Formatting
2.5.1. Data Bars
2.5.2. Color Scales
2.5.3. Icon Sets
2.5.4. Highlight Cell Rules
2.5.5. Top Bottom Rules

5.1. Basic Function
5.1.1. Sum
5.1.2. Average
5.1.3. Count
5.1.4. Countblank
5.1.5. Max
5.1.6. Min
5.1.7. Subtotal

5.2. Numeric Function
5.2.1. Adjust Decimals
5.2.2. Nearest Digit
5.2.3. Odd-Even Number

5.3. Text Function
5.3.1. Joining Text Data
5.3.2. Cleaning Text Data
5.3.3. Count Characters in String
5.3.4. Change Text Case 99
5.3.5. Extract Simple Text Data
5.3.6. Extract Complex Text Data

5.4. Date & Time Function
5.4.1. Current Day & Time
5.4.2. Calculate Number of Days, Working Days, Weeks, Months, Quarters, and Years Between 2 Dates
5.4.3. Extract Date Values from Date
5.4.4. Extract Time Values from Date
5.4.5. Add Hours, Minutes, Seconds to a Time – Time

5.5. Logical Function
5.5.1. Simple Condition – If
5.5.2. Multiple Condition – Ifs & Nested If
5.5.3. If Condition with AND
5.5.4. If Condition with OR

5.6. Match & Lookup Function
5.6.1. Find Exact Value Based on Left Lookup Column – Vlookup
5.6.2. Find Exact Value Based on Any Lookup Column – Index & Match
5.6.3. Find Exact Value Based on Horizontal Lookup Row – Hlookup
5.6.4. Finding Exact Value Based on Flexible Function – Xlookup
5.6.5. 2 Way Lookup Based on Row & Column – Xlookup
5.6.6. 2 Way Lookup Based on Row & Column – Index & Match
5.6.7. Find Multiple Records Based on Criteria – Filter 124
5.6.8. Find Unique List of Values & Sorting Ascending – Unique & Sort
5.6.9. Sorting Data – Sort
5.6.10. Sorting Data – Sortby

5.7. Conditional Calculation Function
5.7.1. Sum Based on Single Criteria – Sumif
5.7.2. Sum Based on Multiple Criteria – Sumifs
5.7.3. Count Based on Multiple Criteria – Countifs
5.7.4. Average Based on Multiple Criteria – Averageifs
5.7.5. Max Based on Multiple Criteria – Maxifs
5.7.6. Min Based on Multiple Criteria – Minifs
5.7.7. Assign a Rank Value – Rank

5.8. Conditional Formatting Functions
5.8.1. Compare 2 List via Conditional Formatting – Match
5.8.2. Compare 2 List via Conditional Formatting – No Match

5.9. Formula Auditing Tools
5.9.1. Formula Errors
5.9.2. Audit Tools

5.10. Formula Tricks
5.10.1 AutoSum Calculation
5.10.2. Status Bar Calculation

6.1. Introduction to Charts
6.1.1. Chart Overview
6.1.2. Building Chart
6.1.3. Chart Elements

6.2. Chart Types
6.2.1. Column Chart
6.2.2. Bar Chart
6.2.3. Line Chart
6.2.4. Pie/Doughnut Chart
6.2.5. XY Scatter Plot Chart
6.2.6. Area Chart
6.2.7. Radar Chart
6.2.8. Stock Chart
6.2.9. Histogram Chart
6.2.10. Pareto Chart
6.2.11. Waterfall Chart
6.2.12. Box & Whisker
6.2.13. Treemap Chart
6.2.14. Map Chart
6.2.15. Recommended Chart
6.2.16. Sparkline Chart

6.3. Building KPIs for Dashboard
6.3.1. KPI via Shapes
6.3.2. KPI via SmartArt

6.4. Best Practices for building Chart – Checklist

6.5. Best Practices for building Dashboard – Checklist

8.1. Introduction to PivotTable

8.2. PivotTable Analyze (Analyzing)
8.2.1. Field Setting
8.2.2. Expand Collapse
8.2.3. Group
8.2.4. Insert Timeline
8.2.5. Insert Slicer
8.2.6. Filter Connections
8.2.7. Refresh & Change Data Source
8.2.8. PivotTable Actions
8.2.9. Calculation
8.2.10. PivotChart
8.2.11. Show Menu

8.3. PivotTable Design (Reporting)
8.3.1. Subtotals
8.3.2. Grand Totals
8.3.3. Report Layout
8.3.4. Blank Rows
8.3.5. PivotTable Style Options
8.3.6. PivotTable Styles

8.4. PivotTable Techniques
8.4.1. Show Details
8.4.2. Sort

12.1 Worksheet Protection
12.2. Workbook Protection
12.3. Workbook Structure Protection
12.4. VBA Protection