Maximizing Your Use of Excel PivotTables

This Event has Passed

Thursday, May 02, 2013

1:00 PM - 2:00 PM

http://www.audiosolutionz.com/849-conference-maximizing-your-use-of-excel-pivottables.php

Add to Calendar

05/02/2013 01:00 PM 05/02/2013 02:00 PM America/Anguilla Maximizing Your Use of Excel PivotTables Deriving maximum value from Excels PivotTables Microsoft Excel offers a variety of tools and techniques to sort and filter data. But among them, PivotTable is the best enabled feature allowing you to analyze data. There is no need to create complex excel formulas as you can easily view compact summary report generated through PivotTable.Join Dennis Taylor, for a sizzling 60 minutes afternoon session Maximizing Your Use of Excel PivotTables on May 02, 2013 at 1:00 pm EDT to understand and grasp PivotTable dynamics. He will walk you through on ways to rapidly change displays, data interrelationships and analyze loads of data.Learn: How to compare two or more fields in a variety of layout styles... Details & Tickets: https://www.upcomingevents.com/philadelphia/events/online/maximizing-your-use-of-excel-pivottables-14695?ref=uceaddevent Online, 2222 Sedwick Drive, Durham, NC 27713, Durham, NC, 27713

Event Tag

Neighborhoods

Auburn Hills (Durham)
Audubon Park (Durham)
Lake Park (Durham)
Parkwood (Durham)

Deriving maximum value from Excels PivotTables Microsoft Excel offers a variety of tools and techniques to sort and filter data. But among them, PivotTable is the best enabled feature allowing you to analyze data. There is no need to create complex excel formulas as you can easily view compact summary report generated through PivotTable.

Join Dennis Taylor, for a sizzling 60 minutes afternoon session Maximizing Your Use of Excel PivotTables on May 02, 2013 at 1:00 pm EDT to understand and grasp PivotTable dynamics. He will walk you through on ways to rapidly change displays, data interrelationships and analyze loads of data.

Learn:

How to compare two or more fields in a variety of layout styles
How to sort and filter results
How to perform ad-hoc grouping of information
How to use Slicers instead of filters to identify which field elements are being displayed
How to drill down to see the details behind the summary
How to categorize date/time data in multiple levels
How to create a Pivot Chart that is in sync with a PivotTable
How to add calculated fields to perform additional analysis
How to hide/reveal detail/summary information with a simple click
How to deal with dynamic source data and the "refreshâ€? concept

View Less

Select Region

Or

Search by Zip