Microsoft Excel Training Courses

If you're comfortable in Excel but have never used Copilot for the analysis you already do -- variance reviews, month-end reconciliations, budget tracking -- this course is where that changes. The course moves in a deliberate sequence: get comfortable with what Copilot can and can't do, then practice asking it plain-language questions about your own ledgers and budgets, then use it to write and debug formulas, then apply it to the finance workflows you run every month -- variance analysis, forecasting sanity-checks, scenario narratives, and month-end close support. Each stage builds on the one before it, so by the end of the four hours you have a repeatable way of bringing Copilot into your own recurring reporting cycle.

Analyzing data to find issues, insights, and opportunities is now a critical part of many job roles. Beyond the analysis, data analysts in all job roles must be able to effectively present and communicate their findings in visually compelling ways. Microsoft Excel is designed for this purpose. These capabilities enable people who use Excel for data analysis to turn data into thoughtful action. In this Excel Data Analysis and Visualization Training course, students will learn how to connect to a wide range of data sources, perform data analysis, create diverse and robust data-based visualizations to show insights and trends, and create reports.

If you're already fluent in Excel's day-to-day features, this course is where you start making Excel do the heavy lifting instead of you. It's built for experienced users who are ready to move past single-worksheet thinking: linking and consolidating data across multiple worksheets and workbooks, building lookup formulas that pull the right value out of a large dataset automatically, recording macros to eliminate repetitive manual work, and running what-if analysis and forecasts instead of guessing at trends by eye.

Professionals who are comfortable with Excel fundamentals often reach a plateau: they can enter data and build simple formulas, but still sort data manually, rebuild the same calculations from scratch each month, or struggle to identify a trend within a large dataset without scrolling through hundreds of rows. This course closes that gap, moving beyond basic data entry toward the intermediate functions and tools experienced Excel users rely on daily, applied to realistic business scenarios rather than abstract exercises.

This course is appropriate for professionals in any role who regularly work with data in Excel — including finance, operations, HR, marketing, and administrative professionals — who have completed introductory Excel training or have equivalent working experience.

If you've never opened Excel, or you've poked around in it without ever really learning it, this course is where that changes. The course moves in a deliberate sequence: get comfortable in the interface first, then build formulas and calculations, then format and organize a worksheet so it's actually readable, and finish with printing and exporting a finished file. Each stage builds directly on the one before it, so by the end of the day you're not just familiar with individual features — you can put together a complete, usable worksheet from a blank file.

Power Pivot is a powerful data exploration tool based on in-memory computing technologies that provides unmatched analytical performance to process billions of rows almost instantaneously. In this Microsoft Excel Power Pivot Training course, students will learn how to use Power Pivot to import and manipulate data, create Power Pivot reports, use DAX functions, create key performance indicators (KPI) and use slicers to enhance the visualization of data.

In this Microsoft Excel VBA Training course, students will learn to use VBA in Excel to create interactive worksheets and automate common worksheet tasks. Students will see how to generate VBA code from existing macros, gain an understanding of the different parts of the Visual Basic Editor, learn how code is organized in Projects, Modules and Procedures and become familiar using Objects, Properties and Methods in their code. In addition, this course teaches students how to debug their VBA code to find and fix logic errors, interact with the user using dialog boxes, control formatting of the worksheet using VBA code and how to automate the addition and deletion of workbooks. Finally, students will see how to perform calculations in code and use built-in functions in Excel in VBA to quickly calculate large amounts of data.

If you've used Excel for years but have never touched Copilot -- or clicked the icon once and closed it again -- this course is where that changes. The course moves in a deliberate sequence: get comfortable with what Copilot can and can't do, then practice asking it plain-language questions about your own data, then use it to write and debug formulas, then turn raw numbers into charts and summaries you'd actually send to a colleague. Each stage builds on the one before it, so by the end of the four hours you're not just aware that Copilot exists -- you have a repeatable way of using it in your own recurring reports and lists.