Video is being uploaded

The lesson notes below are ready. Add a YouTube id or a Bunny Stream link for this lesson in the admin portal and the player appears here.

Open the course playlist

Module 02 · Excel & Google Sheets for AnalystsFREE LESSON18 min

Workbook Setup and Keyboard Speed

Freeze panes, named ranges, tables, and the 20 shortcuts that save hours.

By the end of this lesson you can

Convert a range into a structured table
Navigate without the mouse

Found this useful? Send it on.

This lesson is free — whoever you send it to can watch it without an account.

Lesson feedback

No ratings for this lesson yet.

Ethics, Privacy and Bias Formatting That Communicates

Course content

0/73

01Data Analysis Foundations

0 / 9

02Excel & Google Sheets for Analysts

0 / 11

Excel & Google Sheets for Analysts

0 / 11

Spreadsheet Essentials

0 / 3

1.Workbook Setup and Keyboard SpeedFree
2.Formatting That Communicates15m
3.Sorting, Filtering and Slicers14m

Exercises

1.Join Orders to Customers with XLOOKUP
2.Pivot a Year of Sales Four Ways

Interview Q&A

1.Excel Interview Questions

Formulas and Functions

0 / 3

Pivot Tables and Charts

0 / 3

Cleaning Data in Spreadsheets

0 / 2

Mini projects

1.Retail Sales Dashboard in Excel

03Statistics for Data Analysts

0 / 11

Mini projects

1.A/B Test Analysis for a Checkout Change

04SQL for Data Analysis

0 / 12

Mini projects

1.E-commerce SQL Analysis

05Python for Data Analysis

0 / 12

Mini projects

1.EDA on Indian Startup Funding

06Business Intelligence with Power BI

0 / 9

Mini projects

1.Executive Sales Dashboard in Power BI

07Capstone Projects & Career Preparation

0 / 9

Capstone projects

1.Capstone — Telecom Customer Churn, End to End

Stay updated