Mastering Excel 2021 - Beginner

Create a new blank workbook, enter data with enter or tab, and save the file as Budget in a chosen location using keyboard shortcuts like Ctrl+N, Ctrl+S, and Ctrl+Enter.

Learn how to enter and format data in Excel, including yearly income, monthly items like rent and utilities, and dates; master shortcuts, copy-paste, undo/redo, and clear operations.

Explore auto fill in Excel to quickly populate months, days, weeks, and dates using the fill handle, fill series, and weekday options.

Explore Excel's built-in help options, using the search box to locate commands like insert icon and spell check, and access contextual help with F1 for targeted guidance.

Learn to create and edit formulas in Excel 2021 using cell references and the formula bar, calculating monthly and yearly income, net amounts, and applying the order of operations.

discover how functions simplify calculations in excel by using sum, average, max, and min, and learn to insert and adjust ranges with autoSum and keyboard shortcuts.

Copy formulas across rows and columns using AutoFill, double-click to fill down, observe relative references adjust, then use transpose paste and AutoSum shortcuts to verify totals.

Apply text formats in Excel to make headings and totals pop, using bold, italics, color, font size, and the Format Cells dialog to access double-underline and subscript.

Learn to apply and customize cell styles in Excel 2021, using heading, total, and accent styles, duplicating and modifying styles, and applying formatting consistently with shortcuts like Ctrl+Z and Ctrl+Y.

Apply conditional formatting to highlight high and low values and make data stand out. Use greater than, less than, and top/bottom rules to analyze data dynamically with above/below average highlights.

Master printing workbooks in Excel by using print preview, adjusting margins and orientation, setting print areas, and selecting what to print (active sheets, entire workbook, or a selection).

Master chart creation in Excel 2021 by visualizing monthly food and beverage sales; learn chart sheets vs embedded charts, data selection, and dynamic updates with quick analysis and pie charts.

Highlight a high value in cell C6 by drawing an oval with no fill, then use arrows and icons from insert illustrations to label food and beverages.

Sort data in Excel by last name, department, date of hire, or salary, ensuring the entire data set moves together and headings are recognized by formatting.

Apply auto filters to limit the data you see, using drop-down menus for department, date of hire, and salary, and explore date filters, number filters, and multi-column filtering.