Take the Mystery Out of Excel Pivot Tables
Duration: 90 minutes
Speaker: Melissa Esquibel
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 2007and, to some degree, to Excel 2003. 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-minute webinar (Travel-Free) delivered over the phone and Internet.
- Unlimited listeners per connection - bring the entire department.
- Q&A session with the expert.
This event will be presented live by phone together with a PowerPoint presentation to be viewed on your computer. Internet access is not required for phone-only participants. 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.
What is a webinar?
A webinar is a live Internet based seminar. Webinars are a way for participants in many different locations to see and hear a presentation and view PowerPoint slides. You can also have your colleagues attend the webinar using one connection.
What kind of equipment do I need?
You will need a computer with an Internet connection (high speed service such as DSL or cable works best) and a telephone.You may listen to the webinar through your computer speakers, in which case you will not need to use a telephone connection. Internet access is not required for phone-only participants, but you will not be able to see the speaker’s slides.
How can I share the webinar with my colleagues who may not be able to attend the event?
CDs of each program will be available for sale and can be shared with your business associates.
Can I get a copy of the PowerPoint slides used in the webinar?
The PowerPoint slides will be available on the materials page link in the confirmation email that will be sent to you no later than the morning of the day a webinar is presented.
How do I ask a question during the webinar? Will my question be answered during the presentation?
A question and answer session will be scheduled at the end of each webinar. You can then ask a question by typing it into the question box that will be provided to you duringthe webinar. You may also ask a question through the telephone connection. As many questions as possible will be answered during the Question and Answer period.