Courses

The following are courses we currently have available

Loading Courses

« All Courses

Excel Level 2 Training

April 13 @ 9:30 am

€99
excel level 2 training

Excel Level 2 Training Course

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.

Details

Date:
April 13
Time:
9:30 am
Cost:
€99
Courses Category:
Website:
https://www.newhorizons.com/

Location

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

Tickets

The numbers below include tickets for this event already in your cart. Clicking "Get Tickets" will allow you to edit any existing attendee information as well as change ticket quantities.
Excel Level 2 Training 13th April 2021
99
5 available

Sign up to our mailing list