Microsoft Excel for Beginners: From Basics to Confidence

Explore what Excel 365 is as a subscription-based version of Excel with cloud services, autosaves, cloud backups, real-time collaboration, multi-device access, security controls, and automatic updates.

Explore the Excel 365 interface from the startup page to a blank workbook, using autosave with OneDrive, the ribbon, main dock, cell references, formula bar, sheets, and zoom controls.

Discover how the Excel 365 search bar helps you find actions, files, and help, including font color changes and inserting rows, plus access to tutorials and support.

Learn to navigate and select cells in Excel 365 using arrows, tab, enter, and shortcuts like Ctrl+Shift+arrows and Ctrl+A. Practice selecting data to build a ledger efficiently.

Explore and highlight cells while building Cup of Joe's yearly report, entering items and prices, creating headers, and using formatting, delete, replace, and undo to manage data.

Format prices as currency using the Home tab's number formats and adjust decimal places. Resize column widths by dragging or auto-fit by double-clicking the divider, applying changes across the sheet.

Learn how calculations, formulas, and functions differ in Excel, start with the equals sign, and use dynamic sum results, the function library, and autofill to copy patterns.

Learn how to use sum, average, min, and max functions in Excel to analyze data, merge and center headers across columns, and generate a concise quarterly report.

Learn how to use autofill in Excel to copy patterns, create sequential sequences, and fill dates, numbers, items, and months, including control key techniques.

Apply relative and absolute cell references in Excel to calculate taxes from total sales, using the equal sign, autofill, and the F4 shortcut to fix the tax rate in J1.

Learn to save and share Excel workbooks with auto save, OneDrive sign-in, and real-time collaboration via links, permissions, and cloud or local saves.

Explore real-time collaboration in Microsoft 365 with comments in Excel worksheets. Leave, mention colleagues, assign tasks, and resolve or reopen threads to track changes and pricing updates.

Learn how to add rows and columns in Excel, insert multiple at once, and create a notes section for the yearly report.

Master cut, copy, and paste in Excel using the home tab and shortcuts (Ctrl X, Ctrl C, Ctrl V), and learn drag-and-drop with the control key to copy data.

Learn to enhance Excel worksheets by applying cell styles, fonts, colors, and borders, using built-in styles for titles, headers, notes, and inputs/outputs to create automated spreadsheets.

Create a multi-year Excel workbook by renaming and copying sheets for 2023–2026, grouping sheets to apply changes across years, and updating taxes and totals.

Learn to hide rows and columns with a right-click, unhide when needed, and create custom views to tailor sheets for different viewers without deleting data.

Discover how to create and name an original custom view, hide unneeded columns and rows, and quickly switch to a CEO view for focused data in Excel.

Explore the worksheet review tools to polish your excel work: run spell check, use thesaurus and accessibility checks, and inspect workbook statistics, smart lookup, and translation features.