The registration for this conference has ended. You may still order the CD or On-Demand recording using the form below. RegistrationCenter

Webinar Description


Take charge of data and create effective and informative summaries by using Excel PivotTables.

When you need to crunch data sorting, filtering, and inserting subtotals will only allow you to go so far.

What’s needed are ways to quickly create summary totals based on multiple criteria and to have the ability to interchange or add fields, and add to sort results fast! And, to do this without ever needing to deal with complex formulas.
The Microsoft® Excel PivotTable provides these capabilities long with many additional features!

Discover the value of:
Consider this scenario:

You have thousands of detailed rows of data covering a multi-year period—containing names, dates, transactions, customer location, type of transaction, amount of the transaction, etc. Wouldn’t it be great if you could quickly, easily and accurately create a table to show the total transaction amount for each customer without writing formulas and do it fast!
Then, just as quickly, create another table showing your total transactions by week, month or year by simply changing a field’s location.

You can apply these techniques to an endless variety of data; budget, inventory, contacts, human resources, and many more. The possibilities are endless!

This webinar will start from square one showing you how to design a PivotTable to answer data analysis questions. Then, create a professional look for the data by applying styles, adding charts and slicers, and create an interactive dashboard.

This event will be presented with Excel 2010, however the tips and techniques covered will also be applicable to Excel 2007.

Whether you're completely new to PivotTables or have been muddling along on your own, all it takes is 70-minutes for you to gain valuable tips and tricks to quickly create Excel PivotTables and take your spreadsheets to the next level.

Webinar Faculty:


Lisa Ryan has more than 19 years of experience training and supporting users of software applications. She is known for her professional demeanor, thorough command of topics, and ability to tailor training for every audience.

With extensive experience in a variety of software applications including several proprietary software applications, network operating systems, MS Project, Visio, Crystal Reports, SharePoint, SQL, Visual Basic, and other various programming languages. She is proficient in a variety of word processors, spreadsheets, web design applications, business tools, presentation programs, databases and email.

Certifications
  • MOS Master
  • MOS Excel 2010 Expert
  • MOS Word 2010 Expert
  • MOS Excel 2010
  • MOS Outlook 2010
  • MOS PowerPoint 2010
  • MOS Outlook 2007

Webinar Registration



Please use the following form to register for the webinar. You will receive an email confirmation shortly after you complete the registration. Don't forget to add beaconlive.com to your whitelist!

If you are unable to register online, did not receive your confirmation email (don't forget to check your Bulk email folder), or need information on our multi-site discount, please contact our Registration Desk at 866-872-5840 (international callers please dial 617-502-2061). You can also contact us by email Send Email

  Live Event    $189 USD
  Live Event + DVD - Best Value!    $289 USD
  DVD & Handouts    $189 USD
  On Demand    $189 USD
PROMO CODE
NOTE: Your credit card charge will appear as "PayPal * BEACONCOMMU".
First Name* Firm/Organization*
Last Name* Address*
Title* City*
Email* State/Province*
Secondary Email Zip*
Phone* Country*
*Required field

Total charges to credit card:   $ USD