Operational Excellence with Microsoft Excel

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: Modify Fonts
  – Fonts
  – The Font Group
  – The Format Cells Dialog Box
  – The Format Painter
  – Live Preview and Formatting
  – The Mini Toolbar

  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
  – Orientation Options
  – The Merge & Center Options

  Topic E: Apply Cell Styles
  – Cell Styles
  – The Style Dialog Box

• 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
  – The Clear Button

  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: 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 5: 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 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 Area
  – Scalling Options