Mastering Microsoft Office 2021-365: Word, Excel, PowerPoint

Master Excel basics by learning how to start and create spreadsheets, use formulas, charts, and pivot tables, and automate tasks with VBA in Office 365.

Start Excel spreadsheet easily on Windows 11 by searching for the Excel app and opening a blank workbook; learn installation, licensing options, and cloud access via Office 365 while practicing.

Learn to enter text and numbers in an Excel spreadsheet, create and manage workbooks with multiple sheets, and navigate cells, rows, and columns using the formula bar for data entry.

Explore relative references in Excel, learn how to sum row totals using relative cell references and the sum function, with shortcut alt+equals for quick totals.

Learn to work with ranges in Excel by selecting starting and ending cells, using range notation (start:end), and applying the sum function across a range.

Learn to save and save as in Excel 2021 with autosave to OneDrive, choose a location and type (xlsx vs xls), and use Ctrl+S to save.

learn to manage file extensions, share and export Excel workbooks, convert to pdf, csv, or text, and publish to Power BI for rich dashboards and data visualization.

learn to add rows and columns in Excel by right-clicking insert, selecting the target area, and entering data or formulas to automate and save time.

Learn how to adjust row heights and column widths in Excel, using drag, auto fit, and precise height inputs, with undo and save shortcuts.

Master copying, cutting, and pasting in Excel using simple selection techniques and shortcuts like ctrl+c, ctrl+x, and ctrl+v to place data efficiently.

Learn how to copy formulas in Excel by selecting data, using copy and paste options, and preserving formulas when pasting to destination cells.

Explore Excel page setup options to configure margins, orientation, and page size; set print area, insert page breaks, add a background image, and manage print titles, previews, printers, and copies.

Learn to fit an Excel sheet to one page with the fit sheet in one page option, selecting to fit all columns or all rows, and use print preview.

Learn how to print an Excel workbook with multiple sheets by selecting active sheets, all sheets, or a specific selection, using print preview and save to pdf.

Sort and filter data in Excel to organize records, using ascending order (A to Z) via the sort and filter ribbon, expanding the selection so the relevant data sorts together.

Sort data in descending order in Excel by using home, sort and filter, selecting highest to lowest, expanding the selection to cover the data, and practicing for quick analytics.

Filter data in an Excel table by zones using the filter button or Ctrl+Shift+L. Select east or north to display only relevant rows and print the report.

Discover how to use basic Excel formulas and built-in functions, including autosum, logical, text, date time, financial, and lookup types, to perform calculations and analyze data quickly.

Learn to control date formats in Excel by using format cells (Ctrl+1), selecting date types, and applying custom orders such as year, month, and date, with time and locale options.

Explore essential Excel mathematical functions, including sum and average, and learn to create averageif calculations using real data, range selection, and formatting techniques.

Master how to apply Excel formulas such as counta, countif, mod, and round to count non-empty cells, classify data by gender or department, and handle dynamic updates.

Learn to use the vlookup formula to pull data from a second table by matching the leftmost column, and choose exact or approximate matches for accurate reports.

Master the hlookup formula for horizontal lookups to retrieve employee id and salary from a data table using lookup value, table array, and row index with exact or approximate match.

Master xlookup in Excel to retrieve country codes or data by entering a country name, using lookup and return arrays, and handling not found results.

Learn to handle #N/A errors and implement exact and approximate matches in XLOOKUP, using grading scenarios to retrieve correct results and avoid not applicable outcomes.