€275

Excel Functions Including Pivot Tables and Lookups

Event Information

Share this event

Date and Time

Location

Location

New Horizons Ireland

22-24 Strand Street Great, Strand House

D01 W1W4 Dublin 1

Ireland

View Map

Refund Policy

Refund Policy

Refunds up to 30 days before event

Event description

Description

TARGET AUDIENCE

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


COURSE OBJECTIVES

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.


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

More information click below:

https://www.nhireland.ie/training-and-certifications/course-outline/id/1020884115/c/excel-2016-excel-functions-including-pivot-tables-and-lookups



Share with friends

Date and Time

Location

New Horizons Ireland

22-24 Strand Street Great, Strand House

D01 W1W4 Dublin 1

Ireland

View Map

Refund Policy

Refunds up to 30 days before event

Save This Event

Event Saved