In this session You'll learn how to create Slicers which are the new visual
way to filter a pivot table, You'll also learn how to create a pivot table from
multiple tables and multiple data sources, including linking to external data.
Why should you Attend:
You'll be amazed to see how, in very little time, you can create a complete
summary report with tons of data and you won't even need to write
formulas and rely on obscure techniques.
Areas Covered in the Session:
Using Slicers to accentuate fields currently being shown (and which ones
Creating ad hoc and date-based groupings within a PivotTable
Quickly create and manipulate a Pivot Chart to accompany a PivotTable
Who Will Benefit:
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 worked extensively with Microsoft Excel since the mid-
1990s. He's traveled the United States and Canada presenting seminars and
classes to help attendees unlock the full potential of Excel.
Event Fee: One Dial-in One Attendee Price: $190.00
Compliance4All DBA NetZealous,