Pivot Tables: Beyond the Basics
Thursday, February 22, 2018 at 1:30 pm ET
Duration: 90 minutes
Speaker: Melissa Esquibel
Register for Live Webinar: $219
Register for Live Webinar Plus Recording Download: $319
Register for Live Webinar Plus CD (includes shipping and handling): $349
Special Feature: If you register for this webinar and cannot attend, you will be able to access a one-time instant replay without charge for up to 90 days after the date of the webinar.
Bonus for Each Registrant: The webinar speaker will answer one written question that you may submit by email within one week after the webinar.
Webinar Description
You’ve dipped a toe in pivot tables, but you know there’s more there that can help you aggregate and visualize your data. This 90 minute webinar will introduce you to the additional capabilities of pivot tables and the newest tools available in the latest versions of Excel to bring external and multiple related datasets together.
Agenda:
- Calculated fields
- Using external data sources
- Applying Slicers and Sparklines
- Options for pivoting multiple datasets (appended and related)
- Troubleshooting pivot tables common problems
Experience Level
Some experience with pivot tables is required to get the most out of this course. While this presentation will be shown from Excel 2016, the information will be applicable to Excel versions 2007 and beyond (PC desktop versions). Some information will be applicable in Mac Excel.
Logistics
- 90-minutes (Travel-Free) delivered over the Internet.
- Unlimited listeners per connection - bring the entire department.
- Q&A session with the expert.
This event will be presented live with a PowerPoint presentation to be viewed on your computer. You may listen to the audio of the webinar by telephone or through your computer. The PowerPoint slides will be provided shortly before the event. Once you register, you will receive an email which is your receipt and which includes your instructions for dialing in and logging on. You will also receive an email reminder 24 hours before the webinar.