Excel Saturday Intensive - Excel PivotTables and PivotCharts
Details
http://photos3.meetupstatic.com/photos/event/6/3/5/2/event_22225426.jpeg
PivotTables and PivotCharts (3 hours CPE)
Apr 27th, 2013 8:30 am – 12:00 noon
Golden Gate University Room 2203
Buy Tickets on Eventbrite! (http://www.eventbrite.com/event/4529345394?ref=elink)
PivotTable and PivotChart turn long lists of unreadable data into dynamic, easy-to-read tables and charts that highlight the information you need most; you can tweak results with a click or easily fuse data from several sources into one document.
This class shows you how to create and customize PivotTables and PivotCharts, use them to analyze business data, and ultimately achieve more with less work.
If you use Excel regularly,then this is the class for you.
Presented by: Clinton Monroe, Roger Nakayu, Nigel Geary, and Stephen Tin
_________________________________________________
Session will cover
•Building PivotTables
•Changing the PivotTable view
Show pages as Worksheets
Group Date and Time Value
Group Number values
•Creating Custom PivotTable Calculations
Insert a Custom calculated field/Item
•Creating PivotCharts
Create a PivotCharts from PivotTables
Change the PivotCharts type
•Building more advanced PivotTables
Create a PivotTables from Multiple consolidation ranges
•Excel 2013
•PowerPivot for Excel 2010
_________________________________________________
Attendees will have the opportunity to receive personal assistance and guidance from experienced trainers. This event is hands-on, it is recommended that each participant brings a working laptop. Refreshments will be provided to attendees. Join us for this informative event! __________________________________________________
Schedule
8:30 am -9:00 am Check in & networking
9:00 am -12 noon Training session
*Complimentary light breakfast with bagels, coffee