EXCEL ANALYTICS

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.