Ultimate Excel 2021/365 Bundle: Beginner to Advanced Course

Launch Excel 2021/365 by using the start menu, search bar, or all apps, then pin to the taskbar or start menu for quick access on Windows 11 or Windows ten.

Explore the Excel start screen, using home, new, and open to access templates, recent files, and pinned items. Learn to customize options, account settings, and templates for efficient work.

Explore the modern Excel 2021 interface, create a blank workbook, and navigate ribbons, the title bar, name box, and worksheets to master essential commands.

Explore how tabs, ribbons, and menus organize Excel commands into groups for quick access. Discover tooltips, contextual menus, the mini toolbar, and ribbon customization options like collapse and full-screen view.

The backstage area, accessed via the file tab, is the admin hub to create new blank workbooks or select templates, and to open, save, print, share, export, and publish workbooks.

Learn how to customize the quick access toolbar in Excel, add commonly used commands, show labels, reuse separators for grouping, and manage its position and visibility.

Master essential Excel keyboard shortcuts to boost efficiency, from bold and undo to cut, copy, paste, and navigation. Explore alt navigation, open help with F1, and insert shapes.

Discover how to access Excel help through screen tips, the tell me more links, and contextual help, and use Alt Q to search for commands like format as a table.

Learn to launch Excel, pin it to the taskbar, customize the quick access toolbar with auto sum, wrap text, and fill, and create a blank workbook with keyboard shortcuts.

Explore how to use Excel templates to quickly create budgets and invoices, access built-in and personal templates, customize formatting and formulas, and save reusable templates for future projects.

Discover how a workbook contains multiple worksheets with a cell grid and diverse data types, and learn to rename, insert, move, copy, color-code sheets, and use shift f 11.

Learn how to save workbooks in Excel 2021, including the difference from Microsoft 365 auto save, using the Quick Access toolbar save button, and auto recover options for unsaved work.

Enter and edit data in Excel cells, including text, numbers, decimals, percentages, and formulas, using the formula bar, enter, ctrl enter, and autofill for efficient data work.

Master efficient cell, row, and column selections in Excel with shortcuts like ctrl+down and ctrl+shift+down; learn contiguous and non-contiguous ranges and apply currency formatting and borders.

Create an invoice template from the template library, then build a workbook with summary, sales data calculations, and charts; enter 2020 sales data and save as exercise_02_practice.

Explore formulas and functions in Excel, from simple sums to using the sum function with cell ranges. Understand building formulas with cell references, operators, parentheses, and the order of operations.

Explain how Excel's sum function adds a range of numbers, using =sum, the insert function dialog, or auto sum; adjust the range with marching ants and heed green triangles.

Master counting in excel with the count, count a, and count blank functions to count numbers, not empty items, and blanks within a range, using scores and names as examples.

Use the average function in Excel to find the mean of a selected range, via direct entry or IntelliSense. Copy this formula down with relative referencing using the autofill handle.

discover how to apply the min and max functions in Excel to identify the lowest and highest values in a cell range, and quickly copy formulas down with Ctrl+D.

Identify and fix common formula errors in Excel by using auditing tools, evaluating formulas, tracing precedents and dependents, and correcting referenced cells to keep spreadsheets error-free.

Master absolute and relative referencing in Excel by comparing dragging formulas with relative references to locking a constant using absolute references, illustrated with a salary bonus example.

Master autosum and autofill in Excel using the auto sum button, fill handle, and keyboard shortcuts to calculate totals, averages, min, and max, and explore custom lists and date fills.

Explore how Flash Fill automates data tasks in Excel by recognizing patterns to split names, extract initials for emails, and pull parts from codes using Ctrl+E.

Practice calculating totals and taxes across customer data in Excel, using formulas, absolute/relative references, autofill, and functions to compute averages, min/max, counts, and update the tax rate to 6%.

Explore named ranges in Excel, learn how naming a cell group improves formula clarity and navigation, and see how to use the name box to jump between worksheets.

Create named ranges in Excel using the name box, create from selection, name manager, and define name, with one-word names or underscores, and understand absolute references.

Open the formulas tab, use Name Manager to edit, create, or delete named ranges, review their workbook scope, and use filters to manage and troubleshoot ranges efficiently.

Learn how to use named ranges in Excel formulas for average, count, min, max, and sum, using IntelliSense and F3 to locate names, and how deleting ranges affects formulas.

Create named ranges for each column and tax rate in the customer data worksheet, then replace cell references with these names in formulas and recalculate totals.

Learn to apply number formats to improve readability of worksheets, selecting general, currency, accounting, and percentage formats, adjusting decimals, and understanding the formula bar shows the underlying value.

