Data & AnalyticsBeginner
Excel & Google Sheets Mastery
Go from basic spreadsheets to powerful data analysis without writing code.
16 hoursRaj Patel4.8 (14,200 learners)
About this course
A comprehensive spreadsheet course covering Microsoft Excel and Google Sheets side by side. You will master formulas, pivot tables, charts, VLOOKUP, XLOOKUP, dynamic arrays, conditional formatting, and data validation — building four real business dashboards during the course.
Target audience: Office professionals, analysts, students, small business owners
What you will learn
- Excel
- Google Sheets
- Pivot tables
- XLOOKUP
- Data visualisation
- Power Query
Course syllabus
10 modules · video + exercises
- 1Spreadsheet fundamentals: cells, ranges, and references
- 2Essential formulas: SUM, IF, COUNTIF, SUMIF, and nested logic
- 3Lookup functions: VLOOKUP, HLOOKUP, INDEX-MATCH, and XLOOKUP
- 4Text and date functions: CONCAT, LEFT, RIGHT, DATEIF, and more
- 5Pivot tables: summarising, filtering, and grouping data
- 6Charts: choosing the right chart type and customising it
- 7Dynamic arrays: FILTER, SORT, UNIQUE, and SEQUENCE
- 8Data validation and dropdown lists
- 9Conditional formatting: rules, colour scales, and data bars
- 10Power Query (Excel) / ImportRange (Sheets): connecting data sources
Prerequisites
- –Basic computer literacy
Frequently asked questions
Do I need a paid Excel licence?
No. All Excel exercises can be completed with the free Excel web version (excel.live.com) or with Google Sheets. The course notes where the two differ.
Ready to start Excel & Google Sheets Mastery?
Join 14,200+ learners already enrolled. Self-paced, certificate on completion.