
Here’s a quick roadmap of all the sections we’ll work on together — from Excel basics to AI integration, dashboards, and automation.
Explore worksheet basics, including managing sheets in a workbook: add, delete, rename, move, adjust rows and columns, resize, hide or unhide, and zoom for clear data.
Master lookup functions in Excel using VLOOKUP, HLOOKUP, INDEX, and MATCH to retrieve scores from tables, with exact and approximate matches, edge lookups, and nested if usage.
Explore Excel mastery by sorting data, applying powerful filters, and enforcing 0–100 data validation with drop-down lists for clean, reliable spreadsheets.
Discover essential Excel shortcuts for fast navigation, selection, worksheet switching, and editing, including Ctrl shortcuts, page navigation, and basic find, spell check, and file commands.
Learn how to handle not found errors with Xlookup, customize not found messages, and perform exact, next smaller, and next larger matches for vertical and horizontal lookups in Excel.
Learn to master xlookup with wildcard matching to retrieve salaries from partial names, using star wildcards and handling not found results.
Learn how line charts visualize continuous data, reveal trends over time, and compare daily sales across brands using axis details, legends, and chart types.
Explore how area charts differ from line charts, adjust transparency and fills for multiple data series, and apply stacked and 100% stacked area charts (including 3d) to improve readability.
Learn to create pie charts in Excel to show relative proportions with few data points, add data labels and category names, and explore donut and pie of pie options.
Learn to organize data with frequency distribution, group scores into intervals, and visualize frequencies in Excel using histograms and Pareto charts.
Master how waterfall charts visualize value changes from a starting point to a final result, with hands-on examples and step-by-step Excel guidance on creating and setting totals.
Explore sunburst and treemap hierarchies in Excel, demonstrating how hierarchical data with categories and subcategories is represented with proportional sizes using concentric circles or rectangles.
Excel Mastery: Beginner to Expert – Integrated with AI is designed to help you gain complete confidence in Excel — from the basics to advanced features, all in a simple and practical way.
Whether you’re a student, professional, business owner, or someone looking to boost your data skills, this course will guide you step-by-step through every essential Excel tool and function.
You’ll start with Excel basics such as navigating the interface, formatting data, and using common formulas. Then, you’ll move on to advanced functions like VLOOKUP, XLOOKUP, PivotTables, PivotCharts, and Power Query to clean and analyze data efficiently.
One of the highlights of this course is learning how to integrate AI tools like ChatGPT and Microsoft Copilot to save time and make smarter data-driven decisions. You’ll also build interactive dashboards and work on real-world projects to apply your skills immediately.
By the end of this course, you’ll be able to confidently manage data, automate repetitive tasks, and create insightful reports and dashboards that impress colleagues and employers. You’ll also gain the confidence to tackle common workplace challenges and streamline your workflow using Excel’s hidden gems.
No prior Excel experience is required — just a computer with Excel installed, curiosity to explore, and a willingness to learn!