Dynamic Reporting and Data Crunching with PivotTables and PivotCharts. Duration: 1 day
What this is about
Excel PivotTables is a powerful way to turn thousands of records into a single business report 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 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 need good theoretical 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 skills not usually known to most people.
How can I apply it in my work
You can use PivotTables with ease and confidence to transform business records into a detailed report within seconds. Start with any data in a worksheet you can produce different views for your business decision needs. You can command vital information WHEN you need it and HOW you want it with minimal pain and angst!
*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.
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.
Refresher classes available
Refresher lessons are available to our students at 50% of program fees.
About the Trainer
Jacqueline Tang is the Principal Consultant at Aeternus. She is an engaging, sought-after public speaker and instructor for Microsoft Office and SharePoint.
Ask us about Microsoft Excel Training Courses in Singapore