Complete Excel for Beginners: From Basics to Copilot 2026

Master text, numbers, and dates input and formatting in Excel, including indentation, decimal consistency, leading zeros, wrap and justify text, and center across selection for clean, error-free data.

Learn to input and manage date and time data in Excel, understand serial date numbers, apply formats including ISO 8601, and perform date-time calculations with practical shortcuts.

Explore Excel's number formats from currency and accounting to percentage and custom formats, learn symbols like zero, hash, and question mark, and master alignment and conditional formatting for professional spreadsheets.

Create and copy formulas using cell references, the pointing method, and fill handle to auto-sum Q1 and Q2 sales data with Excel's autocomplete and autosum features.

Explore autofill and custom lists in Excel, recognizing patterns to fill numbers, text, dates, and weekdays, and create or import custom lists for efficient data entry.

Master Excel's Flash Fill to automate data transformation without formulas, learning to separate and combine names, generate emails, extract initials, codes, and dates with Ctrl E patterns.

Learn to enforce data quality in Excel using data validation: set input messages, restrict numbers to 1–50, build drop-downs from lists, apply date ranges, and customize error alerts.

Utilize go to special in Excel to locate blank cells, highlight and fill missing data, and standardize categories, dates, and formulas for accurate analysis.

Master the format painter to copy bold, blue fill, and borders across cells, and set custom borders with the Format Cells dialog. Learn grid lines versus borders for printing.

Explore Excel's conditional formatting to highlight data, identify top and bottom values, find duplicates, visualize dates and sales with data bars and icons, and manage rules for efficient large datasets.

Master how to add, edit, and format pictures, shapes, and text boxes in Excel by building a simple invoice, exploring placement options, sizing, alignment, grouping, and locking for templates.

Explore notes and comments in Excel 365, distinguishing personal memos from collaborative threaded discussions, and learn to add, edit, convert, copy, manage, and print them for inventory sheets.

Build a simple product management dataset by completing five hands-on missions, mastering date formatting, filling blanks, autofill, flash fill, and data validation in Excel.

Learn to create, rename, delete, organize, hide, unhide, color, copy, and move worksheets within workbooks, and navigate efficiently with keyboard shortcuts across workbooks.

Insert, delete, and move rows and columns with Ctrl Shift Plus, Ctrl Minus, and drag. Group data with auto outline, hide and unhide, and adjust column widths for readability.

Learn how to use freeze panes and split in Excel to keep headers visible, compare far-apart data regions, and navigate large spreadsheets efficiently.

Master advanced copy and paste techniques in Excel, including transpose, skip blanks, arithmetic operations, paste link, paste as picture, and keeping source column widths for data consolidation and analysis.

Apply the same operations across multiple worksheets using group editing, selecting consecutive or non-consecutive tabs, with headers, footers, and formatting synchronized across all grouped sheets.

Protect and manage Excel worksheets with cell locking and sheet protection. Use passwords, allow edit ranges, and workbook protection settings for secure collaboration.

Master creating a navigation sheet in Excel with hyperlinks to department sheets, external sites, and email actions, plus back-navigation to the main dashboard for efficient, scalable workbooks.

Practice five worksheet management techniques—freeze panes, split, move and reorder columns, transpose data, and protect specific columns—using real-world regional sales data to boost accuracy in large reports.

Master formula basics by distinguishing formulas from functions, using cell references and ranges, and applying mixed formulas with operators, Bodmas order, boolean values, and comparison operators.

Explore the three cell reference types—relative, absolute, and mixed—and learn how copying formulas with the fill handle or F2 editing affects references during calculations.

Explore practical business formula patterns in Excel, from discounted prices to growth rates. Learn conditional calculations, cumulative totals, tax brackets, and weighted averages for real-world data.

Define cell names to improve formula clarity in Excel, using the name box or define name dialog for tax rate and discount rate, and fixed references across sheets.

Learn to prevent and troubleshoot Excel formula errors by separating variables from constants, maintaining consistent formulas, and using if functions for common error types.

Learn to create formulas across multiple sheets and external workbooks, using cross-sheet references, autofill, and summing across regions while managing sheet name rules and external links.

Practice four hands-on excel missions to apply formulas for bonuses, region forecasts, cumulative sales and targets, and season-based data totals.

Master the basics of Excel functions, including syntax and arguments, with examples of numbers, cell references, text, and logical values, and learn autocomplete and the function wizard.

Explore Excel's aggregate functions, including sum and average, plus conditional sumifs and averageifs, using offline and online sales data. Learn autosum shortcuts, dynamic references, and data validation for interactive analysis.

Learn to use Excel's count functions: count, counta, countblank, and countifs, plus wildcards to analyze HR training data, including attendance and test scores.

Master the subtotal function to dynamically aggregate only visible data under filter conditions, analyzing revenue by vehicle and state and building simple dashboards.

Master max and min functions, including maxifs and minifs, to analyze data with multiple ranges and conditions. Apply these conditional logic techniques to regional sales data.

