Microsoft Excel 2021/365 for Beginners

Master the Excel start screen to access templates, recent and pinned files, and the home, new, and open tools. Adjust settings in options for auto save and ribbons.

Explore Excel 2021/365 interface, create a blank workbook, and navigate the title bar, quick access toolbar, ribbons, and tabs. Understand the name box, formula bar, cells, worksheets, and workbook structure.

Navigate tabs and ribbons to see how commands are organized by groups, and use contextual menus, keyboard shortcuts, and the mini toolbar for faster formatting.

Explore the backstage area by clicking file to access options like new workbooks, templates, and publish to Power BI service. Use the info page to protect and recover unsaved workbooks.

Discover how to customize the Quick Access Toolbar in Excel 2021/365, including turning it on, relocating it under the ribbons, and adding frequent commands like undo, redo, save, and spelling.

Learn how to save and name workbooks in Excel 2021, use save versus save as, press Ctrl+S, and enable auto recover while understanding autosave differences with Microsoft 365.

Learn to navigate large worksheets and select cells, rows, and columns using mouse and keyboard shortcuts such as ctrl+down arrow, ctrl+right arrow, and ctrl+shift+down, and ctrl+s to save.

practice creating and saving an invoice template in the default templates folder. create a workbook with sheets named summary, sales data, calculations, and charts, and enter 2020 sales data.

Explore formulas and functions in Excel, learn to build calculations with cell references, master the sum function for ranges, and understand IntelliSense and the order of operations.

Learn to find the average with the AVERAGE function in Excel by selecting a cell range or using the dialog. Copy the formula down with autofill and observe relative referencing.

Discover how to use the min and max functions to find the lowest and highest values in a cell range such as c3 to f3. Copy formulas down with Ctrl+D.

Identify common Excel formula errors and use formula auditing tools to trace precedents, show formulas, and evaluate parts to fix name, reference, and div errors.

Master absolute and relative referencing in Excel; relative is the default, while absolute references use dollar signs to lock cells. Copy formulas down accurately.

Practice calculating total sales with tax in Microsoft Excel 2021/365 for beginners, exercise 03, using absolute and relative references, autofill, and functions like min, max, average, and count of customers.

Explore named ranges in Excel and learn how assigning meaningful names to cell groups simplifies formulas and navigation, with examples like price per unit, quantity, and total.

Learn to apply date and time formatting in Excel, switch to short date format or long date format, and adjust regional locale settings to display dates correctly, with customization options.

Learn to format worksheets in Excel by adjusting row height and column width, applying date and currency formats, and using font styles and borders to improve readability.

Explore how to apply and customize Excel themes, including colors, fonts, and effects; preview themes in real time, adjust palettes, and save custom themes for any workbook.

Format customer data tab to match reference by setting column widths to 25, applying date and currency formats, centering borders, and applying theme seven, Cambria font, and violet two colors.

Learn single level sorting in Excel by sorting one column, such as region or country, using A to Z or smallest to largest, including cell color rules.

Learn how to perform custom sorts in Excel using a custom list to order regions such as North America, Asia, and Europe, and generate country lists with the unique function.

Learn to apply autofilter in Excel to filter a dataset by one or more columns using text, number, and color filters, and to clear filters when needed.

Learn to add subtotals to a dataset using Excel’s data ribbon subtotal option, group by region, and place totals; compare with a formula approach using the subtotal function.

Learn to cut, copy, and paste in Excel using keyboard shortcuts, grasp that cut moves data while copy duplicates it, and explore paste options.

Explore paste options in excel by using paste formulas, paste formatting, paste values, paste column widths, and transpose via paste special to control data formatting and layout.

Master 3d referencing across multiple worksheets with identical structures to sum or average monthly totals, using uk to china ranges and autofill while preserving formatting.

Practice paste options preserving column widths, values-only paste, and transpose; create subtotals for client profits and link them to a summary sheet; apply 3-d referencing to total sales across sheets.

Master VLOOKUP approximate match in Excel by using the true argument when the lookup value isn't exact. Explore age ranges, app preferences, hours per day, named ranges, and absolute references.

Learn to tidy messy data in Excel using text formulas such as left, mid, and right, plus trim, clean, and combine values for clean, consistent results.

Explore time and date functions in Excel, including today and now, hard-coded dates, work day and network days for deadlines, and extraction with day, month, year, weekday, and weekend checks.

Apply vlookup and logical formulas to retrieve student scores and grades, select venues, and cleanse text using trim, proper, flash fill, and right functions.