Excel 2021/365 Starter Pack: Beginner to Intermediate Course

Explore Excel's start screen, navigate home, new, and open, access templates and the full library, manage recent and pinned documents, and adjust settings and account options from Excel options.

Explore the Excel 2021 interface by creating a blank workbook from the start screen, and navigate the modern ribbons, title bar, quick access toolbar, name box, and formula bar.

Explore how tabs and ribbons organize Excel commands into groups, with menus, contextual options, and a mini toolbar for quick formatting, plus tips on ribbons, shortcuts, and display options.

Navigate the backstage area in Excel to manage files, open or save workbooks, print, share, and export, and explore info, document properties, and recovery features.

Learn to customize the quick access toolbar in excel by adding frequently used commands, moving it under the ribbons, showing labels, and organizing with separators for quick access.

Master the most useful Excel keyboard shortcuts to boost efficiency, including cut, copy, paste, undo, open, save, and insert shapes via alt.

Discover how to access Excel help using screen tips, the F1 key, the tell me more links, and contextual help, plus training, community resources, and the search bar.

Launch Excel and pin it to the taskbar. Customize the quick access toolbar with AutoSum, Wrap Text, and Fill, then add a separator and create a blank workbook.

Explore how to use Excel templates to jumpstart spreadsheets, including finding in-built templates, searching by category, and selecting invoices or budgets. Customize, reuse, and save templates for future projects.

Explore how a workbook houses multiple worksheets, with cells identified by column letters and row numbers, and manage tabs through renaming, inserting, moving, copying, and color coding.

learn how to enter and edit text, numbers, and formulas in Excel cells, use the formula bar and keyboard shortcuts, and auto fill months, days, and dates.

Create and save an invoice template from the library to the default templates folder; then build a multi-sheet workbook and enter 2020 sales data (revenue and profit).

Master the sum function in Excel to add ranges of numbers, use the insert function dialog and auto sum, and troubleshoot warnings about adjacent cells.

Learn to use Excel counting functions to count numbers, non-empty cells, and blanks in a range, with practical examples using student names and test scores.

Master min and max functions in Excel 2021/365 to identify the lowest and highest values in a range, and copy formulas down quickly using Ctrl+D.

Learn to identify and fix name, reference, and div errors in Excel using formula auditing tools like show formulas, trace precedents, and evaluate formula.

Master autosum and autofill to quickly complete totals, fill down formulas, and create number and date series with custom lists.

Learn how to use Flash Fill in Excel to split names into first and last names, extract initials or emails, or extract order numbers or product codes using pattern recognition.

Practice building Excel formulas to compute total sales and sales tax, using absolute and relative references, and apply functions for total, average, min, max, and count on customer data.

Learn how to create named ranges in Excel using four methods: name box, create from selection, name manager, and defined name, naming ranges after column headings and using underscores.

Navigate the name manager on the formulas tab to edit, delete, or create named ranges within a workbook. Learn about scope, references, and filtering to manage ranges efficiently.

Learn to use named ranges in Excel formulas for average, count, min, and max, with IntelliSense and name manager, and format results as British pounds.

Practice creating and using named ranges in Excel for a customer data worksheet, including tax rates, totals, and formulas, to replace cell references with names.

Apply date and time formatting in Excel to display short and long dates and times. Understand underlying serial numbers and adjust regional and locale settings for UK versus US formats.

Format worksheets to improve readability by auto fitting rows and columns, applying date and currency formats, and using borders, fonts, and colors to create clear, engaging tables.

Copy formatting quickly with format painter from the home tab clipboard group to apply fonts, borders, and colors to other cells; double-click to reuse formatting.

Apply short date to column a, accounting to column c, percentage to values, compute sales tax in d and total in e; format title, bold headings, dark green borders.

Learn how to delete values vs delete cells in Excel, choose shift cells up or delete entire row or column, and use clear options for contents, formats, comments, and hyperlinks.

Apply and customize Excel themes to quickly change colors, fonts, and effects in your worksheets, using live preview to compare themes and save custom themes for future workbooks.

Format the customer data tab in Excel with borders, alignment, and 25 column widths, then apply theme seven with Cambria font and violet colors.

Structure data in Excel lists for analysis by adopting flat and tabular layouts, with tabular format offering optimal support for pivot tables, sorts, filters, and grouping.

Master multi-level sorting in Excel by organizing data across region, country, and sales amount with the data tab's sort dialog and add level options.

Learn to sort with a custom list in Excel 2021/365, create and import lists, and use a unique function for country lists to enable multi-level sorts.

Apply autofilter to your dataset to filter by region, department, and sales figures, using drop-downs, color filters, and clear filters to reveal focused results.

Format your data as an Excel table to enable auto expansion and built-in filtering. Create tables via format as table or Ctrl+T, then name them meaningfully for charts and pivots.

Learn to add subtotals in Excel using the data ribbon or a subtotal formula, grouping by region to total sales and optionally count or average, with collapse and expand view.

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

Learn how to cut, copy, and paste data in Excel, understand the difference between cut and copy, and use the clipboard and shortcuts across apps.

Learn to link cells across worksheets and workbooks in Excel 2021/365 to create dynamic summaries on a summary sheet that update automatically when source data changes.

Learn to create and customize hyperlinks in Excel to navigate between worksheets and workbooks, including setting display text, screen tips, and using icons to return to a table of contents.

Practice paste options, linking data, and subtitles with totals, plus 3d referencing in Excel: preserve column widths, paste values only, transpose data, and link totals to a summary sheet.

Use vlookup with approximate match to find the app and daily hours from age ranges. Learn when to use true versus false, and lock references with named ranges.

Learn how to handle errors in Excel formulas using iferror and ifna, wrapping a vlookup over a named range parts catalog to return part not found or price not found.

Explore the basics of logical functions in Excel, using if, and, or to test conditions and return true or false, then assign meaningful outputs like approval or pass.

Apply if statements to determine shipping charges based on total cost and calculate grand totals in Excel. Explore nested ifs and the ifs formula, plus countif and sumif concepts.

Learn to tidy messy text in Excel using left, mid, right, proper, trim, clean, and concatenate to split data, standardize case, and merge fields.

Master essential time and date functions in Excel, including today and now, hard-coded dates, workday and networkdays with holidays, and extracting day, month, year, and weekend status.

Practice building lookup and logical formulas in excel: create a test scores table, use VLOOKUP for scores and grades, handle errors with IF, tidy data with trim and flash fill.