Excel - Excel Functions Including Pivot Tables and Lookups

Duration

1 Days

This course is intended for

To ensure success, students should have completed Excel Essentials or have the equivalent knowledge and experience.

Overview

Upon successful completion of this course, you will be able to leverage the power of data analysis and presentation in order to make informed, intelligent organizational decisions.

Description

This course is designed for students who already have foundational knowledge and skills in Excel 2016 and who wish to begin taking advantage of some of the higher-level functionality in Excel to analyse and present data.

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

Working with Lists and Tables

Sort and Filter Data
Remove Duplicate Values
Group and Outline Data
Subtotal Data

Visualizing Data with Charts

Create and Modify Charts
Use Advanced Chart Features
Save a Custom Chart Template

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

What people say about us

Excellent interaction and answered all of my questions. Looking forward to being able to apply some of the tips and features learned today which hopefully should have real impact on some of the more time consuming tasks currently encountered.

Dublin student

This is the 3rd course I have done with Arun. He is very helpful and always supportive if I have other questions outside the lecture parameters. I have already recommended him and Nexus Human to work colleges and would do so again after this course.

Philip

Dublin classroom student

Great course yesterday and can’t give enough amazing feedback for John. I’ve never had a teacher hold attention of a class from start to finish, but yesterday he did this.

Jennifer O'Connor

Vistra Ireland

Booking process was very easy. Once initial contact was made everything happened smoothly.

Pfizer

Brilliant
Wonderful teacher
Course presented extremely well indeed

Nexus Human Ireland Student feedback

This was my 2nd course with Nexus Human and I enjoy the format of the courses.
This was very well-run, the instructor was superb and i will get a lot of benefit from having access for the next 6 months, I look forward to the next course.

Cathal

Kerry, Ireland

I would like to thank the staff of Nexus Human, who were very helpful, prompt, friendly and professional in helping me attain my Microsoft certification. I would like to thank Abdul in particular for his guidance during the course and commend him on his knowledge of software development.

Paul

ITC Group
Dublin

The instructor was excellent. Was willing to field any questions we had and deal with our specific queries.

Excel student

The class just finished and I just wanted to mention to you that it was absolutely amazing. The quality of the training had very high standards, the trainer explained amazingly well and we actually practiced (did) all the steps. It was not learning by watching a presentation but by actually doing. The training has been delivered from Atlanta (US) and I cannot wait to go tomorrow in the office and recommend it. The connection and the lab environment were running perfectly.
Once again thank you very much and looking forward for the next trainings scheduled. Enrolling via Nexus Human Dublin was the perfect choice.

Cristina, Online Live student

Firstly I would like to say thanks, I found the course I sat yesterday extremely beneficial and the instructor was fantastic, she was enthusiastic and engaging and I would highly recommend the course to friends and colleagues. The post class services are also excellent!

Nexus Human Ireland student

Sharon was lovely and has a fantastic knowledge. Honestly I didn't think I needed part 1 but I am SO glad I came. Thank you. Will be back in for part 2.

Dublin student

Your Recommended Dates

GTR = Guarenteed to Run

07 Dec 23Book Now

09:30 - 17:00Live Online275

16 Jan 24Book Now

09:30 - 17:00Live Online275

21 Feb 24Book Now

09:30 - 17:00Live Online275

20 Mar 24Book Now

09:30 - 17:00Live Online275

17 Apr 24Book Now

09:30 - 17:00Live Online275

15 May 24Book Now

09:30 - 17:00Live Online275

19 Jun 24Book Now

09:30 - 17:00Live Online275

10 Jul 24Book Now

09:30 - 17:00Live Online275

20 Aug 24Book Now

09:30 - 17:00Live Online275

17 Sep 24Book Now

09:30 - 17:00Live Online275

15 Oct 24Book Now

09:30 - 17:00Live Online275

12 Nov 24Book Now

09:30 - 17:00Live Online275

10 Dec 24Book Now

09:30 - 17:00Live Online275

Find out more about this course

Interested in alternative dates? Would like to book a private session of this course for your company? Or for any other queries please simply fill out the form below.

Excel - Excel Functions Including Pivot Tables and Lookups

Duration

This course is intended for

Overview

Description

Working with Functions and Complex Calculations

Working with Lists and Tables

Visualizing Data with Charts

Using Tables, Pivot Table Reports and Pivot Charts

What people say about us

Dublin student

Philip

Jennifer O'Connor

Pfizer

Nexus Human Ireland Student feedback

Cathal

Paul

Excel student

Cristina, Online Live student

Nexus Human Ireland student

Dublin student

Your Recommended Dates

View additional local dates

Find out more about this course