Data Management & Business Analytics in Excel

Plan for what is Difficult while it is easy

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)

Location:
Singapore

Venue:
Frasers Tower

Dates:
Ask for dates

Funding:
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.

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.