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

Learn practical data entry and editing techniques in Excel, including moving with enter and tab, editing in-cell and via the formula bar, deleting mistakes, and spotting alignment cues.

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.

Learn to enter dates and times in Excel using slashes or dashes, with automatic formatting and space plus p or a for am, and use autofill for date sequences.

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.

Learn how to add, edit, delete, and manage comments in Excel 2019, including inserting, showing, hiding all comments, and navigating between comments via the review tab.

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.

Calculate year-to-date totals in Excel 2019 by creating a formula that adds today’s profit to the previous total, then use autofill to copy it across the year-to-date sheet.

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.

Learn to use Excel functions like autosum, autoaverage, count, counta, median, large, small, standard deviation, and rank to analyze salaries with relative references and autofill.

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.

Master aligning and merging across cells in Excel 2019 to create centered titles, control text flow, and format with font size, font type, and background color.

Explore how to create and manage borders in Excel 2019, distinguish borders from grid lines, and use border tools, more borders, and print options.

Format data in Excel using the number tab and special formats to display social security numbers, phone numbers, currency, and dates with custom formatting, without changing the raw data.

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 insert and delete rows and columns in Excel, using right-click actions, select headers, and the insert dialog to shift cells down or to the right.

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 use find and replace in Excel 2019 to locate and replace data, use find all, and apply format-based searches, including case and color formats.

Use page layout view to preview printouts, adjust margins, orientation, and page size, then set print areas and titles and customize headers and footers with page numbers.

Explore Excel's page break preview to visually manage how worksheets print, drag blue dotted lines to adjust page breaks, preview in print view, and reset breaks to default.

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.

learn how to create charts from a data set using alt+f1, adjust data selections to exclude totals, and explore chart types like clustered column charts, stacked charts, and line charts.

Learn to format charts and chart elements in Excel 2019 by creating charts from data, adjusting totals with filters, editing titles, and styling gridlines, fonts, and layouts.

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.

Open multiple workbooks at once and arrange them with the View tab's arrange all options. Create new windows to view multiple worksheets in a single workbook.

Manage multiple worksheets in a workbook by adding, renaming, coloring, copying, moving, and deleting sheets; group and edit across all worksheets.

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.

Use look up approximate to calculate discounts from a price table in Excel 2019. Configure the table array, column index, and true/approximate match, and understand absolute versus relative references.

Master exact lookups in Excel 2019 with VLOOKUP, using 1-for-1 matching and false for exact results, and learn to set table arrays, absolute references, and the insert function dialog.

Master the if family functions by building countif, sumif, and averageif formulas that use range and criteria to calculate totals and average sales for Swinn bikes.