Excel – Excel Functions Including Pivot Tables and Lookups

New Horizons UK

Excel – Excel Functions Including Pivot Tables and Lookups

59 59 people viewed this event.

Course Overview 

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.

Schedule 

See the source image

Date:

16 December, 2021

See the source image

Time:

09:30 – 17:00 UK Time

See the source image

Duration:

7 hours

See the source image

Price:

GBP 248 + VAT

Learning Objectives

Upon successful completion of this course, you will be able to create and develop Excel 2016 worksheets and workbooks in order to work with and analyse the data that is critical to the success of your organization.

Course Outline

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
2 – WORKING WITH LISTS AND TABLES
  • Sort and Filter Data
  • Remove Duplicate Values
  • Group and Outline Data
  • Subtotal Data
3 – VISUALIZING DATA WITH CHARTS
  • Create and Modify Charts
  • Use Advanced Chart Features
  • Save a Custom Chart Template
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
 
 
 
 
 
 
 
 

 

Target Audience

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

Additional Details

Price - 248

 

Date And Time

16-December-2021 - 09:30 to
- 17:00
 

Location

 

Venue

Live Online (Zoom)
 

Event Category

Live Online Courses

Share With Friends