Microsoft Excel Masterclass For Office Productivity

Explore two Excel versions: a standalone desktop edition and a Microsoft 365 online suite. Microsoft 365 supports collaboration across devices, up to five devices, with cloud storage and automatic updates.

Explore the start screen to create blank workbooks or templates, manage recent and pinned files, adjust options and themes, and access the backstage view for file management.

Explore the Microsoft Excel environment, including the quick access toolbar, title bar, search, and ribbon tabs. Learn to navigate workbooks, cells, formulas, sheets, and view options like the status bar.

Explore Excel's backstage view from the file tab to access info, save, print, share, export, and close, while protecting workbooks and checking accessibility and compatibility.

Navigate ribbons, tabs, and menus in Excel to access commands, view hover descriptions, and use contextual menus, the quick access toolbar, and ribbon minimization for space.

master the quick access toolbar in Excel by moving its position, adding frequent commands like save, undo, and redo, and organizing tools with separators for faster access.

Learn essential Microsoft Excel keyboard shortcuts to create, save, format, undo, cut, copy, paste, navigate, open, print, autosum, and access commands using Alt and F1.

learn to get help in Microsoft Excel through screen tips and tell me more, F1 help, search, and contextual help, plus video training and support.

Navigate the backstage view to access Microsoft Excel templates, preview and customize invoices, and save templates for reuse in personal and office template folders.

Enter and edit data in Microsoft Excel using typing, navigation keys, ctrl-enter to stay in a cell, then format with merge and center, autofill dates, copy, cut, and paste.

Learn to select cells, rows, and columns in Excel using keyboard shortcuts and mouse. Navigate with control keys, select entire columns or rows, and make non-contiguous selections with Ctrl-click.

Master workbook and worksheet management in excel by creating, renaming, inserting, deleting, moving, and coloring sheets, and navigating up to 60,000 columns and 1,000,000 rows with cell references.

Learn to save and save as in Excel, use Ctrl+S for quick saving, rename files, and manage locations; explore AutoRecover and recovering unsaved work from backstage view.

Explore formulas and functions in Excel, differentiate predefined functions from user defined formulas, and learn how order of operations and brackets ensure accuracy.

Learn how to use the sum function in Excel, insert and select the range, and apply AutoSum to calculate totals.

Learn to find the max and min values in Excel using the max and min functions, select the correct range, and press enter to see results.

Learn to calculate the average in Excel with the average function, accessible via home, insert function, or formulas. Select the range, press enter, and drag down to extend averages.

Explore how to use the three-dimensional function in Microsoft Excel to summarize data across multiple sheets with a summary sheet.

Master autofill and autosum in Excel to instantly calculate totals, generate series, and fill dates, days, months, or custom lists using drag, double-click, or right-click series.

Master flash fill in Microsoft Excel to separate first names and last names, and extract product numbers, colors, and item codes with data tools and ctrl e.

Learn how to use sumif and countif in excel to total amounts for a product and count occurrences, using range, criteria, and sum_range across datasets.

Explore how relative referencing updates cell ranges when formulas are copied, and how absolute referencing uses fixed cells with dollar signs to keep constants like commission and bonus rates constant.

Apply data validation to create a drop-down list of names by selecting data validation, choosing list, and setting the source range; use vlookup to extract information from large datasets.

Learn how relative and absolute referencing in Excel work, how formulas adjust when copied, and how to fix references with dollar signs for commissions and bonuses.

Learn how to use Vlookup to retrieve emails, phone numbers, and salaries from large data sets, using exact-match lookup with a table array and correct column index.

Explore named ranges by assigning meaningful names to cell ranges, enabling easier referencing in formulas and functions and improving readability and navigation in large workbooks.

Manage named ranges using the name manager to create, edit, delete, and locate names across your workbook. Learn about scope options (workbook or worksheet) and how deletions affect formulas.

Discover how to create named ranges in Excel using the name box, define names from selection, and manage scopes with name manager, including naming conventions and formula usage.

Learn to apply date and time formats in Excel, converting numbers to short or long dates and adding am/pm. Master number format, custom options, and location settings for readability.

Format cells, rows, and columns to improve readability, adjusting font, alignment, date and currency formats, row height, column width, borders, and merged cells.

Learn to use basic logical functions in Excel to make decisions with your data, including if statements and and or logic, with practical examples like approvals and shipping fees.

Learn to use cell styles in Excel to improve worksheet readability, distinguish input and formula cells, apply colors and headings, and create custom styles for clear collaboration.

Learn to add navigation buttons in Excel to move between worksheets, using shapes or icons linked to specific sheets and replicated for quick home navigation.

Control data input in Excel by using data validation dropdowns to select names and auto-populate details, and protect the sheet to lock formulas during collaboration.