Turn spreadsheets from a daily chore into an automatic reporting assistant.
Beginner to Intermediate
AI-Powered Excel & Google Sheets
Turn spreadsheets from a daily chore into an automatic reporting assistant.
Career track 04
Data & AI Track
For analytical minds who want to work with data, dashboards and machine learning models.
Jobs this leads to
Data Analyst · Business Analyst · ML Engineer · AI Developer
Why take this course?
1
Spreadsheet work eats hours in almost every Bangladeshi office — automation gives those hours back.
2
Formula and dashboard skills raise entry-level office salaries immediately.
3
AI now writes complex formulas for you, but only if you know what to ask for.
4
Small businesses will pay monthly for a working dashboard they can actually read.
What you will be able to do
- ✓ Clean messy data in minutes instead of hours
- ✓ Write and debug advanced formulas with AI assistance
- ✓ Build automatic dashboards that update themselves
- ✓ Connect Google Sheets to forms, email and other apps
- ✓ Deliver a monthly reporting service to small businesses
Full curriculum
11 chapters · 180 lessons- ▶ Introduction to Spreadsheet Fundamentals Refresher 6m FREE
- 🔒 Why Spreadsheet Fundamentals Refresher matters in real projects 13m
- 🔒 Core concepts of Spreadsheet Fundamentals Refresher 20m
- 🔒 Tools and setup for Spreadsheet Fundamentals Refresher 27m
- 🔒 Step-by-step walkthrough: Spreadsheet Fundamentals Refresher 12m
- 🔒 Hands-on lab 1 — Spreadsheet Fundamentals Refresher 19m
- 🔒 Hands-on lab 2 — Spreadsheet Fundamentals Refresher 26m
- 🔒 Common mistakes in Spreadsheet Fundamentals Refresher 11m
- 🔒 Best practices and standards 18m
- 🔒 Advanced techniques in Spreadsheet Fundamentals Refresher 25m
- 🔒 Case study: Spreadsheet Fundamentals Refresher in industry 10m
- 🔒 Workflow automation for Spreadsheet Fundamentals Refresher 17m
- 🔒 Checklist and cheat sheet 24m
- 🔒 Troubleshooting and debugging 9m
- 🔒 Live demo session — Spreadsheet Fundamentals Refresher 16m
- ▶ Introduction to Data Cleaning and Validation 11m FREE
- 🔒 Why Data Cleaning and Validation matters in real projects 18m
- 🔒 Core concepts of Data Cleaning and Validation 25m
- 🔒 Tools and setup for Data Cleaning and Validation 10m
- 🔒 Step-by-step walkthrough: Data Cleaning and Validation 17m
- 🔒 Hands-on lab 1 — Data Cleaning and Validation 24m
- 🔒 Hands-on lab 2 — Data Cleaning and Validation 9m
- 🔒 Common mistakes in Data Cleaning and Validation 16m
- 🔒 Best practices and standards 23m
- 🔒 Advanced techniques in Data Cleaning and Validation 8m
- 🔒 Case study: Data Cleaning and Validation in industry 15m
- 🔒 Workflow automation for Data Cleaning and Validation 22m
- 🔒 Checklist and cheat sheet 7m
- 🔒 Troubleshooting and debugging 14m
- 🔒 Live demo session — Data Cleaning and Validation 21m
- 🔒 Assignment: apply Data Cleaning and Validation 6m
- 🔒 Quiz & knowledge check 13m
- 🔒 Interview questions on Data Cleaning and Validation 20m
- ▶ Introduction to Lookup, Index and Match Mastery 16m FREE
- 🔒 Why Lookup, Index and Match Mastery matters in real projects 23m
- 🔒 Core concepts of Lookup, Index and Match Mastery 8m
- 🔒 Tools and setup for Lookup, Index and Match Mastery 15m
- 🔒 Step-by-step walkthrough: Lookup, Index and Match Mastery 22m
- 🔒 Hands-on lab 1 — Lookup, Index and Match Mastery 7m
- 🔒 Hands-on lab 2 — Lookup, Index and Match Mastery 14m
- 🔒 Common mistakes in Lookup, Index and Match Mastery 21m
- 🔒 Best practices and standards 6m
- 🔒 Advanced techniques in Lookup, Index and Match Mastery 13m
- 🔒 Case study: Lookup, Index and Match Mastery in industry 20m
- 🔒 Workflow automation for Lookup, Index and Match Mastery 27m
- 🔒 Checklist and cheat sheet 12m
- 🔒 Troubleshooting and debugging 19m
- 🔒 Live demo session — Lookup, Index and Match Mastery 26m
- ▶ Introduction to Pivot Tables That Answer Questions 21m FREE
- 🔒 Why Pivot Tables That Answer Questions matters in real projects 6m
- 🔒 Core concepts of Pivot Tables That Answer Questions 13m
- 🔒 Tools and setup for Pivot Tables That Answer Questions 20m
- 🔒 Step-by-step walkthrough: Pivot Tables That Answer Questions 27m
- 🔒 Hands-on lab 1 — Pivot Tables That Answer Questions 12m
- 🔒 Hands-on lab 2 — Pivot Tables That Answer Questions 19m
- 🔒 Common mistakes in Pivot Tables That Answer Questions 26m
- 🔒 Best practices and standards 11m
- 🔒 Advanced techniques in Pivot Tables That Answer Questions 18m
- 🔒 Case study: Pivot Tables That Answer Questions in industry 25m
- 🔒 Workflow automation for Pivot Tables That Answer Questions 10m
- 🔒 Checklist and cheat sheet 17m
- 🔒 Troubleshooting and debugging 24m
- 🔒 Live demo session — Pivot Tables That Answer Questions 9m
- 🔒 Assignment: apply Pivot Tables That Answer Questions 16m
- 🔒 Quiz & knowledge check 23m
- 🔒 Interview questions on Pivot Tables That Answer Questions 8m
- ▶ Introduction to Writing Formulas with AI Help 26m FREE
- 🔒 Why Writing Formulas with AI Help matters in real projects 11m
- 🔒 Core concepts of Writing Formulas with AI Help 18m
- 🔒 Tools and setup for Writing Formulas with AI Help 25m
- 🔒 Step-by-step walkthrough: Writing Formulas with AI Help 10m
- 🔒 Hands-on lab 1 — Writing Formulas with AI Help 17m
- 🔒 Hands-on lab 2 — Writing Formulas with AI Help 24m
- 🔒 Common mistakes in Writing Formulas with AI Help 9m
- 🔒 Best practices and standards 16m
- 🔒 Advanced techniques in Writing Formulas with AI Help 23m
- 🔒 Case study: Writing Formulas with AI Help in industry 8m
- 🔒 Workflow automation for Writing Formulas with AI Help 15m
- 🔒 Checklist and cheat sheet 22m
- 🔒 Troubleshooting and debugging 7m
- 🔒 Live demo session — Writing Formulas with AI Help 14m
- ▶ Introduction to Conditional Logic and Nested Functions 9m FREE
- 🔒 Why Conditional Logic and Nested Functions matters in real projects 16m
- 🔒 Core concepts of Conditional Logic and Nested Functions 23m
- 🔒 Tools and setup for Conditional Logic and Nested Functions 8m
- 🔒 Step-by-step walkthrough: Conditional Logic and Nested Functions 15m
- 🔒 Hands-on lab 1 — Conditional Logic and Nested Functions 22m
- 🔒 Hands-on lab 2 — Conditional Logic and Nested Functions 7m
- 🔒 Common mistakes in Conditional Logic and Nested Functions 14m
- 🔒 Best practices and standards 21m
- 🔒 Advanced techniques in Conditional Logic and Nested Functions 6m
- 🔒 Case study: Conditional Logic and Nested Functions in industry 13m
- 🔒 Workflow automation for Conditional Logic and Nested Functions 20m
- 🔒 Checklist and cheat sheet 27m
- 🔒 Troubleshooting and debugging 12m
- 🔒 Live demo session — Conditional Logic and Nested Functions 19m
- 🔒 Assignment: apply Conditional Logic and Nested Functions 26m
- 🔒 Quiz & knowledge check 11m
- 🔒 Interview questions on Conditional Logic and Nested Functions 18m
- ▶ Introduction to Charts and Visual Reporting 14m FREE
- 🔒 Why Charts and Visual Reporting matters in real projects 21m
- 🔒 Core concepts of Charts and Visual Reporting 6m
- 🔒 Tools and setup for Charts and Visual Reporting 13m
- 🔒 Step-by-step walkthrough: Charts and Visual Reporting 20m
- 🔒 Hands-on lab 1 — Charts and Visual Reporting 27m
- 🔒 Hands-on lab 2 — Charts and Visual Reporting 12m
- 🔒 Common mistakes in Charts and Visual Reporting 19m
- 🔒 Best practices and standards 26m
- 🔒 Advanced techniques in Charts and Visual Reporting 11m
- 🔒 Case study: Charts and Visual Reporting in industry 18m
- 🔒 Workflow automation for Charts and Visual Reporting 25m
- 🔒 Checklist and cheat sheet 10m
- 🔒 Troubleshooting and debugging 17m
- 🔒 Live demo session — Charts and Visual Reporting 24m
- ▶ Introduction to Automatic Dashboards 19m FREE
- 🔒 Why Automatic Dashboards matters in real projects 26m
- 🔒 Core concepts of Automatic Dashboards 11m
- 🔒 Tools and setup for Automatic Dashboards 18m
- 🔒 Step-by-step walkthrough: Automatic Dashboards 25m
- 🔒 Hands-on lab 1 — Automatic Dashboards 10m
- 🔒 Hands-on lab 2 — Automatic Dashboards 17m
- 🔒 Common mistakes in Automatic Dashboards 24m
- 🔒 Best practices and standards 9m
- 🔒 Advanced techniques in Automatic Dashboards 16m
- 🔒 Case study: Automatic Dashboards in industry 23m
- 🔒 Workflow automation for Automatic Dashboards 8m
- 🔒 Checklist and cheat sheet 15m
- 🔒 Troubleshooting and debugging 22m
- 🔒 Live demo session — Automatic Dashboards 7m
- 🔒 Assignment: apply Automatic Dashboards 14m
- 🔒 Quiz & knowledge check 21m
- 🔒 Interview questions on Automatic Dashboards 6m
- ▶ Introduction to Apps Script and Macro Basics 24m FREE
- 🔒 Why Apps Script and Macro Basics matters in real projects 9m
- 🔒 Core concepts of Apps Script and Macro Basics 16m
- 🔒 Tools and setup for Apps Script and Macro Basics 23m
- 🔒 Step-by-step walkthrough: Apps Script and Macro Basics 8m
- 🔒 Hands-on lab 1 — Apps Script and Macro Basics 15m
- 🔒 Hands-on lab 2 — Apps Script and Macro Basics 22m
- 🔒 Common mistakes in Apps Script and Macro Basics 7m
- 🔒 Best practices and standards 14m
- 🔒 Advanced techniques in Apps Script and Macro Basics 21m
- 🔒 Case study: Apps Script and Macro Basics in industry 6m
- 🔒 Workflow automation for Apps Script and Macro Basics 13m
- 🔒 Checklist and cheat sheet 20m
- 🔒 Troubleshooting and debugging 27m
- 🔒 Live demo session — Apps Script and Macro Basics 12m
- ▶ Introduction to Connecting Sheets to Other Tools 7m FREE
- 🔒 Why Connecting Sheets to Other Tools matters in real projects 14m
- 🔒 Core concepts of Connecting Sheets to Other Tools 21m
- 🔒 Tools and setup for Connecting Sheets to Other Tools 6m
- 🔒 Step-by-step walkthrough: Connecting Sheets to Other Tools 13m
- 🔒 Hands-on lab 1 — Connecting Sheets to Other Tools 20m
- 🔒 Hands-on lab 2 — Connecting Sheets to Other Tools 27m
- 🔒 Common mistakes in Connecting Sheets to Other Tools 12m
- 🔒 Best practices and standards 19m
- 🔒 Advanced techniques in Connecting Sheets to Other Tools 26m
- 🔒 Case study: Connecting Sheets to Other Tools in industry 11m
- 🔒 Workflow automation for Connecting Sheets to Other Tools 18m
- 🔒 Checklist and cheat sheet 25m
- 🔒 Troubleshooting and debugging 10m
- 🔒 Live demo session — Connecting Sheets to Other Tools 17m
- 🔒 Assignment: apply Connecting Sheets to Other Tools 24m
- 🔒 Quiz & knowledge check 9m
- 🔒 Interview questions on Connecting Sheets to Other Tools 16m
- ▶ Introduction to Client Reporting Packages 12m FREE
- 🔒 Why Client Reporting Packages matters in real projects 19m
- 🔒 Core concepts of Client Reporting Packages 26m
- 🔒 Tools and setup for Client Reporting Packages 11m
- 🔒 Step-by-step walkthrough: Client Reporting Packages 18m
- 🔒 Hands-on lab 1 — Client Reporting Packages 25m
- 🔒 Hands-on lab 2 — Client Reporting Packages 10m
- 🔒 Common mistakes in Client Reporting Packages 17m
- 🔒 Best practices and standards 24m
- 🔒 Advanced techniques in Client Reporting Packages 9m
- 🔒 Case study: Client Reporting Packages in industry 16m
- 🔒 Workflow automation for Client Reporting Packages 23m
- 🔒 Checklist and cheat sheet 8m
- 🔒 Troubleshooting and debugging 15m
- 🔒 Live demo session — Client Reporting Packages 22m