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 than the Level 1 course.
Pre-requisites
Before starting this course, students are recommended to take the following course or have equivalent knowledge:
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
