Learn Excel from Basics to Advanced: Formulas, Pivot Tables and Power Query
No prior experience, no jargon. Just clear steps, real spreadsheet skills and AI tools that speed up your work.
What if you could clean a messy sheet, look up thousands of values and build a report in minutes instead of hours? This Excel course takes you from your first cell to pivot tables, dynamic charts, macros and Power Query.
You’ll learn the formulas that do 80% of everyday work, keep your data clean and consistent, and turn raw data into reports you can refresh in one click, and you’ll use AI tools such as Copilot and ChatGPT to work faster.
14 days free, then ₹1,770 once · every course included
What Is Excel Used For?
Excel is a spreadsheet tool for organising, calculating, analysing and visualising data. Students, business owners and employees in finance, marketing, HR, operations and education use it for budgets, reports, tracking and decisions. In this course you start with the interface and finish with automation.
What Will You Learn in This Excel Course?
Excel has over 400 functions, but you don’t need all of them. Here’s what you’ll learn:
- Work confidently in Excel: Navigate the ribbon, customise the Quick Access Toolbar, and use Alt shortcuts to work without the mouse.
- Clean and format data properly: AutoFit, wrap text, Find and Replace, borders and number formats, so a sheet looks professional and is easy to read.
- Work faster with ranges, tables and fill tools: Name ranges, paste values and transpose, use Excel Tables, Auto Fill, custom lists and Flash Fill.
- Write formulas that do the work: Use IF, SUMIFS, XLOOKUP, INDEX and MATCH, text and date functions, and understand relative and absolute references.
- Analyse and present data: Sort, filter, highlight with conditional formatting, restrict entries with data validation, and build dynamic charts.
- Summarise and automate: Build pivot tables, record macros, prepare data with Power Query, and protect your files.
- Use AI tools with Excel: Use Copilot and ChatGPT alongside Excel to [describe what’s covered, for example write and explain formulas or clean data], and learn to check what they give you.
The Six Function Families You’ll Use Every Day
Lessons 9 to 15 organise formulas into families. Learn one family at a time, then combine them to solve real problems.
| Function family | What it does | Example (illustrative) |
|---|---|---|
| Logical | Makes decisions and handles errors | IF, AND, OR, IFERROR |
| Math | Adds, rounds and sums with conditions | SUMIFS, ROUND, SUMPRODUCT |
| Lookup and | Fetches values from another | XLOOKUP, VLOOKUP, INDEX with |
| reference | table | MATCH |
| Statistical | Counts, averages and ranks | COUNTIFS, AVERAGEIFS, LARGE, RANK |
| Text | Cleans, splits and joins text | TRIM, LEFT, MID, SUBSTITUTE, TEXT |
| Date and time | Calculates with dates and | EOMONTH, NETWORKDAYS, |
| working days | WORKDAY |
Course Curriculum (23 Lessons)
Eight lessons on getting around and handling data, seven on formulas, then data tools, pivot tables and automation.
AI tools such as Copilot and ChatGPT are used alongside the lessons. [Confirm which lessons include AI demos.]
Lesson 1: Getting Started with Excel
What Excel is for, and a tour of the workbook, worksheet, cell, formula bar and ribbon. Customise the Quick Access Toolbar and ribbon, and learn Alt shortcuts.
Lesson 2: Data Entry, Data Editing and Number Formatting
[Description to be confirmed against the final lesson video.]
Lesson 3: Data Formatting
AutoFit, removing hyperlinks and old formatting, Find and Replace, Merge and Center, borders, colours, text rotation, line breaks and wrap text, plus shortcuts for selecting, inserting and deleting rows and columns.
Lesson 4: Working with Cells and Ranges
Select ranges, name cells and ranges, copy and paste with every paste option, Paste Special, Go To Special, Find and Replace, comments, Quick Analysis and sparklines.
Lesson 5: Managing Worksheets
Rename, colour, hide, move and copy sheets. Compare sheets side by side, split panes, freeze panes, and choose the right file type (.xlsx, .xlsm, .xlsb or .xls).
Lesson 6: Introduction to Excel Tables
Why a Table is more than formatting: filters, dynamic ranges, total rows, structured references and named tables, plus slicers for visual filtering.
Lesson 7: Auto Fill, Custom Lists and Flash Fill
Fill series and dates, create your own lists, and split or combine text with Ctrl+E.
Lesson 8: Number Formatting
Built-in formats and the Format Cells dialog, then custom formats for thousands, leading zeros, percentages, dates and times.
Lesson 9: Excel Formula Basics
The parts of a formula, operator precedence, relative, absolute and mixed references, and formula auditing tools such as Evaluate Formula and Error Checking.
Lesson 10: Logical Formulas
AND, OR, NOT, IF, IFERROR and the IS functions, including a quick method to find bad data in a long list.
Lesson 11: Math Formulas
INT, RAND, RANDBETWEEN, ROUND, SUM, SUMIF, SUMIFS and SUMPRODUCT, with wildcards and conditions.
Lesson 12: Lookup and Reference Formulas
VLOOKUP, HLOOKUP and XLOOKUP, plus INDEX, MATCH and how they work together, and why each tool exists.
Lesson 13: Statistical Formulas
AVERAGE, COUNT, COUNTA, COUNTBLANK, the IF and IFS versions, LARGE, SMALL, RANK, MAX and MIN.
Lesson 14: Text Formulas
LEFT, RIGHT, MID, LEN, case functions, FIND, REPLACE, SUBSTITUTE, TEXT, TRIM and joining text.
Lesson 15: Date and Time Formulas
DAY, MONTH, YEAR, EOMONTH, DATE, TODAY, NOW, WEEKDAY, NETWORKDAYS and WORKDAY, and how Excel stores dates as numbers.
Lesson 16: Data Sorting and Filtering
Single and multi-level sorting, filters by value, date, text, number and colour, and the shortcut that switches filters on and off.
Lesson 17: Conditional Formatting
Highlight rules, duplicates, top and bottom rules, data bars, colour scales, icon sets and formula-based rules that format whole rows.
Lesson 18: Data Validation
Restrict entries to numbers, dates or drop-down lists, add input messages and error alerts, and circle invalid data already in a sheet.
Lesson 19: Introduction to Excel Charts and Dynamic Charts
Choose the right chart, summarise first with a pivot table, format elements, build a combo chart and connect slicers.
Lesson 20: Pivot Tables
Build, group and filter pivot tables. Use slicers and timelines, calculated fields and Show Values As for percentages, variance and running totals. Then link tables in a data model.
Lesson 21: Introduction to Macros and the VB Editor
Record a macro, run it from a button, and look at the VBA code Excel writes for you.
Lesson 22: Power Query
Import, clean and reshape data, then combine files from a folder, merge tables and refresh everything in one click.
Lesson 23: Protection in Excel
Lock cells, protect sheets and workbook structure, and encrypt a file with a password.
Who Should Take This Excel Course?
Students and job seekers
Build the Excel skills employers expect, from clean formatting to lookups and pivot tables, and practise on realistic data.
Analysts, finance, marketing and HR professionals
Speed up reporting with the formulas and tools you’ll actually use daily, and cut repetitive cleaning with Power Query and macros.
Small business owners
Track sales, expenses and stock, build summaries without hiring help, and protect the files that matter.
Whichever group you’re in, the AI tutor is there to explain anything as you learn.
Tools and Features Covered in This Course
- Formulas and functions: The 20% that do 80% of the work, from IF to XLOOKUP.
- Excel Tables and slicers: Dynamic ranges, structured references and visual filters.
- Conditional formatting and data validation: Make data highlight itself and keep bad entries out.
- Charts and PivotTables: Summarise, slice and visualise in a few clicks.
- Macros and VBA: Record steps once and rerun them with a button.
- Power Query: A data cleaning and combining tool that also powers Power BI.
- AI tools (Copilot and ChatGPT): [Describe how each is used in the lessons.]
What Can You Do After This Course?
Clean and organise any data set
Turn messy exports into tidy, consistent tables using formatting, Find and Replace, Flash Fill and Power Query.
Build reports that update themselves
Combine tables, pivot tables, slicers and charts, then refresh when new data arrives.
Automate and protect your work
Record repetitive steps as macros, and lock formulas or encrypt files before you share them.
What to Learn Next
These pair well with this course:
Frequently Asked Questions About Learning Excel
Is this Excel course suitable for beginners?
Yes. It starts with the Excel window and basic formatting, and builds to formulas, pivot tables and automation. No prior experience is needed.
Which version of Excel do I need?
The lessons use a recent desktop version of Excel. Features such as XLOOKUP, spilled results and the built-in Power Query tools need Excel 2021 or Microsoft 365. Most other lessons work in older versions.
How much does the course cost?
The first 14 days are free. After that, Lifetime Access is [price], paid once. Pay once, learn forever.
Do I get practice files?
Yes. The lessons use sample data sets you can download and practise on. [Confirm file availability per lesson.]
Will I learn formulas or only the basics?
You’ll learn the formulas used most in daily work: logical, math, lookup, statistical, text and date and time functions, plus how to combine them.
Do I need to know programming for macros or Power Query?
No. You record macros without writing code, and Power Query’s steps are created by clicking options in the editor.
Will this course help me get a job or freelance work?
It teaches skills employers and clients ask for. TheProfesoralso offers job assistance through the contact option in your app profile, subject to terms, but no course can guarantee work.
Will I get a certificate after completing the course?
TheProfesoroffers completion certificates for eligible courses. Finish all the lessons and check this course’s page in the app for certificate details.
Which AI tools do I need?
The lessons use Copilot and ChatGPT with Excel. [Confirm access: Copilot in Excel depends on your Microsoft 365 plan, and the course fee doesn’t include AI tool subscriptions.]
Turn Messy Data into Clear Answers
Learn the formulas, tools and shortcuts that save hours every week. Go at your own pace, with the 24/7 AI tutor ready whenever you’re stuck.
Step 1 · Start here
Step 1 · Start here
Step 2 · Build skills