Master the if function and conditional logic in Excel, using and, or, and nested ifs. Apply the ifs function to evaluate sales against targets and determine commissions and bonus eligibility.

Learn to apply Excel rounding functions, including round, roundup, and rounddown, to change actual values to a number of decimal places or negative digits, not just display; useful for budgeting.

Master left, mid, and right text extraction in Excel to pull category, product type, and color from codes, using find to locate hyphens and handle variable lengths.

Master Excel date functions for dynamic today and now timestamps, static date logging with shortcuts, and workday and holiday calculations for project deadlines and schedule management.

Learn time calculation functions in Excel and how time values are stored as fractions of a day. Convert to hours, extract hours, minutes, seconds, and use mod for time calculations.

Learn how Vlookup performs vertical lookups to match product IDs with names and stock across tables using exact matches. Explore error handling with iferror and ifna, and compare with Xlookup.

learn how index and match overcome vlookup's limitations by locating positions with match and retrieving data with index, enabling flexible multi-criteria lookups and dynamic arrays.

Master the indirect function to dynamically reference data across multiple worksheets, build region-based dashboards with drop-downs, and combine with Vlookup and the row function for automatic updates.

Practice five hands-on missions using core Excel functions—sumif, if, left, workday, and vlookup—to compute manager sales, assess targets, extract category codes, forecast delivery dates, and look up product names.

Master spill ranges and dynamic array formulas in Excel 365, enabling automatic expansion, table integration, the spill reference hash, and at-sign controls to manage display.

Explore the unique function in Excel, removing duplicates from a range and returning only unique values with dynamic array spill, table data, and by column for exactly-once results.

Explore Excel's sort and sortby functions to dynamically sort data, including multi-column and region-based sorting, and learn to build dynamic drop-down lists with unique and sort.

Master the dynamic array filter function in Excel 2021 and Microsoft 365 to return all matching records, use and/or logic, handle no results, and select specific columns.

Learn to use Excel's text before and text after functions to extract data from complex strings, using delimiters, instance numbers, and match mode in real examples.

Learn the text split function in Excel 365, using braces-delimited delimiters and trim, extract numbers with text after, convert with value, and text join data for dynamic tables.

Explore the Xlookup function in Excel, replacing vlookup and index match with flexible searches and built-in error handling. Use approximate matches, wildcards, reverse search, and multi-value returns for real-world data.

Review five hands-on excel missions using text after and text before, unique, sort, filter by region and amount, and xlookup for the latest transactions, practicing with Global Tech Co data.

Master pivot table basics by ensuring headers, no empty columns or subtotals, place region as rows and channel as columns, convert to a table for auto expansion.

Master pivot table sorting and condition-based filtering to analyze regional and product performance, using label and value filters, and top ten product rankings across regions for focused insights.

Learn to adjust pivot table layouts and slicer designs for professional, brand-consistent excel reports by applying compact, outline, or tabular layouts, subtotals, and ci color styles.

Master pivot table advanced calculations, including calculated fields and calculated items, to analyze profit margins, regional proportions, and multi-perspective performance across shared pivot caches.

Create pivot charts linked to pivot tables to visualize sales by store and monthly trends, using pie and time-series charts with easy refresh and formatting options.

Build an interactive Excel dashboard by linking multiple pivot charts to a single slicer to filter regional and store sales in real time.

Master pivot tables and pivot charts by completing five missions, including grouping by quarter, filtering top products, adding calculated fields, and using slicers for interactive dashboards.

Master Excel's filter functionality with autofilter (Ctrl+Shift+L) and drop-downs to display only data that meets your conditions, including multi-criteria, date, and color filters.

Remove duplicates and create unique lists in Excel by using the remove duplicates tool, verifying with conditional formatting, and preparing data with trim and format unification across multiple columns.

Master find and replace in Excel using simple product catalog data, from basic searches to bulk replacements, with formatting, wildcards, and advanced options for data preprocessing.

Convert data ranges to Excel tables to enable automatic expansion, filtering, and sorting, then use the name-based structured references and table design features for dynamic, readable analysis.

Review section eight through five practical missions in this hands-on practice. Master custom sort for priority, range filters, wildcard highlights, duplicate removal, and table totals in Excel.

Learn how to set up Excel Copilot with a Microsoft 365 subscription, monitor AI credits, enable autosave, and access the Copilot panel and prompts for tasks.

Explore three core principles to master Excel Copilot: use specific prompts and convert data to named tables for fast, accurate results, assign tasks Copilot handles well, and verify outputs manually.

Explore generating formula columns with Copilot for a monthly sales table, using copy-paste and insert-column methods, and learn to add variance from target and related formulas.

Generate complex conditional formulas in Excel with Copilot by entering natural language criteria, creating columns for performance status, four-grade classifications, and region-based commissions.

Learn to clean and standardize real-world data with Copilot in Excel, transforming names, phone numbers, emails, and department and position codes, then convert formulas to values.

Learn to use Copilot to automate project schedules in Excel, calculating working days with networkdays and workday, auto-updating task status, progress, remaining days, and Friday reports.