Microsoft Excel 2026: Beginner to Advanced with AI Tools

Explore the Excel interface, build organized spreadsheets, and master functions and calculations to analyze large data sets. Visualize results, summarize trends, and collaborate by sharing workbooks and comments.

Link data across worksheets using cell referencing and named ranges, explore data navigation, selecting ranges, filtering, and tables, and customize the quick access toolbar.

Master Excel basics: write formulas with the equals sign, apply pemdas, and use sum, average, min, max, index, match, and if functions, with absolute, relative, and mixed references.

Master VLOOKUP and HLOOKUP to locate data in Excel, understand exact and approximate matches, table arrays, and left side lookups via index match.

Learn common Excel errors—div by zero, NA, name, null, numb, reference, and value errors—how they occur and how to mitigate them, including using IFERROR to display alternatives.

Learn to navigate between worksheets and workbooks using keyboard shortcuts, insert, delete, rename, and move or copy sheets, and define named ranges to link data across the workbook.

Master Excel formulas like sumif, countif, rand, and randbetween, plus array and sort functions, to perform conditional sums, generate random values, and sort datasets.

Create pivot tables from your data range via the insert tab to sum sales by city and year, then customize with slicers and pivot charts for interactive analysis.

Apply data validation to enforce whole numbers between 100 and 500, and use conditional formatting to highlight entries, including custom data validation with a formula for numeric input.

Learn to manage large datasets by applying filters, pivot tables, data tables, and unique values, along with data validation, conditional formatting, and collaboration via Excel's sharing features.

Discover how Excel partners with business analytics to analyze data, tackle problems, and make informed decisions using descriptive analytics, regression, and forecasting.

Explore prescriptive analytics to identify changes that boost business operations, with examples analyzing credit risk and loan default, and learn how data types and structures enable analysis and visualization.

Explore descriptive analytics in Excel, using pivot tables and conditional formatting to summarize historical data, visualize trends with charts, and manage data access with protected sheets.

Master data organization in Excel by using vlookup, hlookup, and index match across sheets; create unique identifiers and dynamic data models for business analytics.

Leverage regression to set monthly sales targets for different sales representatives based on remote work status, Microsoft Teams usage, and monthly activity, using data-driven assumptions and daily call averages.

Explore how to forecast sales and analyze business trends using Excel's waterfall chart to visualize running totals, positive and negative values, and the impact of expenses and growth.

Analyze competition and sustainable growth using Excel-based business analytics: apply regression to link marketing cost to sales, compare payroll and cost of sales, and optimize marketing with solver.

Explore data-driven pricing and profitability using solver, sensitivity analysis, and scenario manager to optimize product price, marketing costs, and premium vs basic user strategies for real-world business decisions.

Create, edit, and format charts in Excel to visualize data. Explore chart types such as column, line, pie, bar, area, and combo, and apply styles and themes.

Learn to customize Excel charts by adjusting orientation, switching rows and columns, moving and resizing across sheets, and selecting data sources with templates and themes.

Modify axis values and formatting to shape chart appearance. Link chart titles to cells and add data labels, data tables, grid lines, legends, and trend lines for clarity.

Add shape effects such as shadows and glows to professional charts by inserting icons, stacking elements, and adjusting colors, fonts, and grid lines for a visually appealing data presentation.

Master diverse chart types, including column, bar, line, area, pie, and donut charts, and tailor visuals with 3d effects, rotations, templates, and quick layouts to make data stand out.

Master how to add labels, legends, and annotations to Excel charts, and create combo, stock, scatter, bubble, and radar charts with clear axes and color customization for effective data storytelling.

Master rotating chart text and explore in-cell chart alternatives by creating treemap, sunburst, histogram, box-and-whisker, pareto, funnel, and geographic maps with labeling and color options.

Discover how macros and VBA automate Excel reporting and generate reports in seconds. Learn to create and use macros to streamline workflows in this module.

Learn to record and run macros in Excel, save them in workbook or personal macro workbook, and explore the Visual Basic Editor to see how code drives automation.

Edit and enhance macros using the Visual Basic editor, covering modules, objects, properties, methods, and events. Master comments and naming macros to boost VBA efficiency.

Master debugging VBA in Excel by following a structured process: set up the environment with backups, run code with errors, step through lines, and verify fixes with Visual Basic Editor.

Use the range object to select cells, enter data via VBA, and run macros that update the sheet, while the immediate window reveals the active sheet name.

Learn how to declare and use variables in VBA with dim, data types, and meaningful names, then master for next and do while loops to control repetition and manipulate cells.

Learn to build VBA apps in Excel by using offset to move cells, copy and paste, select ranges, auto fit columns, and control actions with call, end, and font properties.

Learn to use Copilot in Excel to automatically analyze data with prompts and reveal insights. Compare manual steps to single-prompt automation for category sales, regional performance, and distinct product counts.

Learn to edit and organize data in Excel using AI Copilot, highlighting bottom three sales, sorting by sales from highest to lowest, filtering top ten, and applying color scales.

Plan an Excel dashboard with wireframing to place data points, charts, tables, and filters; align elements for a clear, single-view sales dashboard.

Create an interactive dashboard by building pivot tables for sales by year and profit, then connect slicers for category, segment, and city to reveal insights.

Explore advanced dashboard techniques in Excel 2025, including creating charts for sales and price trends, building pivot tables, applying dynamic formatting, and configuring slicers for interactive dashboards.