Courses

The following are courses we currently have available

Loading Courses

« All Courses

Excel Level 2 Training

March 20 @ 9:30 am

€140
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 Maureen@dppskillnet.ie to book your place.

Details

Date:
March 20
Time:
9:30 am
Cost:
€140
Courses Category:
Website:
https://www.newhorizons.com/

Location

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

Tickets

15 available
Excel Level 2 Training140

Sign up to our mailing list