NewEra Technology Facebook
Microsoft Excel 2016 Level 2 - Course Information
PRINT
SEND TO A FRIEND
Name: Microsoft Excel 2016 Level 2
Category: Microsoft Office Suite
Length (Days): 1
Course Price (CAD): 245
Description:
The target students for this course are those who desire to gain the skills necessary to create templates, sort and filter data, analyze data, create charts and Pivot tables.

Participants will also continue to build on the skills learned in Level 1 regarding the creation of formulas.
Prerequisites:
Participants should have basic Windows operating skills (Computers 101 class or equivalent). This includes understanding the basic operation of a mouse and keyboard, being able to navigate the Windows hierarchy, as well as being able to open and close files in an application.

Microsoft Excel 2016 Level 1 or equivalent knowledge.
Outline:
Working with Functions
• Work with Ranges
• Use Specialized Functions
• Work with Logical Functions
• Work with Date & Time Functions
• Work with Text Functions

Working with Lists
• Sort Data
• Filter Data
• Query Data with Database Functions
• Outline and Subtotal Data

Analyzing Data
• Create and Modify Tables
• Apply Intermediate Conditional Formatting
• Apply Advanced Conditional Formatting

Visualizing Data with Charts
• Create Charts
• Modify and Format Charts
• Use Advanced Chart Features

Using PivotTables and PivotCharts
• Create a PivotTable
• Analyze PivotTable Data
• Present Data with PivotCharts
• Filter Data by Using Timelines and Slicers
Guaranteed to run courses