Excel PivotTables Inside Out


noun: the central point on which everything turns or oscillates.

Excel PivotTables Inside Out

Dynamic Reporting and Data Crunching with PivotTables and PivotCharts.
excel courses in singapore
Training Course Duration (days)
Frasers Tower
Ask for dates

What is it

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!

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.

Who should Attend

This workshop is designed for analysts who need practical data management & data analysis skills in Excel.

Why Aeternus Training

We have been consistently rated by our clients for great quality in program design & reference materials.

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.

Past Participants

We worked with the best companies and individuals in Singapore and abroad.
Created an automated service level dashboard for Terminal 2
Trained genius scholars on Excel
excel course client
microsoft excel training course client

We work with businesses and individuals

who need effective Microsoft Office training solutions.​

We organise bespoke corporate workshops​​

to improve employee productivity using Microsoft Office Tools.
Invited to Economics Dev Board to conduct a team building workshop.
At GIC Pte Ltd to run a yearly Excel workshop for government scholars.
We ran an annual 1 day business infographics workshop for EMA.

Comfortable learning environment

No stuffy windowless classrooms for you and us. No, no, no.
Curious? Play the video to find out.