MS Excel 2016 – Level 2
- Course focuses on advanced Excel skills, data analysis, chart creation, and collaboration.
- Designed for those seeking a higher skill level than Level 1 Excel course.
- Students will learn advanced formulas, data organization, chart modification, and collaboration.
- Content includes working with formulas, charts, data analysis, and conditional formatting.
- Participants will gain skills in data calculation, chart creation, and data organization.
Overview
The Excel 2016 Training course is designed for individuals seeking to enhance their skills beyond the Level 1 course. Participants will learn to use advanced formulas, analyze data, create and modify charts, apply formatting conditions, and collaborate with others. The course covers topics such as advanced formulas, chart creation and modification, data analysis, worksheet organization, Excel tables, conditional formatting, and collaboration tools. The course duration is 1 day.
Who should attend
Delegates
Course Content
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