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.


DESIGNED FOR
Any business professional responsible for managing and working with data

FIELD OF STUDY
Information Technology

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

COURSE PRODUCER
Business Learning Institute

CPE CREDITS
4.0

LEVEL
Intermediate

This course is available for your group as:

Group Live
 

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: 888-481-3500 or learn@blionline.org