Excel PivotTables Inside Out
Dynamic Reporting and Data Crunching with PivotTables and PivotCharts.
What this is about
Excel PivotTables is a powerful way to turn thousands of records into useful business reports for fast business decisions. This 1-day workshop takes the participant on a discovery journey from preparing raw data, to laying out PivotTables and works toward automating PivotTables for interactive reporting.
Excel PivotTables is a powerful way to turn thousands of records into useful business reports for fast business decisions. This 1-day workshop takes the participant on a discovery journey from preparing raw data, to laying out PivotTables and works toward automating PivotTables for interactive reporting.
What problems it solve
Most users learn PivotTables from fellow colleagues. This “hand-me-down” learning approach usually means most people miss out on the broader picture of what Excel PivotTables can do. Excel PivotTables needs good theortical knowledge to be used effectively. This workshop employs real-world examples with a hand-on learning approach to impart PivotTable data analysis and data presentation features not usually known to most people.
Most users learn PivotTables from fellow colleagues. This “hand-me-down” learning approach usually means most people miss out on the broader picture of what Excel PivotTables can do. Excel PivotTables needs good theortical knowledge to be used effectively. This workshop employs real-world examples with a hand-on learning approach to impart PivotTable data analysis and data presentation features not usually known to most people.
How can I apply it in my work
You can use PivotTables with ease and confidence to transform a simple report to a detailed report within seconds. With any data in a worksheet, you can produce different views for your reporting and business needs. You can command vital information when you want it and how you want it with minimal pain and angst!
You can use PivotTables with ease and confidence to transform a simple report to a detailed report within seconds. With any data in a worksheet, you can produce different views for your reporting and business needs. You can command vital information when you want it and how you want it with minimal pain and angst!
Brief Outline
*Pivot Tables from the Ground floor.
*Insider’s PivotTable and PivotChart Tips and Tricks.
*Performing Calculations Beyond SUM and COUNT functions.
*Summarizing Data of all sorts.
*Using Excel files and Access Database with PivotTables.
*Sharing Your PivotTables in SharePoint and Websites.
*Automating & Programming PivotTables.
*Pivot Tables from the Ground floor.
*Insider’s PivotTable and PivotChart Tips and Tricks.
*Performing Calculations Beyond SUM and COUNT functions.
*Summarizing Data of all sorts.
*Using Excel files and Access Database with PivotTables.
*Sharing Your PivotTables in SharePoint and Websites.
*Automating & Programming PivotTables.
Who Should Attend?
For all existing Microsoft Excel practitioners who intend to create powerful business reports with Microsoft Excel PivotTable. No or little knowledge of PivotTable and PivotChart is required.
For all existing Microsoft Excel practitioners who intend to create powerful business reports with Microsoft Excel PivotTable. No or little knowledge of PivotTable and PivotChart is required.
Duration
1 day.
1 day.
Why AEternus Training?
Excel PivotTables is a deep Excel feature. Learn from real practitioners with decades of development & consulting experience. Unlike other centers, we keep our classes small so that there are real discussions about real problems.
Excel PivotTables is a deep Excel feature. Learn from real practitioners with decades of development & consulting experience. Unlike other centers, we keep our classes small so that there are real discussions about real problems.
Trainer Bio
Jacqueline Tang is the Principal Consultant at AEternus. She is an engaging, sought-after public speaker and instructor for Microsoft Office and SharePoint.
Get more on Facebook
Discussion forum, directions to office, good food in Chinatown, new ideas, discounts and offers.
