€275
Excel Functions Including Pivot Tables and Lookups

Excel Functions Including Pivot Tables and Lookups

Actions and Detail Panel

€275

Event Information

Share this event

Date and time

Location

Location

Online event

Event description
This course is designed for students who already have foundational knowledge and skills in Excel 2016

About this event

1 - 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

2 - WORKING WITH LISTS AND TABLES

Sort and Filter Data

Remove Duplicate Values

Group and Outline Data

Subtotal Data

3 - VISUALIZING DATA WITH CHARTS

Create and Modify Charts

Use Advanced Chart Features

Save a Custom Chart Template

4 - 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

Share with friends

Date and time

Location

Online event

Save This Event

Event Saved