Pivot Tables: Microsoft Excel's Instant Report Writer Webinar training seminars presented by Online Compliance Panel register now on FindaSeminar.com

findaseminar logo balls FindaSeminar.com
event search registration and marketing services since 2002
Advanced Search
 
 

Pivot Tables: Microsoft Excel's Instant Report Writer Webinar  

 Email information about this seminar Pivot Tables: Microsoft Excel's Instant Report Writer Webinar by Online Compliance Panel to yourself your manager or associates Email this event... View and register for other training seminars like Pivot Tables: Microsoft Excel's Instant Report Writer Webinar by Online Compliance Panel on FindaSeminar.com Find similar training.. Find and register for other training seminars by Online Compliance Panel on FindaSeminar.com Other seminars from Online Compliance Panel

By:

Online Compliance Panel   

For:

Accountants, Analysts

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

Learn the basics of Pivot Tables feature in Excel, pivot table creation, PowerPivot and how pivot tables differ from worksheet formulas. (see full course description)

 

 Seminar / Training class dates & locations

 
 SORT RESULTS BY:

 DATE

LOCATION

SELECTED VENUE DETAILS

Facility Name: 
Address:





Registration Information:

Event cost:  $
USD

class times and cancellation policy

 
 




 From 
 To 
 Click to register by Register by fax for Pivot Tables: Microsoft Excel's Instant Report Writer Webinar training seminar Register by mail for Pivot Tables: Microsoft Excel's Instant Report Writer Webinar training seminar Register by phone to attend Pivot Tables: Microsoft Excel's Instant Report Writer Webinar training seminar

Print payment approval request form Pivot Tables: Microsoft Excel's Instant Report Writer Webinar training seminar

Pre-Registration questions? Find answers in our registration FAQ or Request information about upcoming training seminars workshops and conferences in   and other cities listed on FindaSeminar.com Submit a support request

 
 

 

share this page 

print the agenda print agenda for the Pivot Tables: Microsoft Excel's Instant Report Writer Webinar seminar

 

 

Training Course Syllabus:


In this presentation Excel expert David H. Ringstrom, CPA helps you understand both the nuances and the power of pivot tables in Excel.

Pivot tables are one of Microsoft Excel´s least understood, yet most powerful features. With just a few mouse clicks you can instantly create reports from voluminous lists of data. Instead of trying to manually pore through data by sorting or filtering, you can quickly create a summary format that you rearrange by simply dragging and dropping field names on the screen. Of course there´s a minor catch, you do have to structure your data properly otherwise your report will either be incomplete, or may return the count of the records displayed instead of summing.

Areas Covered

  • Learn the basics of pivot table creation

  • Avoid frustration by understanding the nuances of pivot table formatting

  • Dig deeper into the numbers by using the Report Filter command to create break-out tables

  • Disable the GETPIVOTDATA function if you don´t need it for your analysis

  • Discover the recommended pivot tables feature in Excel 2013 and later

  • Drill down into numbers with a double-click--or prevent users from being able to do so

  • Filter data faster by way of the Slicers feature in Excel 2010 and later

  • Incorporate calculations within, or alongside, pivot tables

  • Learn how to utilize the PowerPivot feature in Excel 2010 and later

  • Mitigate the side effects of converting a table back to a normal range of cells

  • Quickly summarize complex data sets with Excel´s Pivot Chart feature

  • Quickly whip unwieldy data into the format required for pivot table analysis

  • See how pivot tables differ from worksheet formulas and the importance of the Refresh command

  • See how the table feature can vastly improve the integrity of pivot tables in Excel

  • See the nuances of subtotaling data within a pivot table

  • Summarize information from Access databases and other sources

  • Use a simple keyboard shortcut to post the same formula to multiple cells at once


  • Why Should you Attend:
    Anyone who works with lists of data in Excel should be aware of pivot tables. David will also touch on the accompanying Pivot Charts feature, as well as explain new features available only in Excel 2013 and 2016.

    Objectives of the Presentation:

  • Quickly transform lists of raw data into usable reports in just a few simple steps

  • Format and analyze pivot table data with ease

  • Explore the Slicers feature introduced in Excel 2010, as well as recommended Pivot Tables in Excel 2013

  • Quickly summarize complex data sets with Excel´s Pivot Chart feature

  • Incorporate calculations within, or alongside, pivot tables

  • Drill down into numbers with a double-click--or prevent users from being able to do so

  • Seminar Summary:

    Learn the basics of Pivot Tables feature in Excel, pivot table creation, PowerPivot and how pivot tables differ from worksheet formulas. (see full course description)

    print this agenda print agenda for the Pivot Tables: Microsoft Excel's Instant Report Writer Webinar training seminar

     view dates and locations for this seminar

     

     

     

    Custom Search