Excel 2019: Beginner to Expert - 75 lessons - Easy English

Learn how to use Excel's autofill tool to populate cells by recognizing patterns and series. Drag the autofill handle to extend days, quarters, months, and acronyms across rows or columns.

Master undo and redo in Excel 2019 using Ctrl Z and Ctrl Y, the Quick Access Toolbar, and the last actions list to revert data entry and zoom.

Discover how to create simple formulas with equals, reference cells, and edit formulas, then use functions like sum and average across ranges in Excel 2019.

Master copying formulas and functions into adjacent cells with autofill, using a relative reference to expand across rows and down columns.

Create a percentage change formula to measure how profits change day to day, using (current minus previous) divided by previous, with proper parentheses and percent formatting.

Master relative and absolute references in Excel 2019, learn to lock cells with dollar signs or F4, copy formulas down with autofill, and manage salaries and bonuses accurately.

Master autosum and auto average in Excel by selecting ranges, entering formulas, using the Home tab shortcut, and pressing Enter to compute totals or averages quickly.

Master font and alignment in Excel 2019, applying bold, italics, underline, color, fill, with format cells, format painter, and quick access toolbar; cover superscript, subscript, strikethrough, orientation, and wrap text.

Adjust column width and row height with a drag, using a two-way cursor; apply best fit by double-clicking to fit the widest item, or use select all to apply it.

Learn to use conditional formatting in Excel 2019 to highlight values, apply data bars, color scales, and icon sets, and manage or customize rules for clear visual data insight.

Create and customize an Excel table to treat data as a single entity, using headers, total row, filters, sorts, slicers, design options, and convert to range.

Insert and format shapes, pictures, and smart art in Excel 2019 to create visual effects, add arrows and banners, and layer elements with fill, outline, rotation, and text inside shapes.

Learn how to hide and unhide rows and columns in Excel 2019, using right-click, select ranges, and best fit to manage visible data and protect figures like commissions.

Move, copy, and insert data in Excel 2019 using drag, control X/V, and shift-insert; understand formula behavior on copy and how to insert or shift entire columns.

Learn to prepare and print Excel worksheets using page layout view, page break preview, and print preview, with orientation, margins, scaling, and headers and footers.

Create charts from data in Excel with Alt+F1 to generate a clustered column bar chart, then customize data labels and chart titles, and explore chart styles for quick insights.

Insert sparklines from the insert tab to create line or column sparklines inside a single cell, choosing data range, destination, and customizing markers and negatives.

Learn how to freeze panes in Excel to keep the top row or first column visible while scrolling, and unfreeze to revert.

Learn how to split screens in Excel to view different parts of a worksheet simultaneously, including four-way splits and independent scrolling across panes.

Master auto outlining in Excel to group data by formulas and view quarterly totals. Collapse or expand groups by level to present concise, drillable summaries.

Link worksheets and workbooks with formulas to create cross-worksheet totals using sum. Audit dependencies and manage absolute and relative references across multiple workbooks.

Demonstrates using the if function and nested ifs in Excel to calculate shipping costs based on thresholds (4500 and 3000), with true/false outcomes and autofill.