MS Excel 2016 – Level 2

Request info

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

SELECT wp_posts.*, wp_p2p.* FROM wp_posts INNER JOIN wp_postmeta ON ( wp_posts.ID = wp_postmeta.post_id ) INNER JOIN wp_p2p WHERE 1=1 AND ( ( wp_postmeta.meta_key = 'start_date' AND CAST(wp_postmeta.meta_value AS DATE) >= '2025-02-08' ) ) AND ((wp_posts.post_type = 'schedule' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) AND (wp_p2p.p2p_type = 'schedule_to_courses' AND wp_posts.ID = wp_p2p.p2p_from AND wp_p2p.p2p_to IN (SELECT wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.ID IN (10362) AND ((wp_posts.post_type = 'courses' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'acf-disabled'))) ORDER BY wp_posts.post_date DESC )) GROUP BY wp_posts.ID ORDER BY CAST(wp_postmeta.meta_value AS DATE) ASC