Excel 2016 Training
Course Description
In this 1 day course 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.
Who is this course for:
Delegates desiring to gain a more advanced skill set that the Level 1 course.
Delegate Requirements:
Before starting this course, students are recommended to take the following course or have equivalent knowledge: Microsoft Office Excel 2016: Level 1.
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
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
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
Analysing Data
Applying Basic Filters
Advanced Filters
Use Outlines to organize data
Organizing Worksheet Data
Apply basic sorting to a Data Range
Advanced Sorting
Summarise Data with Subtotals
Working with Excel Tables
Introducing Excel Tables
Creating calculated columns
Formatting a Table
Using Slicers
Converting Tables to Ranges
Creating and Applying Conditional Formatting
Conditional Formatting
Customizing Conditional Formatting
Sorting and Filtering by Conditional Formats
Collaborate with Others
Protected View
Track Changes
Workbook Merging
Adding and working with INQUIRE Add-In
Duration:1 Day
Cost: £235 + VAT