This Event has Passed
Wednesday, January 09, 2019
10:00 AM - 11:00 AM
10:00 AM - 11:00 AM See all dates and Times
https://www.compliance4all.com/control/w_product/~product_id=502260LIVE?channel=upcomingevents_Jan_2019_SEO
Event Tag
Categories
Conferences & Tradeshows, Education, Festivals, Health & Wellness, Literary & Books
Overview: You will also learn how to create a pivot table from multiple tables and multiple data sources, including linking to external data. Why should you Attend:
Excel has a variety of tools like sorting, filtering, and subtotal to
manage large lists of data, but if you need to analyze all that data and
do it quickly, there's no better feature than a PivotTable. You can
quickly create a compact summary report (based on tons of data)
without needing to write complex formulas or rely on lengthy
techniques.
Areas Covered in the Session:
Manipulating the appearance of a PivotTable via dragging and command
techniques
Using Slicers to accentuate fields currently being shown (and which
ones are not)
Using the new (in Excel 2013) Timeline feature
Creating ad hoc and date-based groupings within a PivotTable
Who Will Benefit:
Excel users who are familiar with PivotTable concepts
Need expanded techniques to analyze lists of data
Create PivotTables from multiple sources
Calculated Fields, and Conditional Formatting
Speaker Profile:
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: US $150.00
Contact Detail:
Compliance4All DBA NetZealous,
Phone: +1-800-447-9407
Email: [email protected]
Excel has a variety of tools like sorting, filtering, and subtotal to
manage large lists of data, but if you need to analyze all that data and
do it quickly, there's no better feature than a PivotTable. You can
quickly create a compact summary report (based on tons of data)
without needing to write complex formulas or rely on lengthy
techniques.
Areas Covered in the Session:
Manipulating the appearance of a PivotTable via dragging and command
techniques
Using Slicers to accentuate fields currently being shown (and which
ones are not)
Using the new (in Excel 2013) Timeline feature
Creating ad hoc and date-based groupings within a PivotTable
Who Will Benefit:
Excel users who are familiar with PivotTable concepts
Need expanded techniques to analyze lists of data
Create PivotTables from multiple sources
Calculated Fields, and Conditional Formatting
Speaker Profile:
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: US $150.00
Contact Detail:
Compliance4All DBA NetZealous,
Phone: +1-800-447-9407
Email: [email protected]