Excel PivotTables Inside Out
PIVOT
noun: the central point on which everything turns or oscillates.
noun: the central point on which everything turns or oscillates.
Course Title: Excel PivotTables Inside Out
Dynamic Reporting and Data Crunching with PivotTables and PivotCharts.
Training Course Duration (days)
01
Location:
Singapore
Singapore
Venue:
Frasers Tower
Frasers Tower
Dates:
Ask for dates
Ask for dates
Funding:
SkillsFuture subsidies not applicable yet
SkillsFuture subsidies not applicable yet
Course Description
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 the course solves
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!
Course 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.
*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 Course
This workshop is designed for analysts who need practical data management & data analysis skills in Excel.
Training Provider
Aeternus Consulting have been consistently rated by our clients for great quality in program design & reference materials.
Course Trainer
Jacqueline Tang is the Principal Consultant at Aeternus. She is an engaging, sought-after public speaker and instructor for Microsoft Office and SharePoint.
I want to say that the lessons were some of the best instruction I have ever had. You have a great teaching manner and mix of structure and flexibility which made learning enjoyable. If I come back to Singapore for any length of time I will definitely sign up for another one of your courses.
Corporate Clients
We have helped teams from various organisations.
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.
Trainers with decades of real-world consulting experience
so you can ask us anything.
About Aeternus Consulting
Best Excel courses in Singapore conducted by expert consultants
Aeternus Consulting is the premier training centre in Singapore for Excel Courses – Basic Excel, Advanced Excel and Excel VBA Macro courses. For more Microsoft Excel training courses, please visit our Excel training page.
Aeternus Consulting is now on Instagram! So take a look and follow us on Instagram.
