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!
Course ID: EDMPTC
Excel Data Management: Tables and Pivot Tables Challenge
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 TechnologyPrerequisites
Comfortable working with and navigating Excel. Skills in topics mentioned are not required.