Events Search
  Summary & Check Out (0)

Microsoft® Excel® 2016: Getting Started (Z1-EX16-2022-01-SSDL)

300 Minutes
On demand - Audio

On Demand - Audio

6 CPE Credits in SK

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.

DESIGNED FOR

New Excel users or experienced Excel users switching from earlier versions

BENEFITS

  • 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

HIGHLIGHTS

  • 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

COURSE LEVEL

Basic

PREREQUISITES

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

PRICING

$119.00 - Member

$139.00 - Nonmember

ADDITIONAL OPTIONS

Remind me to register

Print a registration form

COURSE DEVELOPER

Surgent

AREAS OF INTEREST

Related events

November 25, 2024
Shortcuts that Excel Users Love
November 26, 2024
Improve Design and Productivity with Excel Tables
November 26, 2024
Excel - Fundamentals, Data Entry and Basic Formulas
November 30, 2024
Mastering the Excel Lookup Functions
FIRST
    LAST

      Related content

      article image
      ARTICLE

      10 Types of Excel Charts for Data Visualization

       October 9, 2024 Source: Journal of Accountancy
      blog image
      BLOG

      How Tech Skills Can Help Elevate Your Accounting Career

       September 3, 2024 Source: Robert Half