Designed for business analysts who need to manage huge data sets & analyse business information. Duration: 2 days
What this is about
This is an all-inclusive program to familiarise the participant in Excel’s data management features. It trains the participant to manipulate & analyse business data as a valuable resource.
What problems it solve
Excel is commonly used in massive data management & data analysis, but few people can truly use it effectively. You need to know Excel’s vast array of data management & analysis tools to manage and interpret business information in a coherent & organized manner. For self taught professionals, it is a discipline that is acquired through years of experience, often an arduous trial & error process.
How can I apply it in my work
This program has connected the dots for you. We bring in the relevant Excel features, discuss them in detail with real business examples and show you how they work. These topics are curated from years of business analyst experience.
* Grouping and Outlining Data.
* Database & List Management.
* Data Cleaning.
* Excel’s Data Management Features.
* Excel functions to data mine and classify records.
* Summarising Data Visually with Excel Charts.
* Summarising Data with PivotTables.
* Using Excel’s Modelling Tools for scenario-based forecasting.
* Solve Optimization Problems with Excel Solver.
* Using Excel for Statistical Analysis to Track Trends & Make Forecasts.
Why Aeternus Training
We have been consistently rated by our clients for great quality in program design & reference materials.
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.
Adrian Beirne, , Jetstar Pacific Airlines, Heavy Maintenance Commercial Project Manager
Who should Attend
This workshop is designed for analysts who need practical data management & data analysis skills in Excel.
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.
We worked with the best companies and individuals in Singapore and abroad.
We work with businesses and individuals who need effective Microsoft Office training solutions.
We organise bespoke corporate workshops to improve
employee productivity in using Microsoft Office Tools.
Invited to Economics Dev Board to conduct a 1 day team building workshop “Customised Creating Beautiful Business Infographics with Microsoft Office”.
At GIC Pte Ltd to run a yearly Excel workshop for government scholars.
We conducted the annual 1 day “Introduction to Business Infographics” workshop for Energy Market Authority.
Ask us about Microsoft Excel Training Courses in Singapore