Customer Service: 800-778-7436     

To access your product click the Log In link at the top right of the screen. Once inside your account, you will be able to access your Packages, Self-Study Product, and Webinar Registrations.

Sign In to Your Surgent Account

Forgot Username or Password | Register for an Account

Microsoft® Excel® 2016: Getting Started (EX16)

  • Format Self-Study Download
  • Credits 6.00
  • Level Basic
  • Field of Study Computer Software & Applications (6)

Overview

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



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

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

Who should take this course:

New Excel users or experienced Excel users switching from earlier versions

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

None

No

No

No

QAS Approval Surgent
IRS Approval Surgent
CFP Approval Surgent
CTEC Approval Surgent
CPE Webinars
CPE Webinars

Thank You!

Thank You! Your subscription has been submitted.