Microsoft Excel 2019 Foundation

Course Modules

• Module 1: Getting Started with Microsoft Excel 2019

  Topic A – Identify the Elements of the Excel Interface
  • Microsoft Excel 2019
  • What is Spreadsheet, Worksheet and Workbook
  • What are Columns, Row, Cells, and Ranges
  • The Excel Interface
  • Navigation Options

  Topic B Creating a New Blank Workbook
  • The Ribbon
  • The Backstage View
  • The Save and Save As Commands

• Module 2: Formatting a Worksheet

  Topic A: Formatting Fonts
  • Fonts
  • The Font Group
  • The Format Cells Dialog Box
  • The Format Painter
  • Live Preview and Formatting
  • The Mini Toolbar
  • The Clear Button

  Topic B: Add Borders and Colors to Cells
  • Border Options
  • Fill Options
  • Sheet Backgrounds

  Topic C: Apply Number Formats
  • Number Formats
  • Dragging and Dropping Cells
  • How to cut, copy, and paste cells
  • How to cut, copy, and Paste Multiple cells
  • Using the Clipboard
  • Using Paste Special
  • Number Formats in Excel
  • Custom Number Formats

  Topic D: Align Cell Contents
  • Alignment Options
  • The Indent Commands
  • The Wrap Text Command
  • Orientation Options

• Module 3: Modifying a Worksheet

  Topic A: Manipulate Data
  • The Undo and Redo Commands
  • The AutoFill Feature
  • Auto Fill Options
  • The Transpose Option
  • Live Preview

  Topic B: Insert, Manipulate, and Delete Cells, Columns, and Rows
  • The Insert and Delete options
  • Column Width and Row Height Alternation Methods
  • The Hide and Unhide Options

  Topic C – Search for and Replace Data
  • The Find Command
  • The Replace Command
  • The Go to Command

  Topic D – Spell Check a Worksheet
  • The Spelling Dialog Box

• Module 4: Performing Calculation

  Topic A: Create Formulas in a Worksheet
  • Excel Formulas
  • The Formula Bar
  • Elements of an Excel Formula
  • Common Mathematical Operators
  • The Order of Operations
  • Division Formula

  Topic B: Insert Functions in a Worksheet
  • Functions
  • The Function Library
  • Common Functions in Excel (SUM, AVERAGE, COUNT, MIN & MAX)

• Module 5: Managing Large Workbooks

  Topic A: Format Worksheet Tabs
  • Renaming Worksheet Tabs
  • Changing Tab Color

  Topic B: Manage Worksheets
  • Repositioning Worksheets
  • Inserting or Deleting Worksheets
  • Hiding and Unhiding Worksheets
  • Worksheet References in Formulas

  Topic C: Manage the view of Worksheets and Workbooks
  • Split Command
  • Freeze Panes options
  • Arrange All Command
  • Arrange Windows Dialog Box
  • View Side by Side Command
  • Switch windows Command
  • New Window Command

• Module 6: Printing Workbook Contents

  Topic A: Define the Basic Page Layout for a Workbook
  • The Print Options in Backstage View
  • The Page Setup Dialog Box
  • The Print Preview Option
  • Headers and Footers
  • Header and Footer Settings
  • Page Margins
  • Margins Tab Options
  • Page Orientation

  Topic B: Refine the Page Layout and Apply Print Options
  • Zoom Options
  • Page Breaks
  • Page Break Options
  • The Print Area
  • Print Titles
  • Scaling Options