Demystifying Excel Pivot Tables
This event qualifies for 1 SHRM-CP
Overview:
Pivot tables are one of the most powerful features of Microsoft Excel. They can provide quick answers from hundreds of thousands (even millions) of rows of data. With a few clicks you can aggregate, summarize and calculate large amounts of data to support you most critical business decisions. In fact, it's hard to call yourself proficient at Microsoft Excel without being able to comfortably create and modify pivot tables.
Why should you attend?
If you work with lists of transactions, customers, activity, assets, statistics, there are answers your data is just dying to tell you. Unearth this information with powerful pivot tables. Turn hours of sorting, filtering, copying, and pasting into a 2 or 3 click reporting solutions. You'll learn how to use Excel and non-Excel data sources to create actionable reports.
Areas Covered in the Session:
- What is a pivot table, anyway?
- Getting your data in the right shape
- Creating pivot tables step-by-step
- Creating charts from your pivot tables
- Implementing interactivity to allow for more precise dicing and slicing
- Working with the data model
Who can Benefit:
- Data Analyst
- Marketing Analyst
- Sales Analyst
- Managers
- Supervisors
- Financial Analysts
- Administrative Assistants
- Executive Assistants
Speaker and Presenter Information
Mellisa is a Keynote Speaker at Ijona Skills. With over 30 years in business application technology, Melissa's goal is to help you make friends with your technology. Technology is introduced, deployed, employed and decommissioned faster than you can say, "click here.
Event Type
Webcast
This event has no exhibitor/sponsor opportunities
When
Tue, May 5, 2020, 1:00pm - 2:00pm
ET
Website
Click here to visit event website
Organizer
Ijona Skills