Surgent's Microsoft® Excel® 2016: Getting Started (EX16)

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.

Prerequisites

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

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

Highlights

• 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