Back to Course List
Microsoft Excel 2016 Level 2.2: Working with Lists
- Product ID
- sonie16wl_vod
- Training Time ?
- 14 to 23 minutes
- Language(s)
- English
- Video Format
- High Definition
- Required Plugins
- None
- Number of Lessons
- 4
- Quiz Questions
- 9
- Closed Captioning
- Question Feedback
- Wrong Answer Remediation
- Lesson Bookmarking
- Downloadable Resources
Overview
This online training teaches viewers how to manage their lists in Microsoft Excel 2016. This training demonstrates the different options available in Microsoft Excel 2016 to organize lists, and shows how employing such strategies makes it easier and more efficient to work with data in a spreadsheet.
This course walks you through the tools available in Microsoft Excel 2016 workbooks to work with list data, such as sorting and filtering.
Microsoft Excel 2016 offers powerful list management tools. Learn how to use Microsoft Excel 2016 to effectively manage list data with this course.
This course is in the Video On Demand format, to read about Video On Demand features click here.
- Install on any SCORM LMS
- Full-screen video presentation
- Print certificate and wallet card
- You have 30 days to complete the course
Workplaces
Categories
Audience
Excel 2016 users
Topics
The course presents the following topical areas:
- Sort Data
- Filter Data
- Query Data with Database Functions
- Outline and Subtotal Data
Intended Performance Outcomes
Upon successful completion of this course you will be better prepared to:
-
Sort data.
- Identify the formatting functions used to ensure proper sorting.
- Recall the different features available from the Sort button.
-
Filter data.
- Distinguish between sorting and filtering data.
-
Query data with database functions.
- Define a column of data.
- Locate defined names from your workbook.
-
Outline and subtotal data.
- Identify an important step when using the subtotal function.
- Locate outline views.
© Mastery Technologies, Inc.
