Course ID: EDMPTC

Excel Data Management: Tables and Pivot Tables Challenge

Learn pivot tables using real data. In this course, we will work through resolving 10 questions around a live data set – each question getting progressively more advanced. This is an interactive workshop where we debate the data challenge / question before we solve it – just like in the real world!


Learning Objectives
  • Review proper structuring of data for pivot table analysis
  • Recognize how pivot tables can make analysis faster and easier
  • Understand modifying data fields to make analysis simple

Major Topics

We will work through a real dataset – US bank closings over a period of years. We are challenged to answer 10 questions which are designed to be answered using pivot tables. All attendees receive a completed workbook with the solutions and a solution set in PDF that explains each question.


Who Should Attend

Any business professional responsible for managing and working with data


Fields of Study
Information Technology

Prerequisites

Comfortable working with and navigating Excel. Skills in topics mentioned are not required.


Provider
Business Learning Institute

CPE Credits
4.0

Level
Intermediate

This course is available for your group as:

 

Let's Roll!

To learn more or customize this course for your group, complete this form and a BLI team member will get back with you shortly.


Or, contact BLI: or team@blionline.org
Your browser is out-of-date!

Update your browser to view this website correctly.

Update my browser now

×