Apply date and time formats in Excel, using short date, long date, and time options. Dates are stored as numbers since 1 January 1900, and the underlying value remains unchanged.

Format worksheets in Excel to auto-fit rows and columns, apply date and currency formats, and style headings with color, font, and borders for a clearer, more engaging data view.

Copy formatting with format painter to apply existing styles to other cells, using a single click or double-click for multiple uses, via the home tab clipboard group.

Apply short date format, counting format, and percentage format, compute sales tax and total with formulas, and style the invoices with bold headings, light green fills, and dark green borders.

Master formatting rows and columns in Excel by resizing, inserting, deleting, and hiding data, using keyboard shortcuts and go to special to remove blanks.

Delete values or entire cells in Excel, choosing to shift cells, delete rows or columns, and use clear options for formats, contents, comments, and hyperlinks.

Master Excel cell alignment by controlling horizontal and vertical positions for numbers, text, and dates using the home ribbon, with wrap text, merge and center, and rotation options.

Apply themes to instantly change colors, fonts, and effects in your worksheets. Preview themes live, customize color palettes and fonts, and save your own custom theme for quick reuse.

Format customer data tab to match data tab by applying date and currency formats, borders, middle alignment, and 25 column width; then apply theme seven with Cambria and violet two.

Organize data in Excel lists to enable easy analysis with pivot tables, filters, sorts, and groups, emphasizing the tabular format as optimal for analysis.

Sort data with single level sorting, using one column in a table, by text (A to Z or Z to A) or numbers (smallest to largest or largest to smallest).

Discover how to perform a multi-level sort in Excel by sorting region, country, and sales amount in order, using the data tab and sort dialog.

Master custom sorts in Excel with custom lists. Import, apply, and create these lists via the data tab, and extract unique countries with the unique function.

Apply autofilter in Excel to filter a data list by single or multiple columns using text, number, and color filters, and learn how to clear or reset filters for analysis.

Learn to format data as an Excel table, apply styles and headers, and use the Ctrl+T shortcut to create auto-expanding tables that update charts and pivot tables.

Discover how to add subtotals to a dataset using data ribbon and the subtotal button, with sum, count, and average by region, and learn the formula approach as an alternative.

Format the customer invoices as a table named invoices_2020, sort by month (custom list), then by invoice total and status, filter over 3000 with past due, and apply monthly subtotals.

Master cut, copy, and paste in Excel by moving data with cut (Ctrl+X) and pasting (Ctrl+V), or copying (Ctrl+C) while preserving originals, and explore basic clipboard behavior and cross-application use.

Explore Excel paste options, including paste formulas, paste formatting, paste values, and transpose via paste special. Learn how to preserve or remove formatting, borders, and column widths when pasting.

Explore Excel's clipboard, a hidden pane on the home tab that stores up to 24 copied items from any app. Paste, paste all, or clear items to cells.

Link cells across worksheets and workbooks to keep a summary sheet dynamically updated with city revenue. Learn to use equals formulas to pull data from the same and external workbooks.

Master 3D referencing across multiple worksheets with identical data structures to sum or average monthly sales across UK, USA, Japan, and China, using the same cell reference on each sheet.

Learn to create hyperlinks that navigate between worksheets and workbooks, forming a table of contents with screen tips for quick access to UK, USA, Japan, China, and totals.

Practice Excel paste options, link data, and 3D referencing across worksheets to build summaries from fruit sales, client revenue, and totals.

Learn to use VLOOKUP to look up a movie title in the leftmost column and return year, certificate, genre, and rating from a named table with an exact match.

Learn how to use vlookup with approximate match (true) to find results when the lookup value isn’t exact, using age ranges to map to apps and daily hours.

Explore error handling in excel with iferror and ifna, wrapping a vlookup against a parts catalog to return descriptions or prices and display custom messages like part not found.

Explore fundamental logical functions in Excel, including if, and, or, and learn to apply logical tests, boolean results, and meaningful outputs like approvals and pass/fail.

Explore how to use if statements to calculate shipping and grand totals in a furniture sales table, employing a logical test and locked references to automate results.

Use text functions to tidy messy text in Excel by extracting left, mid, and right characters, changing case, trimming and cleaning spaces, and concatenating values.

Explore essential time and date functions in Excel, including today and now, hardcoded dates, workday and network days, and methods to extract day, month, year, and weekday.

Develop VLOOKUP skills across test scores and grades using data validation and error handling. Apply logical checks for venues and tidy data with trim, proper, and Flash Fill.