Microsoft Excel 365: Ultimate Beginner Guide

Learn to launch the desktop version of Excel on Windows 11, pin to the taskbar, and use the start page to create workbooks, templates, and access recent and pinned documents.

Explore the Excel interface and create a blank workbook while understanding workbook vs worksheet. Save to the cloud, and navigate ribbons, quick access toolbar, name box, and formula bar.

Explore contextual menus and ribbons in Excel that adapt to your click, from text to pictures and tables. See how panes, like the format picture pane, reveal relevant options.

Learn to customize the Quick Access toolbar in Excel 365 by adding, removing, and rearranging commands for faster access using the ribbon or Excel options.

Boost efficiency in Excel by using keyboard shortcuts, such as Ctrl A, Ctrl Shift Down Arrow, Ctrl C, Ctrl V, and Ctrl B, Ctrl I, Ctrl U.

Practice exercise two in Microsoft Excel 365, building a blank workbook and identifying interface elements such as the status bar, ribbons, title bar, grid, and quick access toolbar. Customize the quick access toolbar with commands like print preview, print, auto format, and sort, and learn the Alt keystroke to reveal key tips.

Learn to use Excel templates to save time, find and tailor invoice templates with pre-populated formulas like line totals, and save templates in the custom Office templates folder for reuse.

Learn to manage worksheets in a workbook, including opening files, renaming tabs, color coding, and moving, copying, or deleting sheets. Use drag-and-drop, Ctrl for copies, and Shift+F11 to insert sheets.

Learn how saving Excel workbooks to OneDrive keeps files in the cloud, auto-synced across devices, and accessible via File Explorer or the Microsoft 365 portal, with personal and business accounts.

Learn how to enter text, numbers, and dates in Excel 365, master number formatting and common data-entry quirks such as leading zeros and date interpretation.

Create and use custom lists in Excel to speed data entry with the autofill handle, fill series, and built-in lists for days and months.

Save the monthly bank reconciliation as a template in the custom templates folder, create a workbook, bold the heading, and fill names with a custom list from column k.

Explore how formulas drive calculations in Excel, distinguish functions from formulas, and apply the bodmas rule with brackets to control the order of operations.

Learn to create a simple Excel formula using the sum function to total revenue and profit, using cell references, ranges, and the formulas tab.

Learn the six most popular Excel formulas—sum, count, counta, average, min, and max—and apply them to revenue and profit data, including using the status bar for quick totals.

learn how relative and absolute references shape excel formulas, copy results with autofill, and lock a cell like I1 using the F4 key for accurate calculations.

Learn autosum in Excel to quickly total selections across multiple tables using alt+equals, and apply autosum to sum, average, count, max, and min, while understanding the green triangle warning.

Learn to speed data entry in Excel with autofill and fill down, including dates, weekdays, and sequential series, and master flash fill for combining, splitting, and pattern-based data.

Practice basic Excel formulas by answering score questions with sum, count, average, min, and max, then apply absolute referencing with F4 to calculate next year's term fee.

Master named ranges in Excel 365 by naming cell ranges like revenue and profit, accessing them via the name box, and using them in formulas to simplify spreadsheets.

Master how to create named ranges in Excel 365 using the name box, define name, create from selection, and the name manager, then use them for navigation and future formulas.

Use named ranges in formulas to sum revenue, count profit, and improve readability, then toggle through names with f3 for quick, clear references.

Practice creating named ranges from each table column using create from selection, then use those named ranges in formulas to total the amount and count invoices.

Apply number formats in Excel 365 using the format cells dialog to display currency, date, time, percentages, and accounting, while formats remain masks that don’t change the underlying values.

Learn manual and automatic formatting in Excel 365, including autofit column width, bold headings, fills, borders, alignment, merge and center versus center across selection, and wrap text.

Master auto format in excel 365 by adding the quick access toolbar button, choosing a template from the gallery, and customizing which formatting elements to apply.

Use Excel's find and replace to locate formatting and swap it across a sheet or workbook. Apply format from cell or eyedropper, then replace all with ctrl+f or ctrl+h.

Apply format painter to quickly copy formatting across data sets, including headers, currency, borders, and totals, and learn how to activate, extend, and deactivate it.

Learn to clear formatting and contents in Excel 365 by using clear formats, clear contents, and clear all, and remove or clear hyperlinks, with step-by-step options from the home tab.

Format the exercise six data table in Excel 365 with borders and heading font. Apply background fills, remove grid lines, and use format painter and find and replace.

Explore Excel tables, their auto expand, and how charts, pivot tables, and filter dropdowns stay current when you add data.

Learn how to turn data into an excel table using format as table or Ctrl+T, apply table styles and headers, use filters, and name the table for easy reference.

Discover how table references in formulas work in Excel, as you convert data into a named employee data table and perform sum, average, and count calculations using column references.

Convert data into an Excel table named invoices, turn off banded rows, enable filters and a total row, and compute the average invoice amount using table references.

Learn to format large spreadsheets by auto fitting columns and rows, navigate huge data sets, and insert, delete, move, and hide rows and columns with practical shortcuts.

Explore how to align text and numbers in large worksheets using vertical and horizontal alignment, text rotation, wrapping, and indent, plus accounting and currency formats that affect alignment.

Learn to format headers in Excel by using merge and center or center across selection, comparing usability, formula impact, and safe alternatives.

Learn how to apply and modify Excel themes to control colors, fonts, and effects for consistent, readable spreadsheets; create custom themes, save, and apply them to charts and shapes.

Practice exercise eight by inserting two rows, formatting the sales column with two decimals, bolding and filling the heading row, and centering the title across selection with bold italic header.

Learn how to structure Excel lists, including a heading row, format data, remove blank rows, spell check, and prepare data for filters, sorts, tables, and pivot tables.

Sort Excel lists with single-level sorting, then expand to multi-level sorts. Use a table with headers and filters to sort by salary, department, or name.

Master multi-level sorts in Excel 365 by using the sort dialog to sort by department, then salary, with add level and row or column options.

Learn how to use custom lists to perform targeted sorts in Excel 365, including creating, importing, and applying custom lists to sort data by a specific order.

Master filtering in Excel by using drop-down filters on tables or ranges, applying text and number filters, and using top ten and clear filters to refine results.

Learn to filter and sort by color in Excel 365, using cell background fill and font color to organize data, apply custom sorts, and clear filters.

Apply subtotals to group data by region and view regional totals in the sales amount column. Sort by region and use outlines to collapse or expand regions.

Master sorting a pizza sales table by pizza id and size, filter for California chicken pizza, then display orders greater than $20, and clear filters after each step.

Master cut, copy, and paste in Excel using keyboard shortcuts, the home ribbon clipboard options, and drag-and-drop. Compare moving versus copying data and use right-click or paste options.

Explore paste options in Excel: paste formulas, keep source formatting, paste values, transpose data, keep column widths, and use paste special for granular control over formatting and formulas.

Explore how the Excel clipboard lets you copy multiple items, paste in a chosen order, and manage up to 24 items with a floating pane, boosting speed and accuracy.

Move and copy worksheets using the move or copy dialog, or by dragging and dropping. Copy to a new workbook or within the same workbook using control-drag for quick copies.

Master 3d referencing to consolidate totals across multiple worksheets in excel 365, using alt equals to sum January totals across regions.

Learn how to create hyperlinks to worksheets within a workbook to boost navigation, including place in this document links, text customization, and back to the table of contents.

Copy the 2018 worksheet to 2019–2022, convert each to table with a totals row, update dates with find and replace, use 3d referencing to sum, and add hyperlinks to B4.