Excel 2019 - Level 1 Introduction and Basics

Excel 2019 - Level 1 Introduction and Basics

Regular price
Sale price
Shipping calculated at checkout.

Seat time: 2 hours

About the course:

This course covers topics included in the Microsoft Office Specialist (MOS) exam 77-727. You will learn how to open workbooks, navigate directly to cells and between worksheets. You will also create new workbooks, use viewing tools, modify Excel options. Inspect Documents and check for Accessibility and Compatibility issues.


  • Screen Components
  • Navigating Workbooks
  • Viewing Tools and Excel Options
  • Creating Workbooks
  • Opening, Saving and Closing

You'll learn:

Screen Components

  • Understand Screen Components
  • Open Backstage View
  • Identify Ribbon Commands
  • Hide and Display the Ribbon
  • Use the Quick Access Toolbar
  • Show Context Sensitive Tools
  • Identify Worksheet Components
  • Use the Formula Bar
  • Recognise Mouse Cursor Shapes

Navigating Workbooks

  • Navigate with Scroll Bars
  • Use Keyboard Shortcuts
  • Use the Go To Command
  • Navigate using the Name Box
  • Work with Sheet Tabs
  • Use Tab Scrolling Buttons

Viewing Tools and Excel Options

  • Use the Zoom Feature
  • Split Windows
  • Freeze Panes and Unfreeze Panes
  • Use General Options
  • Use Save Options
  • Use Proofing Options
  • Inspect Documents
  • Check for Accessibility Issues
  • Check for Compatibility

Creating Workbooks

  • Create New Workbooks
  • Enter Values
  • Enter Labels
  • Enter Dates
  • Enter Data into a Range
  • Replace Cell Content
  • Add Additional Cell Content
  • Remove Cell Content

Opening, Saving and Closing

  • Open Excel Workbooks
  • Open Recent Workbooks
  • Open Workbooks with Search
  • Move Between Workbooks
  • Save Workbooks
  • Use Save As
  • Close Workbooks
  • Quit Excel