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
- 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
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 FORAny business professional responsible for managing and working with data
FIELD OF STUDY
- Information Technology