20. March 2020 - 9:00 till 17:00
Excel Functions Including Pivot Tables and Lookups | New Horizons Ireland | Friday, 20. March 2020
To ensure success, students should have completed Excel Essentials or have the equivalent knowledge and experience.
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.
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: