Master relative and absolute cell references in Excel to calculate totals and taxes, copy formulas with the fill handle, and freeze references with dollar signs to keep values constant.

Explore how to format numbers in Excel, applying currency and accounting formats, date formats, percentages, comma separators, and rounding and decimal control for clear reports.

Navigate and select data in Excel using mouse drag, crosshair pointers, keyboard shortcuts (Ctrl home, Ctrl end, page up/down, arrow keys), and options for rows, columns, or the entire sheet.

Explore basic Excel formulas for addition, subtraction, multiplication, and division using fruits as examples, teaching cell selection, operators, and auto-updating totals for cost and quantity.

Master cross-worksheet calculations in Excel by linking monthly expenses and savings across January through April. Use cell references and auto sum to update totals across four months.

Create a new worksheet, enter names and marks, and use autosum to total scores in Excel. Enter dates using month/date/year and observe the date formatting in the worksheet.

Use print preview to see how your worksheet will print, and adjust orientation, margins, and paper options. Avoid blank pages by printing only the selected data or a defined range.

Master page breaks in excel using page break preview, adjust orientation and margins, and apply manual or automatic breaks to keep data printing on the correct pages.

Mastering print titles in Excel, this lecture demonstrates repeating header rows on every printed page using page layout, rows to repeat at top, and print preview adjustments.

Learn to sort data in Excel using the sorting tool, with single and multiple levels by department, job title, agency, and city, while handling headers and text or numeric order.

Master how to filter data in Excel using the filter tool, with criteria for country, segment, discount, year, and month, plus top N options and clear filters.

Explore how to copy and paste in excel, including keeping source formatting, pasting values or formulas, transposing data, and pasting as images or links across sheets and applications.

Practice alignment tools in Excel to horizontally align data (left, center, right) and vertically align headings (top, middle, bottom), wrap text, merge cells for centered data, and adjust orientation.

Learn to format Excel data using the borders tool, apply various borders (bottom, top, outside, inside), customize color and style, and manage border removal for clean worksheets.

Master essential charting in Excel by creating and customizing pie, bar, and line charts from selected data, including categories and sales, and using fill handles to extend data for comparison.

Master moving and resizing charts in Excel, copy and paste across sheets, and use design and page layout tools to fit charts on one page for printing.

Copy and paste charts from Excel to Word or PowerPoint, choosing destination or source themes, embedding or linking data, and controlling formatting and updates.

Learn to customize charts in Excel by applying quick layouts, changing colors, and switching chart types, then refine elements with the plus icon and format pane.

Learn to locate specific data quickly in Excel using find, find next, and find all, then replace values with replace and replace all, plus keyboard shortcuts.

Use the fill handle to copy text, extend numbers in a sequence, and fill dates or weekdays. It recognizes patterns and can automatically generate emails from first and last names.

Apply conditional formatting in Excel to highlight and visualize data using rules such as greater than, less than, top/bottom values, color scales, data bars, and icon sets.