
EXCEL ANALYTICS
TARGETED MODULE: HALF DAY
Participant Profile
For any employees that utilize excel for analyzing large data sets, creating on-going reports, and merging data sets.
Course Size: 10-15 participants
Location: Meliora's Training Facility or On-Site at Client's Location
Course Description
Microsoft Excel is one of the most widely-used analytics tools available today. Leveraging Excel’s analytical abilities, specifically pivot tables and VLOOKUP, to create efficient data analysis can give participants back hours in their day. Students will learn to create and manage pivot tables, VLOOKUPs and pivot charts to improve their Excel efficiency and analytic prowess. Course topics include data layout, pivot tables, VLOOKUP, HLOOKUP, shortcut keys, and charts.
Learning Objectives
-
Merge and append data using VLOOKUPS and HLOOKUPS.
-
Layout data for pivot table and chart analyses.
-
Create interactive reporting tools that will allow users to navigate data and trends quickly, guiding data-driven decision-making.