What you will learn

Explain what data analysis is and walk the full analytics workflow
Open a workbook and spot data quality problems before analysing anything
Clean data with Remove Duplicates, filters and the text functions
Answer business questions with IF, IFS, SUMIFS, COUNTIFS and AVERAGEIFS
Pull data across tables with XLOOKUP and summarise it with PivotTables
Build a one-page dashboard whose every title states a finding

Five weeks and twenty classes that take you from "what is data analysis?" to a finished, one-page Excel dashboard a business owner can act on. You learn on one real workbook in every live and virtual class: TechPlug Sales Data, 1,070 sales of phones, laptops, TVs, appliances and accessories across ten Nigerian branches from January to March 2024, with its Product Catalogue, Staff Directory and a ten-step Cleaning Process. You prove it with your pod on Verdant Foods Nigeria, a 470-row FMCG file with deliberate dirty data that you clean, analyse and turn into a dashboard across Weeks 2 to 5. Data cleaning, text functions, IF and IFS, SUMIFS and COUNTIFS, XLOOKUP, PivotTables, slicers and dashboard design.

Lessons

1 Start Here: How the Excel Track Works 13 min 2 Week 1, Live 1: What Is Data Analysis? 18 min 3 Week 1, Virtual 1: The Workflow and Tools in Real Life 6 min 3 Week 1, Virtual 1: The Workflow and Tools in Real Life 6 min 4 Week 1, Live 2: The Excel Interface, Data Types and Importing a CSV 19 min 5 Week 1, Virtual 2: Reading a Dataset With Fresh Eyes 14 min 6 Week 2, Live 1: Removing Duplicates and Handling Blank Cells 17 min 7 Week 2, Virtual 1: Blank Handling Practice and LEFT, RIGHT, MID and LEN 12 min 8 Week 2, Live 2: Cleaning Text With TRIM, PROPER, UPPER, LOWER, CLEAN, FIND and SUBSTITUTE 24 min 9 Week 2, Virtual 2: Text Cleaning Practice, and Your First Look at Verdant Foods 14 min 10 Pod Task Week 2: Clean the Verdant Foods Data 9 min 11 Week 3, Live 1: How Formulas Work, the Basic Functions, and IF, IFS, AND, OR 23 min 12 Week 3, Virtual 1: Calculated Columns and Conditional Formatting 11 min 13 Week 3, Live 2: SUMIF, COUNTIF, AVERAGEIF and Their S Versions 12 min 14 Week 3, Virtual 2: Conditional Aggregation Practice 6 min 15 Pod Task Week 3: Analyse the Verdant Foods Data 8 min 16 Week 4, Live 1: VLOOKUP, XLOOKUP, INDEX and MATCH, and Lookup Errors 18 min 17 Week 4, Virtual 1: Lookup Practice and Data Validation 9 min 18 Week 4, Live 2: PivotTables, PivotCharts, Slicers and Power Query 13 min 19 Week 4, Virtual 2: PivotTable Practice 7 min 20 Pod Task Week 4: Build the Verdant Foods Dashboard 7 min 21 Week 5, Live 1: Dashboard Design Principles 8 min 22 Week 5, Virtual 1: Dashboard Review and Peer Feedback 5 min 23 Week 5, Live 2: Excel Track Review and What Comes Next 7 min 24 Week 5, Virtual 2: Final Pod Review and Submission Preparation 5 min 25 Pod Task Week 5: Final Submission 4 min