Surgent's Microsoftr Excelr 2016: Getting Started
Available Until Wednesday, Apr. 30, 2025
6.00 Credits
Member Price $119.00
Non-Member Price $214.00
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.
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
Designed For
New Excel users or experienced Excel users switching from earlier versions
Prerequisites
No prior knowledge of the Excel 2016 software is necessary; however, basic Windows and keyboarding skills are required
Preparation
None
Notice
This self-study product is a course manual download with a test.
You will receive an email from Surgent CPE with instructions to access this course.
Non-Member Price $214.00
Member Price $119.00