Launch the desktop version of Excel by installing Microsoft 365 apps, then pin Excel to the taskbar, access the start page, and manage recent and pinned documents for quick work.

Explore the Excel interface by creating a new blank workbook from the start page, understand workbook versus worksheet, autosave to the cloud, and use ribbons, name box, and formula bar.

discover how contextual menus and ribbons adapt to your selection in excel, from text and pictures to tables and charts, with panes such as format picture or format cells.

Customize the quick access toolbar in Excel by adding commands from the ribbon or options, organizing with separators, and choosing its position above or below the ribbon.

Boost Excel productivity by mastering essential keyboard shortcuts: select data with control arrows, format with bold, italic, and underline, and discover quick access via alt tips, help, and printouts.

Create a blank workbook, identify the status bar, ribbons, title bar, grid, and Quick Access toolbar, then customize the toolbar and learn the Alt key for key tips.

Learn to save time with Excel templates, including online invoice templates with pre-populated formulas, and save them as Excel template files in the custom office templates and personal folders.

Learn how to manage worksheets within a workbook by opening files, renaming tabs, color-coding groups, and copying, moving, or deleting sheets using drag-and-drop, right-click menus, and helpful shortcuts.

Save Excel workbooks to OneDrive to share files in a cloud folder, enjoy automatic autosave, and access them via File Explorer and the Microsoft 365 portal.

Learn to enter text, numbers, and dates in Excel cells using tab and enter. Understand currency and date formats and how to fix misformatted dates.

Create a workbook from monthly bank reconciliation template and save it to default custom templates folder. Bold heading and fill names from a custom list in column K, exercise 03.

Learn to build a simple Excel formula using the sum function to total revenue and profit, and explore the formulas tab, insert function, and formula arguments with IntelliSense.

Master the six core Excel functions—sum, count, count A, average, min, and max—using a revenue and profit dataset to compute totals and extremes.

Understand absolute vs relative referencing in Excel, and learn to use formulas with auto-fill, locking references with dollar signs for tasks like tax calculations.

speed up sums in excel with autosum and the alt plus equals shortcut, enabling quick totals across multiple tables while noting year-related pitfalls and how to ignore errors.

Learn to speed up data entry with auto fill and flash fill in Excel, using built-in lists, fill series, and pattern recognition to combine or split data efficiently.

Create named ranges in a worksheet using the name box, define name, create from selection (with header), and the name manager, to enable fast navigation and prepare for formulas.

Use named ranges in formulas instead of cell references. Insert them from the name box and recall with F3; combine ranges for readable formulas and verify totals in status bar.

Create named ranges for each table column and use them in formulas to answer the questions by calculating total invoice amount and the number of invoices.

Apply number formats to display currency, dates, times, percentages, and more, while preserving the underlying values, using the format cells dialog and the home ribbon options.

Learn to quickly format worksheets by autofitting column widths, applying bold and background fills, adding borders, and using center across selection with wrap text for readability.

Apply auto format to your data by choosing a template from the Excel gallery. Use options to pick which elements to apply, such as number formatting, borders, font, and alignment.

Learn to quickly copy cell formatting in Excel with the Format Painter, applying header styling, currency formats, borders, and more—use double-click for continuous painting and press Esc to exit.

Learn to clear formatting in Excel datasets using clear formats, clear contents, and clear all from the Home tab; distinguish formatting removal from text retention and hyperlinks.

Format the exercise six data table to match the screenshot with borders, fills, and fonts; adjust dates and amounts; remove grid lines; find and replace gray fill.

Discover how Excel tables differ from plain data, how auto expanding tables keep charts and pivot tables up to date, and use the table design ribbon and filter dropdowns.

Master formatting data as an Excel table, apply table styles, headers, and filters, and use a total row and control T for quick table creation, with meaningful naming.

Explore how data in a table changes formulas by using table references, and see sums, averages, and counts on the employee data table.

Open the exercise seven file, convert data to a table named invoices, apply a style with filters and a total row, and calculate the average invoice amount with table references.

Learn to manage rows and columns in large spreadsheets with autofit, insert/delete, move or copy using shift or control, and hide or unhide columns and rows for cleaner views.

Complete exercise eight by inserting two blank rows for Hawaii and Idaho, format sales column to two decimals, and center row three title across columns with bold and italic styling.

Sort a list by one column in an Excel table, applying a single level sort from largest to smallest, and explore other sort options such as by department or salary.

Learn to perform multi-level sorting in Excel by using the sort dialog to add levels, sorting by department, salary, and job rating.

Learn to sort data in Excel using custom lists, including creating and importing lists from cells and applying them to multi-level sorts for a specific order.

Discover how to filter data in Excel with dropdowns, text and number filters, including top ten filters, while learning to apply or remove filters without relying on a table.

Explore how to filter and sort by cell background fill and font color in Excel, using color-based filters, custom sorts, and clear filters to organize data.

Apply subtotals to group data by region and display regional totals for sales amounts. Sort by region and use the subtotal tool to choose sum, count, or average.

Sort data by pizza id and pizza size, then filter to California Chicken pizza and total price greater than $20, clearing filters afterward.

Master cut, copy, and paste in Excel, exploring methods from the home ribbon, keyboard shortcuts, drag-and-drop, and paste options to move or duplicate data.

Explore the Excel paste options in the home ribbon, from plain pastes to paste formulas, keep source formatting and column widths, paste values, and transpose via paste special.

Learn to move and copy worksheets across and within workbooks using move or copy, create copies, and quick Ctrl-drag, with country examples like UK, USA, Germany, and China.

Discover how to insert hyperlinks to worksheets within a workbook, create a table of contents, and add a back button for quick navigation.

Copy 2018 worksheet to 2019–2022, update dates in column e, convert to a table named sales_2018–sales_2022, enable totals for total price, and use 3D referencing with hyperlinks to b4.