|
|
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. The first part of the course is based on a fixed
curriculum and its purpose is to equip you with foundational
skills and competence to explore Excel on your own. The second part of
the course is customised to your needs by working through
your real, existing problems encountered in your work, and providing
solutions to you. The level of customization is dependent on the needs, skill level,
expectation and requests of the class.
More Details on Hidden Secrets In Data Analysis With Excel
Share
|
CUSTOMER ANALYSIS WITH EXCEL (New!)
WHO SHOULD ATTEND: Business managers and executives working
in restaurants, clubs, manufacturers offering product warranty,
department stores, retailers offering loyalty/discount cards,
insurance agents, property agents, and others who need to analyze
or profile their customers.
Customer Analysis with Excel
is a solution-based Excel training course that focuses on the use of Excel
functions and formulas to manage your mailing list, segment your customer base,
keeping in touch with your customers, analysing your customers spending patterns, etc.
Participants will also learn
how to remove duplicated mailing address from their mailing list even when the
street names are spelt differently.
More Details on Customer Analysis With Excel
Share
|
SALES PERFORMANCE ANALYTICS WITH EXCEL
WHO SHOULD ATTEND: For Managers, Marketers, Sales Professionals, Market Support Team, Executives and
anyone who is involved in managing and analysing marketing and promotional data.
Sales Performance Analytics with Excel is a scenario-based learning course
involving in-depth application of Excel functions and formulas. In part I of our
course, participants are systematically trained on the entire process of sales performance
analytics, from turning raw data into useful business information to reporting. In
part II of our course, we customize the course based on the needs, skill level,
expectation and requests of the participants.
More Details on Sales Performance Analytics with Excel
Share
|
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
Share
|
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
Share
|
|
|