Microsoft Excel & PowerPoint 2019/365 Essential Training

Learn how relative references adjust formulas when copying across columns and rows, using the fill handle in Excel to quickly populate totals, with a note on absolute references.

Learn to work with ranges in Excel, selecting adjacent cells, applying formatting or formulas, using shift-click for precise selection, and understanding how to reference ranges in formulas.

Learn how to save and save as your workbook, choose a location (documents or OneDrive), and name the file, while understanding save prompts and backstage view options.

Explore saving and sharing Excel workbooks, including file extensions like .xlsx, CSV, and PDF, plus exporting, sharing via SharePoint or email, and publishing with Power BI for self-service reporting.

Open and manage workbook files in Excel using backstage view, recent files, and pinned items, then browse folders and link cells across sheets with formulas.

Navigate large workbooks with scroll bar or wheel, use home/end keys (with ctrl), the name box, find/replace across the workbook, and freeze panes for headings.

Explore how to use the freeze panes feature in excel to keep row headings visible while scrolling, freezing rows 1–7 and optionally columns to the left via the View tab.

Use split screen to view two areas of a worksheet simultaneously with movable splitters and dual scrollbars, then turn off or save the view for future workbooks.

Learn how to print titles in Excel by repeating top rows on every page, and optionally left columns, using the page layout print titles options.

Learn to insert, edit, and delete cell comments in Excel, and control their display and printing via the review tab and page layout options.

Explore Excel page setup options, including margins, orientation, size, print area, breaks, backgrounds, scaling, and printing grid lines to tailor printed workbooks.

Complete module five practice by editing the Lone workbook: adjust page layout, add date top right and name in the footer, add a comment, set one inch margins, and print.

Learn how to adjust column and row widths in Excel to prevent text overflow and pound symbols, using drag between headers, double-click auto-fit, and width optimization.

Learn to copy formulas with the fill handle and apply relative references, then master paste options: values, formulas, transpose, and formatting for efficient data manipulation.

Move and rearrange data in Excel using the move feature and cut and paste to align a table, then place Mideast region below Northeast region and save for module 8.

Explore how formulas perform calculations in Excel, using the equal sign and operators, and discover how functions simplify adding numbers across cells, sheets, or files.

Learn to manage sheet tabs in Excel by adding, deleting, and renaming sheets, using double-click and right-click options, and organizing tabs for accurate three dimensional formulas across multiple sheets.

Explore advanced sheet tab options in Excel, including inserting, deleting, renaming, moving or copying tabs, protecting sheets, hiding, coloring tabs, and applying actions to all sheets in a workbook.

Master three dimensional formulas in Excel by creating sums across multiple sheets, selecting sheet ranges, and applying a single formula on the summary sheet for consolidated totals.

Learn how to format worksheets by styling cells and numbers, applying fonts, sizes, colors, borders, and alignments, and using the format cells dialog to rotate text and manage indents.

Explore advanced cell formatting in Excel, including wrap text, merge and center, center across selection, shrink to fit, and precise text rotation options.

Format numbers in Excel by applying currency, date, time, percentages, fractions, scientific, or text formats, use special formats, create custom rules, and manage display versus actual values with decimal adjustments.

Master borders and shading in Excel to format worksheets, print grid lines, apply outside or thick borders, adjust shading and fill effects, and even draw customized borders.

Convert a data range into a table in Excel, explore headers, banded rows, and totals, then customize table styles, filters, and options like refresh, export, and remove duplicates.

Apply styles from the Home tab to quickly format a range, then create and customize your own named styles for bold, centered text, borders, and color.

Format worksheets in practice exercise by styling tables with borders, colors, and currency formatting, then use format painter to copy styles between regions and move to charts in module eleven.