Excel Functions Including Pivot Tables and Lookups
Duration: 1 day
Next Course date is 13th April 2021
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.
