Excel Functions Including Pivot Tables and Lookups
Date and time
Location
Online event
Refund policy
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