Data Management & Business Analytics in Excel

Plan for what is Difficult while it is easy
Sun Tzu: Chinese general, military strategist, author of The Art of War.

Course Title: Data Management & Business Analytics in Excel

Designed for business analysts who need to manage huge data sets & analyse business information.

Training Course Duration (days)
Frasers Tower
Ask for dates
SkillsFuture subsidies not applicable yet

Course Description

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 the course solves

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.

Course Outline

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.

Who Should Attend This Course

This workshop is designed for professional business 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.

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 CoursesBasic 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.