Data and AI

Excel and Google Sheets to Analyst Standard

Move beyond basic spreadsheet use to the formula, pivot table, and dashboarding skill real analyst roles actually screen for

14h4 lessonsTier 2 hireabilityTier 2 certificate

What you'll be able to do

You can build lookup-driven formulas, pivot tables, and simple dashboards in Excel and Google Sheets to answer real business questions, and can choose the right spreadsheet tool for a given collaborative or analytical task.

Job titles this qualifies you for

Data AnalystBusiness Intelligence AnalystReporting Analyst
Market intelligence
Demand
High
Remote
78% remote roles
Nigeria salary
Not a primary local hiring category
Remote (USD)
$45,000–$65,000/year for entry-level remote roles; $62,500–$97,000/year broader remote market range; top earners (90th percentile) around $120,500/year

Lessons

Stage 1 — Foundation
1
Lookup Formulas: VLOOKUP, XLOOKUP, and INDEX/MATCH
40 min
2
Pivot Tables for Real Business Questions
40 min
Stage 2 — Applied
1
Conditional Formulas and Data Cleaning in Spreadsheets
35 min
2
Building Simple Dashboards and Choosing the Right Tool
30 min
Tier 2 Proof Submission

Excel and Google Sheets Analyst Portfolio

Demonstrate lookup formula, pivot table, data cleaning, and dashboard-building competence at analyst standard.

1.A VLOOKUP and XLOOKUP comparison against a realistic products/sales scenario
2.A pivot table configuration for a revenue-by-category-by-quarter question
3.A data-cleaning plan for inconsistent, duplicate-containing customer data
4.A simple dashboard layout with deliberately chosen chart types
Create a free account to join this programJoin free →