The following are courses we currently have available

Loading Courses

« All Courses

Excel Level 2 Training

March 20 @ 9:30 am

excel level 2 training

Excel Level 2 Training Course

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 to book your place.


March 20
9:30 am
Courses Category:


New Horizons
22-24 Strand Street Great,
Dublin, 1 Ireland
+ Google Map


15 available
Excel Level 2 Training140

Sign up to our mailing list