1. Welcome to Excel Analytics OS
2. Course structure
3. Learning materials and resources

1. Identify your purpose

1. Introduction - Right data
2. Function #1: Logical
3. Logic: IF / nested IF
4. Logic: IFS / IFERROR
5. Logic: AND / OR / TRUE / FALSE
6. Function #2: Lookup
7. Lookup: XLOOKUP basic vertical
8. Lookup: XLOOKUP basic horizontal
9. Lookup : VLOOKUP basic
10. Lookup : HLOOKUP basic
11. Lookup : MATCH / VLOOKUP + MATCH
12. Lookup : INDEX / INDEX+MATCH
13. Function #3: Text
14. Text split - TEXTSPLIT / TEXTBEFORE / TEXTAFTER / LEFT / MID / RIGHT
15. Text Split: Text to column
16. Text join: TEXTJOIN / CONCATENATE / CONCAT / & / XLOOKUP advanced / FORMULATEXT
17. Text format: TRIM / UPPER / LOWER / PROPER / TRANSPOSE / TEXT / VALUE
18. Find and replace: Ctrl+F / Ctrl+H
19. Find and replace: FIND / IF + FIND / SEARCH / SEARCH + COUNT / SUBSTITUTE
20. The power of creating "TABLE"
21. Practice: Data cleansing
22. Tutorial: Data cleansing
23. Coming lessons
24. Collect meaningful data by understanding stakeholders
25. Wrap up - Right Data

1. Introduction - ACT to compare and spotlight findings
2. 5 useful performance metrics

1. Introduction - Analyze the numbers with formula + Date function
2. DATE functions: DATE / TODAY / YEAR / MONTH / DAY
3. DATE functions: WEEKDAY / WEEKNUM / EDATE / EOMONTH
4. CALCULATION introduction
5. CALCULATION Math : SUM / SUMIF / SUMIFS / SUM+*
6. CALCULATION Math: SUBTOTAL / AGGREGATE
7. CALCULATION Statistic : AVERAGE / AVERAGEIF / AVERAGEIFS ; Evaluate formula
8. CALCULATION Statistic : COUNTA / COUNT / COUNTIF / COUNTIFS
9. CALCULATION Statistic: MIN / MINIFS / MAX / MAXIFS / TRIMMEAN
10. CALCULATION Statistic: MODE / MEDIAN / RANK
11. Lookup function: FILTER / SORT / SORTBY / UNIQUE
12. Practice: Analyzing numbers
13. Tutorial for practice: Part A
14. Tutorial for practice: Part B
15. Tip 1: Stacking formula techniques
16. Tips 2: 6 common errors handling / FORMULATEXT
17. Wrap up - Analyze numbers with formula

1. Introduction - Conditional formatting
2. Master the "5 BIG ICONS"
3. Meaningful color tones
4. Highlight Cells Rules - Spotlight on specific data
5. Top / Bottom Rules - 80/20 rules
6. Data Bar - Speedy comparision
7. Color Scales - Heat map
8. Icon Sets - High level classification
9. New Rules - Spotlight based on your formula
10. Custom number format
11. Practice: Conditional Formatting
12. Tutorial: Conditional Formatting
13. Wrap up - Conditional formatting

1. Introduction - Trends and charts
2. Use proper data format to create charts
3. Useful features for different types of charts
4. Add new data for comparison
5. Create dynamic charts with Table and Slicers
6. LINE CHART: Automatically highlight min/max
7. LINE CHART: Add average line
8. LINE CHART: Dynamic Chart Model (XLOOKUP/VLOOKUP)
9. LINE CHART: Dynamic alert and trendline
10. LINE CHART: Record external factors / Story telling
11. BAR CHART Introduction - 5 Key benefits
12. BAR CHART: Auto-Sorting / Auto-updating (Part 1)
13. BAR CHART: Build flexible chart by adding switches (Part 2)
14. BAR CHART: Conditional bar chart
15. BAR CHART: 100% Stacked column
16. COMBO CHART: Add target line and marker
17. COMBO CHART: Add % change in Combo Chart
18. Sparklines: Quick analysis
19. Conditional progress bar using REPT
20. Practice: COMBO CHART
21. Practice: Demonstration
22. Wrap up - Trends and Charts + Step 3 ACT

1. Introduction - Identify root cause
2. Create and refresh PivotTable with "Excel Table"
3. Core operations concept: Dragging Rows / Columns / Values / Filters
4. Exercise: Dragging Fields in PivotTable
5. Useful features: Set color/ number format / disable auto-width adjustment
6. Useful features: Slicers and Timeline
7. Useful features: Grouping
8. Useful features: Summarize value by / break down raw data
9. Useful features: Show value as / Duplicate value column
10. Useful features: Add simple calculated field
11. *** Drill down analysis: Multiple layers and conditional formatting
12. *** Practice: Drill down analysis from different perspectives
13. *** Demonstration: Drill down analysis from different perspective
14. MGT tool 1: Root cause analysis
15. MGT tool 2: Root cause analysis
16. Wrap up - Identify root cause

1. Introduction - Create solution
2. Set clear goals for your solution
3. Well organizing your analytics project via 6-Step framework
4. Concise communication to stakeholders
5. Prioritize resources to your solution
6. Wrap up - Create solution

1. Introduction - Evaluate by Pivot Dashboard
2. Part A - Concept and preparation for Pivot Dashboard
3. Ingredients of Pivot DASHBOARD
4. LOOKUP functions: GETPIVOTDATA
5. GETPIVOTDATA in a simple way
6. PivotChart - Create a chart
7. PivotChart - Connect multiple data sources through relationships
8. PivotTable - Top#/Bottom#/Less than/Greater than
9. Charts and Shapes - Formatting and controls
10. Part B - Prepare to build a DASHBOARD
11. Dashboard practice 1: Add data lists in data model
12. Dashboard practice 2: Create the puzzles one by one
13. Dashboard practice 3: Put the puzzles together
14. Wrap up of Dashboard practice / Combo tools: DASHBOARD + PivotTable
15. Wrap up - Evaluation (MRA)

Approx. 10 lessons / tutorials

Expected delivery date (TBA). This bonus module takes time to  break down blurring concept into steps. Customized dashbaord allows you greater flexibility to fulfil your purpose.