Microsoft Office 365 Essentials Bundle: 5-Course Bundle

Learn how to launch the desktop version of Excel from the Microsoft 365 apps, pin it to the taskbar, access the start page, and manage recent, pinned, and shared documents.

Create a new blank workbook and explore the Excel interface, including ribbons, tabs, name box, and saving to OneDrive with auto save.

Explore how contextual menus, ribbons, and panes adapt to your selections in Excel, showing different options when you click cells, tables, pictures, charts, or pivot tables.

Customize the quick access toolbar in Excel by adding commands from the ribbon or Excel options, such as autosave, save, undo, and redo, and organize with separators.

Master Excel efficiency with essential keyboard shortcuts, such as Ctrl and Shift to select data, copy, paste, and format. Explore ribbon hints, Alt key tips, and printable shortcut lists.

Launch desktop version of Excel, create blank workbook, identify status bar, ribbons, title bar, grid, quick access toolbar, and customize with print preview, print, auto format, sort using Alt key.

Learn to speed up workbook creation with Excel templates, search for invoice templates, and reuse saved templates by saving them as Excel templates in the custom office templates folder.

Explore working with worksheets in a workbook by opening files, renaming sheets, coloring tabs, and moving, copying, or deleting sheets using drag-and-drop, keyboard shortcuts, and insert options.

Learn how saving Excel workbooks to OneDrive enables seamless cloud storage, easy sharing, and automatic autosave across devices, with guidance on personal vs business accounts and file syncing.

Master the rules and quirks of entering text, numbers, and dates in Excel cells, including currency and date formats. Learn editing tips using tab, enter, double-click, and the formula bar.

Master Excel custom lists to speed data entry with built-in day and month lists or your own lists, and manage them via autofill, fill series, and edit custom lists.

Create a workbook from monthly bank reconciliation template and save it to custom templates folder. Open exercise 03, bold the heading, and fill column B using column K's custom list.

Master how Excel formulas drive calculations by distinguishing functions from formulas, using cell references instead of hard coding, and applying the BODMAS order of operations with brackets.

Learn to build a simple Excel formula using the sum function, referencing cell ranges like C6 to C25, and explore using the formulas tab, insert function, and intellisense guidance.

Master the six most useful Excel formulas: sum, count, counta, average, min, and max. Learn to apply them to revenue and profit data with quick status bar tips.

Master absolute versus relative referencing in Excel, learn to use relative formulas, autofill, and lock a cell like I1 for accurate totals and tax calculations.

Master quick totals in Excel with autosum, using the sum function, the alt+equals shortcut, and multi-table selections to total rows and columns while understanding common warnings like the green triangle.

Master autofill and flash fill in Excel to speed data entry. Use fill down, fill weekdays, and fill series, then leverage pattern-based flash fill to combine or split data.

Practice applying essential Excel formulas, including sum, count, average, min, max, for part one, then use absolute referencing to compute next year's term fees with a 5.2% increase.

Discover how named ranges in Excel convert cell ranges into friendly names such as revenue and profit, and use them with formulas and the name box to navigate workbooks.

Create named ranges in Excel via the name box, define name, create from selection, or use the name manager for navigation and formulas.

Learn to use named ranges in formulas to simplify calculations for revenue and profit, and improve readability. Access ranges via the name box, F3, and typing the range name.

Create named ranges from the table headers and use them in formulas. Sum the amount to get the total and count the description to determine invoice count, with dollar formatting.

Learn how to apply and customize number formats in Excel, including currency, accounting, date and time, percentages, and special formats, while understanding that formatting masks the underlying numbers.

Learn how to format cells, rows, and columns in Excel, using autofit, bold, fills, borders, alignment options, and center across selection to create readable, polished tables.

Apply auto format in Excel by selecting a template from the gallery to quickly format a data set, including headers, borders, font color, and alignment.

Learn to use Excel's find and replace to identify cells by formatting and replace with new formatting, across sheets or the entire workbook, saving time.

Master format painter in Excel to quickly copy formatting across data sets, including header row styling, currency formatting, borders, and reusable painting across multiple cells.

Master clearing formatting in a data set using clear formats to remove styling while preserving text, and clear contents or clear all for a full reset, including hyperlinks.

Format the exercise six Excel table to match the screenshot by applying borders, background fills, heading and body fonts, and date/currency formats, removing gridlines, and replacing the gray fill.

Explore how Excel tables differ from plain data, learn to format as a table with the table design ribbon and filter dropdowns, and see auto-expand updating charts and pivot tables.

Learn how to format data as an Excel table, apply table styles, use headers, enable filters, add a total row, and name your table for easy analysis.

Learn how tables convert formulas to table references, and perform sum, average, and count a on the employee data table, focusing on the salary column.

Practice formatting data as an Excel table named invoices, set a style, remove banded rows, enable filters, add a total row, and calculate the average invoice amount with table references.

Discover how to format large spreadsheets by auto fit column widths and row heights, and insert, delete, move, copy, and hide rows and columns.

Master text and number alignment in worksheets using vertical and horizontal options, rotation, wrap text, indent, shrink to fit, and accounting versus currency formats to align numbers at the decimal.

Learn how to merge cells and center across a selection in Excel, compare merge and center with center across selection, and avoid common formula and selection issues.

Explore how Excel themes control colors, fonts, and effects to create readable, branded spreadsheets. Learn to apply, customize, and save custom themes, and manage theme color palettes for consistent visuals.

Insert two blank rows, add Hawaii and Idaho records, apply counting format to sales with two decimals, bold and background-fill the heading, center and italicize the row three title.

Learn to structure Excel lists with a heading row, well-organized columns, and clean formatting; remove blank rows, spell check, and format data for analysis using filters, tables, and pivot tables.

Master sorting in Excel by placing data in a table, then performing single-level and multi-level sorts by salary, department, or name, including custom sorts using custom lists.

Learn to perform multi-level sorts in Excel by adding sort levels, sorting department A to Z and salary largest to smallest via the sort dialog, plus left-to-right sorting for data.

Sort Excel data by a custom list, importing the names from column I to achieve the specific employee name order.

Apply and refine data views in Excel by filtering, sorting, and using table or range formats to show only records that meet criteria, including department, job rating, and salary.

Learn to filter and sort in Excel by cell background color and font color, using color-based filters, custom sorts, and multi-level ordering.

Learn to apply subtotals by region, sort data, and use the subtotal tool to total sales amounts, with outlines to collapse and expand groups.

Practice sorting by pizza ID (Z to A) and pizza size (A to Z), filter for California chicken pizza, then filter total price greater than $20, and clear filters.

Master basic data movement in Excel by cutting, copying, and pasting data using keyboard shortcuts, the home ribbon clipboard tools, right-click menus, and drag-and-drop, including paste options.

Master paste options in Excel, including formulas, values, and formatting, and use paste special to keep column widths or transpose data.

Copy and paste more efficiently with Excel's clipboard, which holds up to 24 items you can collect and then paste in the desired order and columns.

Learn to move and copy worksheets across a workbook or into a new book using the move or copy dialog, control-drag, and multi-sheet selection.

Master 3d referencing to consolidate monthly sales totals across multiple regional worksheets. Learn to efficiently total across UK to Australia using 3d ranges, alt+=, and autofill to verify results.

Learn to insert hyperlinks to worksheets within a workbook using place in this document and control K, and create a table of contents with quick links and back navigation.

Copy the 2018 worksheet to 2019–2022, update dates, convert data to named tables with a totals row, and use 3d referencing to sum across sheets and link to B4.