Excel 2021/365 Starter Pack: Beginner to Intermediate Course

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.

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.

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 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.

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.

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

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 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.

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 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.

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.

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.

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 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.

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.

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.