20. March 2020 - 9:00 till 17:00
Share it on:

Excel Functions Including Pivot Tables and Lookups | New Horizons Ireland | Friday, 20. March 2020


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: