Course Description

You will use advanced formulas and work with various tools to analyze data in spreadsheets. You will also organize table data, present data as charts, collaborate with others and work with conditional formatting.

Target Student

This course is meant for those desiring to gain a more advanced skill set that the Level 1 course.

Pre-requisites

Before starting this course, students are recommended to take the following course or have equivalent knowledge:

• Microsoft Office Excel 2016: Level 1

Performance-Based Objectives

Upon successful completion of this course, students will be able to:

• use advanced formulas
• organize worksheet and table data using various techniques
• create and modify charts
• create and use formatting conditions
• collaborate with others

Course Content

Lesson 1: Calculating Data with Advanced Formulas

• Work with Range Names
• Calculate across worksheets and workbooks
• Analyze Data with Logical and Lookup Functions
• IFS and Switch Functions

Lesson 2: Presenting Data Using Charts

• Understanding Charts and Chart types
• Create a Chart
• Modify and Format Charts
• Add and remove Chart data
• Add a Trendline to a Chart
• Analyse Data using Sparklines

Lesson 3: Organizing Worksheet Data

• Apply basic sorting to a Data Range
• Advanced Sorting
• Summarise Data with Subtotals

Lesson 4: Analysing Selected Data

• Applying Basic Filters
• Advanced Filters
• Use Outlines to organize data

Lesson 5: Mastering Excel Tables

• Introducing Excel Tables
• Creating calculated columns
• Formatting a Table
• Using Slicers
• Converting Tables to Ranges

Lesson 6: Applying Conditional Formatting

• Conditional Formatting
• Customizing Conditional Formatting
• Sorting and Filtering by Conditional Formats

Lesson 7: Collaborate with Others

• Protected View
• Track Changes
• Workbook Merging
• Adding and working with INQUIRE Add-In