Excel - Excel Functions Including Pivot Tables and Lookups

Duration

1 Days

This course is intended for

To ensure success, students should have completed Excel Essentials or have the equivalent knowledge and experience.

Overview

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

Description

This course is designed for students who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyse and present data.

Working with Functions and Complex Calculations

Summarising Data using Functions (Sum/SumIf, Count/CountIf etc.)
Work with Logical Functions
Work with Lookup Functions
Work with Date and Time Functions
Work with Text Functions

Working with Lists and Tables

Sort and Filter Data
Remove Duplicate Values
Group and Outline Data
Subtotal Data

Visualizing Data with Charts

Create and Modify Charts
Use Advanced Chart Features
Save a Custom Chart Template

Using Tables, Pivot Table Reports and Pivot Charts

Create and Modify Tables
Use Functions to Calculate in Tables
Create a Pivot Table Report
Manipulate Pivot Tables
Present Data with Pivot Charts
Filter Data by Using Slicers and Timelines