Excel with Claude: Zero to Data Analyst

About Course

Master Excel from zero using Claude AI as your co-pilot.
Learn formulas, PivotTables, Power Query, DAX and build
real analyst projects — 9 modules, 38 lessons, 17 hours
of 100% practical content built for Indian professionals.

Course Content

🔰 MODULE 1 — Excel Foundations

1.1 What Claude Can Do for Excel Users
1.2 Spreadsheet Structure — Cells, Rows, Columns, Ranges
1.3 Data Types and Formatting
1.4 Excel Tables — The Most Underused Feature
1.5 Workbook Organisation and Navigation

📐 MODULE 2 — Core Formulas and Functions

⚡ MODULE 3 — Advanced Formulas

🧹 MODULE 4 — Data Cleaning and Transformation

📊 MODULE 5 — PivotTables and Advanced Charts

⚙️ MODULE 6 — Power Query — Data at Scale

📈 MODULE 7 — Statistical Functions for Analysts

🗄️ MODULE 8 — Power Pivot and Data Modelling

🏆 MODULE 9 — Real World Analyst Projects

Student Ratings & Reviews

No Review Yet

About Course

What Will You Learn?

Course Content

🔰 MODULE 1 — Excel Foundations

1.1 What Claude Can Do for Excel Users

1.2 Spreadsheet Structure — Cells, Rows, Columns, Ranges

1.3 Data Types and Formatting

1.4 Excel Tables — The Most Underused Feature

1.5 Workbook Organisation and Navigation

📐 MODULE 2 — Core Formulas and Functions

2.1 SUM, AVERAGE, COUNT Family

2.2 IF Logic — Conditions and Decisions

2.3 VLOOKUP, XLOOKUP, HLOOKUP

2.4 Text Functions

2.5 Date and Time Functions

⚡ MODULE 3 — Advanced Formulas

3.1 SUMIF, COUNTIF, AVERAGEIF — Conditional Aggregations

3.2 INDEX and MATCH

3.3 Dynamic Arrays — UNIQUE, FILTER, SORT, SEQUENCE

3.4 INDIRECT, OFFSET and Dynamic References

3.5 Error Handling — IFERROR, ISERROR, IFNA

🧹 MODULE 4 — Data Cleaning and Transformation

4.1 Auditing Messy Data with Claude

4.2 Deduplication and Standardisation

4.3 Splitting and Combining Columns

4.4 Data Validation — Preventing Bad Data

📊 MODULE 5 — PivotTables and Advanced Charts

5.1 PivotTable Fundamentals

5.2 Calculated Fields and PivotTable Advanced Features

5.3 Chart Selection and Design Principles

5.4 Conditional Formatting for Insight

5.5 Dashboard Design and Layout

⚙️ MODULE 6 — Power Query — Data at Scale

6.1 What is Power Query and When to Use It

6.2 Importing and Connecting Data Sources

6.3 Transforming Data in Power Query

6.4 Merging and Appending Queries

6.5 Automating Refresh and Building Reusable Queries

📈 MODULE 7 — Statistical Functions for Analysts

7.1 Descriptive Statistics in Excel

7.2 Correlation and Forecasting

7.3 What-If Analysis — Goal Seek and Scenario Manager

7.4 LAMBDA and Custom Functions

🗄️ MODULE 8 — Power Pivot and Data Modelling

8.1 Introduction to Power Pivot and Data Models

8.2 DAX Basics — Calculated Columns and Measures

8.3 Building PivotTables from Data Models

8.4 Time Intelligence in DAX

🏆 MODULE 9 — Real World Analyst Projects

9.1 End-to-End MIS Reporting Workflow

9.2 Analysing Real Data with Claude — Full Workflow

9.3 Advanced Claude Prompting for Excel

9.4 Capstone — Zero to Analyst Project

Student Ratings & Reviews