Data Analysis with Excel & Google Sheets
Turn raw spreadsheet data into clear insights using the tools already on your computer.
Module 1: Why Spreadsheets Matter -- Data Literacy Basics
Understand why spreadsheet skills are foundational to nearly every job, and compare Excel and Google Sheets.
Module 2: Navigating the Interface & Entering Data
Get comfortable with the spreadsheet grid, data types, and basic formatting.
Module 3: Essential Formulas & Functions
Learn the core functions used in almost every spreadsheet task: SUM, AVERAGE, COUNT, and IF.
Module 4: Sorting, Filtering & Cleaning Data
Prepare messy real-world data for analysis by sorting, filtering, and removing errors.
Module 5: Lookup Functions -- VLOOKUP and INDEX/MATCH
Pull matching information from another table using lookup formulas, a core data-analysis skill.
Module 6: PivotTables -- Summarizing Large Datasets
Use PivotTables to instantly summarize, group, and analyze large amounts of raw data.
Module 7: Data Visualization -- Charts & Graphs
Choose and build the right chart type to communicate insights clearly.
Module 8: Conditional Formatting & Simple Dashboards
Use visual rules and combine charts, PivotTables, and KPIs into a one-page dashboard.
Module 9: Collaboration & Light Automation in Google Sheets
Share spreadsheets safely and connect them to forms for simple automated data collection.
Module 10: Practical Analysis Projects & Career Applications
Apply your skills to real scenarios -- budgeting, sales reports, survey analysis -- and see where these skills lead.
Sign in to track your progress and earn a certificate.
Sign In / Join Free