Loading...

Course Description

This course builds on the skills and concepts taught in Excel 2016 (365) Level I. Students will learn how to use more advanced functions. They will also learn several sorting and filtration procedures. Basic and advanced conditional formatting will be covered as well as simplifying data presentations with grouping and outlining. Students will create charts from both spreadsheet data and from pivot tables. This course also covers advanced charting techniques, use of trendlines and sparklines, as well as worksheet auditing and protection.

Prerequisites

Excel 2016 (365) Level I or equivalent.

Course 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

Notes

For more Computer Applications courses click here.

Loading...

Enroll Now - Select a section to enroll in

Section Title
Microsoft Excel 2016 (365) Level II
Type
Lab
Days
Th, F
Time
8:30AM to 2:30PM
Dates
Oct 22, 2020 to Oct 23, 2020
Schedule and Location
Contact Hours
10.0
Location
Delivery Options
Classroom  
Course Fee(s)
Fee + 15% HST non-credit $399.00
Section Title
Microsoft Excel 2016 (365) Level II
Type
Lab
Days
Th, F
Time
8:30AM to 2:30PM
Dates
Nov 26, 2020 to Nov 27, 2020
Schedule and Location
Contact Hours
10.0
Location
Delivery Options
Classroom  
Course Fee(s)
Fee + 15% HST non-credit $399.00
Section Title
Microsoft Excel 2016 (365) Level II
Type
Lab
Days
M, T
Time
8:30AM to 2:30PM
Dates
Feb 22, 2021 to Feb 23, 2021
Schedule and Location
Contact Hours
10.0
Location
Delivery Options
Classroom  
Course Fee(s)
Fee + 15% HST non-credit $399.00
Section Title
Microsoft Excel 2016 (365) Level II
Type
Lab
Days
M, T
Time
8:30AM to 2:30PM
Dates
May 10, 2021 to May 11, 2021
Schedule and Location
Contact Hours
10.0
Location
Delivery Options
Classroom  
Course Fee(s)
Fee + 15% HST non-credit $399.00
Required fields are indicated by .