MS Office; Excel, Word, Access & PowerPoint 2019 - Beginners

Create a new blank workbook, set column headings (months, sales, expenses, totals, profits), and enter sample data. Use the fill handle to auto-fill months and learn formulas to sum sales.

Learn how to create basic formulas in Excel, including add, subtract, multiply, and divide using cell references and the equal sign, across sheets or files, and understand relative references.

Explore relative references in Excel, using the fill handle to copy formulas across columns and down rows, with absolute references and the order of operations introduced.

Discover the order of operations in math and how Excel applies it to formulas with parentheses, exponents, and the multiplication, division, and addition sequence.

Master working with ranges in Excel: select adjacent cells, apply formatting like dollars and centering, and reference ranges in formulas with examples such as B2:C4.

Create a blank workbook with monthly sales and expenses, build profit formulas, sum totals, apply the order of operations for April projections, and save the file for Module 3.

Save workbooks with save or save as, name the file clearly, and choose a location such as documents or OneDrive. Update changes frequently and explore share or export options.

Explore saving, sharing, exporting, and publishing Excel files, including xlsx, csv, and pdf formats, using SharePoint sharing, email, and Power BI for self-service reports and dashboards.

Save your workbook using save as, create a desktop folder named my sales report, ensure the file extension is .xlsx, and review share, export, and publish options.

Open Excel workbooks via the file tab and backstage view, pin recent files, and link the terms of loan and detail sheets with formulas and sheet references.

Navigate large Excel files with the scroll bar, mouse wheel, and home/end keys; use the name box, find and select, and freeze panes to keep headings visible.

Learn to use the freeze panes option in Excel to keep row and column headings visible while scrolling, freezing rows and left columns, and unfreeze, with split screen.

Learn to use split screen in Excel to view two areas of a workbook simultaneously, adjust the splitter, and preserve the splitter on save as you navigate between sections.

navigate workbooks and worksheets, link c9 on the detail sheet to d3 on the terms of loan, and use freeze panes and split view to review the loan schedule.

Shows how to use headers and footers in Excel, including dates, file names, and page numbers, with page layout view, different first page, and odd/even options for print-ready docs.

Set print titles in Excel by repeating top rows at the top of every page to keep column headings visible, using the page layout view and print preview.

Learn to use Excel's cell comments: insert, edit, delete, and navigate; show or hide; print via page layout options (end of sheet or as displayed); adjust size.

Navigate Excel's page setup options to control margins, orientation, size, print area, and breaks, then adjust headers, footers, backgrounds, and grid lines for print-ready outputs.

Learn to fit an Excel workbook on one page by using page break preview, adjusting scaling, and choosing orientation to keep all columns and totals printing together.

Explore how to print Excel workbooks with precision, using backstage print options, print preview, and page setup to control margins, paper size, orientation, scaling, and selections.

Perform a practice exercise on Excel page setup and print options, add date and name to header/footer, adjust margins, set print titles, then print and save the workbook.

Master how to add and delete rows, columns, and cells in a workbook, including inserting sheet rows or columns, shifting cells, and using the fill handle to extend totals.

Learn to adjust column and row widths in Excel using drag between headers to resize and double-click to auto-fit, and handle text spillover and pound symbols when space is insufficient.

practice exercise covers inserting and deleting rows, columns, and cells in the Eastern Regions Report; add a new salesperson, create totals with a formula, and save and close the file.

Master cut, copy, and paste across the clipboard by selecting data, moving or duplicating it between cells and programs, using the four steps for cross-application pasting.

Learn how to copy formulas in Excel using the fill handle, with relative references adjusting across columns and rows, and explore paste options like values, formulas, transpose, and formatting.

Practice exercise guides you through moving data in Excel using move and cut/paste to align a table. Open the eastern regions report, move the Mideast region below the northeast region.

Explore how formulas perform mathematical calculations in Excel, starting with the equals sign and cell references, and learn to use functions to simplify data across sheets or files.

learn to create formulas using functions in excel, use auto sum to total ranges, and apply common functions like sum, average, max, and count.

Explore how to create formulas using functions in Excel, including sum, max, min, count, if statements. Learn to use function arguments, relative and absolute references, and copy formulas across cells.

Master absolute values in Excel by converting relative references to absolute with dollar signs, ensuring the 15% commission rate remains fixed as you copy formulas.

Apply basic spreadsheet formulas to compute sums, averages, highs, and commissions in the Eastern and Mideast regions. Use absolute references when copying formulas across and down the sheet.

Save your workbooks with save and save as, naming files clearly. Save frequently to update changes, choose locations with browse or backstage view, and consider one drive for cloud access.

Master working with sheet tabs by adding, deleting, and renaming sheets, and organizing them to support a three-dimensional formula across multiple worksheets.

Explore workbook sheet tab options in Excel, including insert, delete, rename, move or copy, protect with password, color, hide and unhide, select all sheets, and three-dimensional formulas.

Master three dimensional formulas in Excel by learning to sum data across multiple sheets into a summary sheet, selecting a range of sheets with shift-click, and using the sum function.

Rename the first five sheets to divisions, add and delete a sheet, color the summary tab, and build a three dimensional formula across sheets into the summary sheet.

Learn how to format cells and numbers in Excel worksheets, from borders and shading to bold headers and currency formatting, plus font, alignment, and text orientation options.

Learn advanced cell formatting in Excel, exploring wrap text, merge and center, center across selection, shrink to fit, and precise text orientation and rotation using alignment tools.

Format numbers in Excel by applying currency, dates, times, percentages, fractions, and text, using custom formats and special formats like phone numbers and social security numbers.

Learn to apply borders and shading to Excel workbooks, including printing grid lines, drawing custom borders, and using fill colors, patterns, and pencil tools for emphasis.

Convert a data range into an actual Excel table, enable headers, and explore table tools, filtering, banded rows, total rows, and custom table styles.

Learn to format worksheets quickly using styles in Excel. Apply, edit, and create new styles, center data, and prepare borders; clear formatting and use format painter.

Learn to use the format painter in Excel to copy formatting across cells and regions, with tips to start, lock, and maintain exact row and column alignment.

Protect sheets, cells, and workbooks in Excel by unlocking specific cells, preserving formulas using constants, and setting passwords, with options to allow edit ranges and share the workbook on SharePoint.

Explore how the fill handle copies cell content and extends predefined lists, then create, import, or delete custom lists to automate repeating sequences across Excel workbooks.

Master worksheet formatting in Excel with the regional report exercise, adding borders, colors, and dollar signs, and using the Format Painter to copy styles across regions; prepare for charts.