Religion in the Workplace Tuesday July 24, 2018

Take the Mystery Out of Excel Pivot Tables

Wednesday October 24, 2018
1:30 pm - 3:00 pm ET
90 minutes

Register for Live Webinar: $219

Register for Live Webinar Plus Recording Download: $329

Register for Live Webinar Plus CD (includes shipping and handling): $369

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

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.

Faculty

Melissa Esquibel specializes in transforming those confused by technology into empowered users of these powerful software tools. As a Microsoft Certified Trainer (MCT) with more than 25 years in business application technology, She has a unique ability to make learning programs enjoyable AND valuable.

Whether teaching how to crunch numbers with Excel, deliver compelling presentations in PowerPoint or generate business-winning proposals and reports with Word, Melissa keeps it relevant, accessible and fun. Melissa's consulting career spans banking, manufacturing, telecommunications, energy and insurance, which allows her to provide real-world examples and applications. She has enabled everyone from rocket scientists to real estate brokers to put the "productive" back in office productivity software

Melissa Esquibel 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.

Webinar Overview

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.