Take the Mystery Out of Excel® Pivot Tables
Wednesday, June 20, 2018 at 1:30 pm ET
Duration: 90 minutes
Speaker: Melissa Esquibel
Register for Live Webinar: $219
Register for Live Webinar Plus Download: $329
Register for Live Webinar Plus CD (includes shipping and handling): $369
Bonus for Each Registrant: The webinar speaker will answer one written question that you may submit by email within one week after the webinar.
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.
Webinar Description
Chances are you've heard of the Excel tool called Pivot Tables. But do you know what Pivot Tables are? You should! If your professional world involves hours of staring at huge spreadsheets, just trying to pick out the one or two things that are valuable to make the right decision, you need to know Pivot Tables. You'll learn how to get your data to give you:
- Key performance indicator charts the easy way
- Up to the minute trends from live data
- Flexible data queries that grow and change with your needs
- Multiple looks at the same information WITHOUT copying and pasting
- Target demographics from sales data in a couple of clicks
You might be getting reports like these already from the office know-it-alls. But, imagine being able to generate them when you need them, rather than when the guru has time!
Agenda:
- Setting up your data for Pivot Table success
- Creating basic Pivot Tables
- What goes where and why
- Filtering and sorting Pivot Table data
- Report options
- Avoiding (and when not to avoid) GetPivot data statements
- Charting and graphing pivoted data
- Working with live data in Excel
BONUS!!
As an incentive to putting your learning to work right away, and as a bonus just for attending this valuable webinar, Melissa will be happy to provide assistance via email for 10 days following the session on anything covered.
Technical Considerations
Melissa will teach this material by performing actions in Excel 2010 during the webinar. However, the content will absolutely apply to Excel 2007 and to Excel 2013. You will need to download an add-in prior to attending the conference. It is recommended that you dial in about 10-15 minutes before the start time of the webinar to ensure you will get the full visual benefit. You will be asked what version of the software you are using in the Question and Answer period, and Melissa will be happy to adjust her answers to suit the version you are using.
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.