
Get introduced to the Excel interface, ribbon, cells, rows, columns, and basic navigation to build a strong starting point.
Learn how to add numbers and cell values using simple formulas in Excel.
Learn how to subtract values and use cell references for calculations.
Learn how to multiply numbers and automate repetitive calculations.
Learn how to divide values and handle division-based formulas in Excel.
Learn to quickly add up a range of numbers using the SUM function.
Calculate the mean of a dataset using the AVERAGE function.
Learn how to count numeric entries in a dataset using the COUNT function.
Find the highest value in a dataset using the MAX function.
Find the lowest value in a dataset using the MIN function.
Learn how to calculate percentages for real-world use cases like marks, discounts, and growth.
Organize and filter your data efficiently to find exactly what you need.
Learn how to apply conditional logic in Excel using the IF function.
Handle multiple conditions at once using the IFS function.
Combine multiple IF statements to solve complex logical problems.
Check if multiple conditions are true using the AND function.
Check if at least one condition is true using the OR function.
Combine IF and AND functions to apply multiple conditions together.
Combine IF and OR functions for flexible conditional logic.
Search and retrieve data from another table using the VLOOKUP function.
Make your VLOOKUP formulas flexible and automatically updatable.
Search and retrieve data horizontally across rows using HLOOKUP.
Sum values based on a single condition using the SUMIF function.
Count values based on a single condition using the COUNTIF function.
Calculate the average based on a single condition using AVERAGEIF.
Extract characters from the beginning of a text string.
Extract characters from the end of a text string.
Extract characters from the middle of a text string.
Count the number of characters in a text string.
Remove extra spaces from text data for cleaner formatting.
Combine text from multiple cells into one.
Do you want to master Microsoft Excel from the very basics to advanced level — while also learning how to use AI tools to work faster and smarter? This complete Excel course is designed for absolute beginners as well as working professionals who want to upgrade their skills.
You will start with the fundamentals of Excel, including the interface, cells, formulas, and basic calculations like addition, subtraction, multiplication, and division. From there, you will move into essential functions such as SUM, AVERAGE, COUNT, MAX, and MIN, along with practical skills like calculating percentages, sorting, and filtering data.
As you progress, you will learn powerful intermediate and advanced functions including IF, IFS, Nested IF, AND, OR, VLOOKUP, HLOOKUP, SUMIF, COUNTIF, AVERAGEIF, text functions like LEFT, RIGHT, MID, and TRIM, along with tools like Flash Fill and Paste Special. You will also master advanced functions such as SUMIFS, COUNTIFS, INDEX+MATCH, XLOOKUP, and date and time functions.
A dedicated section on PivotTables will teach you grouping, slicers, timelines, report connections, and pivot charts to summarize and visualize data effectively.
You will also work on real-life case studies including business analysis, car sales analysis, restaurant sales analysis, HR dataset analysis, and building a loan EMI calculator — giving you hands-on, practical experience.
Finally, you will explore how Artificial Intelligence is transforming the way we work in Excel, learning how to use Excel's built-in Analyze Data feature, ChatGPT, Microsoft Copilot, and Claude for data cleaning, formula generation, dashboard building, and management reporting.
By the end of this course, you will be confident using Excel for real-world office tasks, career growth, and data-driven decision-making — combining traditional manual skills with modern AI-powered techniques.