MS Excel has the capability to sort and filter large lists of data through various tools-but the best tool that wins hands down when it comes to handling large amounts of data is the PivotTable. With PivotTables you can quickly create a compact summary report based on large amount of data without needing to write complex formulas or rely on lengthy techniques.
The PivotTable feature is Excel's best analytical tool. Not only is it fast, you also get the flexibility and dynamism to quickly change the data interrelationships. This session will make you realize how easy it is to learn using a PivotTable. But pivot tables are not all about simply seeing the instructions on the printed page-it is a visually oriented feature based on displaying fields in different locations.
This webinar with expert speaker Dennis Taylor will teach you some powerful PivotTable techniques to make your work easier and more efficient. You will learn to use Slicers, Timelines, Calculated Fields, and Conditional Formatting. You will learn the quickest and best ways to create PivotTables and become a Superhero in your workplace. Well, we just over-exaggerated the last one!
This webinar will help you:
Who should attend
Excel users who are familiar with PivotTable concepts, but need expanded techniques to analyze lists of data. Anyone needing to know how to create PivotTables from multiple sources, use Slicers, Timelines, Calculated Fields, and Conditional Formatting will benefit from this course.
Dennis Taylor has taught thousands of Excel seminars and classes since the early 90's, is the author/presenter of over 250 Excel webinars, and authored the book Teach Yourself Microsoft Excel 2000. He has taught hundreds of public Excel seminars in the US and Canada since 2006 and has recorded over 100 Excel courses bo... More info