|
|
OUR SOLUTION-BASED EXCEL COURSES
Unlike the gamut of basic, intermediate and advanced Excel courses which
are product training courses in disguise, our training helps managers
and executives overcome practical problems in Data Analysis with Excel.
Managers and executives can expect up to 90% increase in productivity
after attending the courses. Our solution-based excel courses work
through real-life business situations and problems that
business users encounter daily in their jobs.
“I had learned advanced technique on how to extract data in a more efficient
way using Pivot table, knew quite a lot of features and functionality of Pivot
table. In the past, I just use a few commands like vlookup, Mid, left, right
to analyse data. After this course, I had benefited with additional commands
and also learn how to tackle exported raw data from SAP where the date is
in text format. Thanks!”
Yap Seow Kian, Manager - BSIC - BPMO
Defence Science Technology Agency
|
|
HIDDEN SECRETS IN DATA ANALYSIS WITH EXCEL
WHO SHOULD ATTEND: Business managers and executives, CFOs, Financial Analysts
and those who are involved in
the analysis of data.
Hidden Secrets In Data Analysis With Excel is a solution-based Microsoft® course
tailored for managers and executives who are seeking practical
solutions to their Excel problems in raw data management,
business analysis and reporting. It is conducted based on business case
studies with the aim of maximizing your benefits
(e.g. productivity, report accuracy) in
the use of Excel. Its purpose is to equip you with foundational
skills and competence to explore Excel on your own.
More Details on Hidden Secrets In Data Analysis With Excel
|
INTERACTIVE EXCEL DASHBAORD REPORTING
WHO SHOULD ATTEND:Managers and executives who are required to prepare reports for management.
Interactive Excel Dashboard Reporting is customised for managers and execuives
who are tasked to prepare management reports such as
Key Performance Indicator (KPI in short) reports, Business Performance Report,
Daily Snapshots, etc. The objective of the course is to train participants how
to create interactive and maintenace-free report for management using advanced Excel
formulas and functions (Excel Macro not included)
and channel
the time saved to investigate the exceptional trends found in the report.
More Details on Interactive Excel Dashboard Reporting
|
DYNAMIC REAL-TIME FORECASTING WITH EXCEL
WHO SHOULD ATTEND:This course is specially tailored for Sales Directors, Chief Financial
Officers, finance managers, sales managers and executives in sales planning,
business planning, corporate planning, accountants, financial analysts who
are involved in sales forecasting.
The participants are expected to know VLOOKUP, IF formula, absolute and
relative referencing, and pivot table. Participants are highly encouraged
to attend our foundation course "Hidden Secrets to Excel Data Analysis"
first before attending this course.
More Details on Dynamic Real-Time Forecasting with Excel
|
LEARNING THE MAGIC OF MACROS
WHO SHOULD ATTEND:This course is specially tailored for business managers and
executives who have an extensive knowledge of Excel and need to
simplify complex calculation using customised worksheet functions
and/or automate manual tasks..
Learning the magic of Macros makes use of real case examples
to demonstrate how macros can be used to create customised worksheet functions
that are not available in Excel. Through the process, participants also
get to learn how to create macros that will help them automate tasks and
make them more efficient. The course is targeted at business users who have
minimal or zero knowledge of macros. It is not intended to make the
participants programmers but to help them tap into power of macros for
their routine Excel task.
More Details on VBA - Learning the Magic of Macros
|
|
|
