Text

6 CPE

Surgent's Microsoft® Excel® 2016: Getting Started

This is a text-based course

Text
6 CPE

This is a text-based course. To receive credit, you are required to review all content and achieve a minimum score of 70% on the final exam.

This course introduces you to the Excel 2016 software and then guides you through basic Excel features using step-by-step hands-on activities.

Learning Objectives

  • Explain how the Excel software is used
  • Start Excel
  • Identify the components of the Excel window
  • Describe a workbook and a worksheet
  • Navigate and select in a worksheet
  • Modify user options or preferences
  • Create and save a workbook
  • Enter, edit, and format text and numbers
  • Create basic formulas and use functions
  • Work in different worksheet views
  • Preview and print a worksheet
  • Work in Backstage view
  • Use the Quick Access Toolbar, the Ribbon, the Tell Me feature, the Smart Lookup feature, shortcut menus, and keyboard shortcuts to perform basic tasks

Major Topics

  • Describe the Excel application and explain how it is used
  • Start Excel, describe the Start screen, and create a new workbook
  • Describe Excel window elements
  • Open an existing workbook
  • Navigate in a worksheet
  • Select in a worksheet
  • Change Excel options
  • Access Excel help and use Key Tips
  • Close a workbook and close Excel
  • Save a workbook
  • Insert, reposition, select, delete and rename worksheets
  • Enter, edit and format cell contents
  • Create formulas
  • Use functions
  • Apply Accounting and Percent Style formatting
  • Use Flash Fill for data entry
  • Show and hide worksheet elements
  • Undo and redo an action
  • Work in Normal view, Page Layout view and Page Break Preview
  • Set page setup options, preview, and print a worksheet

CPE Credits Available

6 CPE
6
Computer Software & Applications

Things to Know About This Course

Course Level

  • Basic

Professional Area of Focus

  • Technology

Prerequisites

No prior knowledge of the Excel 2016 software is necessary; however, basic Windows and keyboarding skills are required

Advanced Preparation

None

Intended Audience

New Excel users or experienced Excel users switching from earlier versions

Provider

Surgent CPE

Purchase This Course

  • COCPA Member

    $ 119 119
    Join

  • COCPA Non-Member

    $ 155 155
    Your Price

Please login to register.