Excel Functions Including Pivot Tables and Lookups

Duration: 1 day

Next Course date is 20th March 2020

Course Content for Excel Level 2 Training

Module 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

Module 2: Working with Lists and Tables
• Sort and Filter Data
• Remove Duplicate Values
• Group and Outline Data
• Subtotal Data

Module 3: Visualizing Data with Charts
• Create and Modify Charts
• Use Advanced Chart Features
• Save a Custom Chart Template

Module 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

Contact Maureen@dppskillnet.ie to book your place.