Dive into the fundamentals of Excel, from navigating the interface and entering data to building formulas with functions like SUM, AVERAGE, and IF. You'll sort and filter data, create charts, and manage worksheets and workbooks to organize and present information with confidence.

Learn how to turn raw Excel data into a connected data model with Power Pivot, DAX measures, and an interactive dashboard that updates automatically. Starting from a flat table, you will build relationships between multiple tables, write calculated metrics, and deliver a polished, reusable report — all inside Excel. Suitable for Excel users with basic experience who want to move beyond flat-sheet reporting.

Unlock the full potential of Excel by learning how to use formulas and functions to simplify tasks, analyze data, and work more efficiently. You'll explore everything from basic arithmetic and conditional logic to dynamic arrays and powerful lookup tools like VLOOKUP, MATCH, and INDIRECT. With practical examples and clear explanations, you'll build a solid foundation and discover smarter ways to manage and manipulate your spreadsheets.

Data Analysis with Excel provides a practical guide to mastering the most essential data management, manipulation, and analysis techniques using Microsoft Excel. You'll gain proficiency in Excel's powerful capabilities, progressing through data analysis methods, and creating dynamic visualizations and interactive dashboards. By the end, you'll learn to automate reporting and apply advanced analytics, equipping you to make informed, data-driven decisions efficiently.

Master Excel Pivot Tables from the ground up. Learn how to prepare structured data, build powerful summaries, analyze results across multiple dimensions, and create interactive reports and dashboards using slicers, timelines, and Pivot Charts.

Learn how to confidently value a business using Discounted Cash Flow (DCF) modeling. This practical course walks you through the entire valuation process—from understanding key financial concepts to building a complete DCF model in Excel. You'll explore core topics like free cash flows, discount rates, cost of equity, WACC, terminal value, and scenario analysis. With step-by-step examples, downloadable templates, and a real-world case study, you'll gain hands-on experience applying DCF in professional settings. Whether you're an aspiring analyst, investor, or business owner, this course gives you the tools to calculate intrinsic value and make informed financial decisions.

Master data retrieval in Excel using both classic and modern lookup techniques. Learn how to work with VLOOKUP, XLOOKUP, INDEX, XMATCH, and dynamic array functions to find, filter, and organize information efficiently. Build flexible lookup formulas used in real business spreadsheets.

Master column, line, pie, scatter, combo, and waterfall charts to communicate data clearly in Excel. Apply trendlines, secondary axes, Excel Tables, slicers, dynamic formula-driven ranges, and sparklines to build interactive visual reports.

Study how to clean, organize, and prepare data in Excel to ensure accuracy and reliability in your analysis. You'll understand why raw data is often messy and how improper formatting or errors can lead to incorrect results.

Master Excel's dynamic array features through practical, column-based tasks. Learn to leverage spill behavior, core dynamic array functions, and advanced multi-step logic for efficient, modern spreadsheet solutions.

Find out how to work faster and more efficiently in Excel by eliminating repetitive actions and optimizing everyday workflows. You'll learn how to navigate large datasets, enter and edit data at scale, and use smart techniques to reduce manual work. By combining shortcuts, automation tools, and practical strategies, you'll be able to handle tasks in seconds that would normally take minutes — building a faster, cleaner, and more productive way of working in Excel.

Discover how to build reliable data entry systems in Excel — from basic input rules and dropdown lists to dynamic, formula-driven validation logic that enforces real business rules and keeps your data clean from the start.

A practical, hands-on guide to building professional forecasting and scenario analysis systems in Excel. Starting from raw transactional data, it progressively develops a complete planning model — cleaning and structuring data, applying four distinct forecasting methods, modeling Best Case, Worst Case, and Expected Case scenarios, and projecting revenue, costs, cash flow, and workforce requirements forward. Accuracy measurement, variance analysis, and goal-seeking techniques close the analytical loop. The final section brings everything together into executive-ready dashboards, risk visualizations, and auto-updating reports built on PivotTables and live scenario toggles.

Learn how to collaborate professionally inside shared Excel workbooks using modern cloud-based workflows. In this course, you will explore file sharing, real-time editing, comments, version control, workbook protection, and professional file organization practices used in modern business environments.

Discover how to transform Excel from a static spreadsheet tool into a powerful engine for business automation. This course takes you from writing your very first macro to building a complete, multi-step workflow that imports data, generates reports, and sends emails — all with a single click. Master the core VBA skills that let you eliminate repetitive manual work: reading and writing data at scale, building interactive forms, automating tables and PivotTables, and handling errors like a professional developer. Along the way, you'll get hands-on experience with realistic business scenarios — invoicing, batch file processing, and reporting — using sample datasets built specifically for practice. By the end, you'll have the confidence and technical foundation to design your own automation solutions, saving hours of manual effort in real spreadsheets you use every day.