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.

“The lesson and pointers provided can be applied in actual situations at work. This helps to save time and enables us to work smart and more efficiently. E.g Formulas/functions that were not obvious to me previously now make a lot of sense, and I can easily sift out unrequired information (using pivot table) to make my tables look more cleaned up and presentable.”
Adeline Yap
Citibank Singapore

HIGH IMPACT DATA ANALYTICS REPORTING IN EXCEL 2016 (DARE 2016)

High Impact Data Analytics Reporting In Excel 2016WHO SHOULD ATTEND: Business managers and executives, CFOs, Financial Analysts and those who are involved in the analysis of data.

High Impact Data Analytics Reporting in Excel 2018 (aka DARE 2016) is a new excel course tailored for managers and executives who are crunching data using Microsoft Excel 2016. Excel 2016 has added in new features which are capable of shortening the entire process of data cleaning, analysis and reporting. The time savings comes from the tools capability to track the steps of cleaning and updating the reports as the raw data file changes.

More Details on High Impact Data Analytics Reporting in Excel 2016 (DARE 2016)

 

HIDDEN SECRETS OF DATA ANALYSIS IN EXCEL

(Also known as Business Analysis with Excel)

Data Analytics reporting in Excel 2016WHO SHOULD ATTEND: Analysts and Managers in Business Planning, Budgeting, Data, Logistics, Finance, Accounting and whoever deals with data

Hidden Secrets In Data Analysis With Excel is a solution-based Microsoft® Excel 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 Of Data Analysis With Excel

 

THE HIDDEN KEY TO EXCEL REPORTING AND CHARTING

(Formerly known as Interactive Dashboard Reporting with Excel)

The Hidden Key to Excel Reporting and ChartingWHO SHOULD ATTEND: Managers and executives who are required to prepare reports for management.

The Hidden Key to Excel Reporting and Charting is customised for managers and executives 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 The Hidden Key to Excel Reporting and Charting

 

UNLEASH THE POWER OF POWERPIVOT FOR REPORTING

Unleash the Power of Powerpivot 2010 for Data InsightsWHO SHOULD ATTEND: Managers and executives who are required to prepare reports for management.

In this Excel course, you will be using Power Pivot and Pivot table as the primary functions to create a dashboard. Power Pivot is a new function in Excel that works hand in hand with the all too familiar Pivot Table. Power Pivot can analyse multi-million rows of data seamlessly, combine multiple sources of data into one. It also comes with the new Slicer features as well as DAX formulas that make insightful, professional looking Dashboard Reports creation a breeze.

More Details on Unleash The Power of PowerPivot For Data Insights

 

BREAKTHROUGH PERFORMANCE FOR HR IN EXCEL

Breakthrough Performance for HR in Excel 2007 and 2010WHO SHOULD ATTEND: This course is specially tailored for Human Resource Managers and Executives who are involved in HR Operations.

This solution-based Microsoft© Excel course is tailored for human resources personnel who are seeking increase in productivity and improving their HR operation processes such as the tracking of work permits and passports renewal for foreign workers, tracking of training budgets, analysis of staff cost, short listing of job applicants, etc.

More Details on Breakthrough Performance For HR in Excel

 

DYNAMIC REAL-TIME SALES FORECASTING WITH EXCEL

Dynamic Real-Time Forecasting with Excel 2007 and 2010WHO 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

Learning the Magic of Macros with Excel 2007 and 2010WHO 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 Unlike most Excel macros courses which are designed for programmers, this course is specially designed for advanced Excel users who do not have any background in programming. Two groups of Excel users are likely to benefit from this course:

- Those who are keen to explore macros to automate and speed up tedious and repetitive Excel tasks,
- Those who like to modify existing macros built by someone else and customize them for their own use.

Using case examples to constantly engage the participants on the technical topic of programming, this course aims to help users create macros that are able to significantly reduce the amount of time spent on a time-consuming Excel job and make complicated Excel jobs simple enough for those without advanced Excel skills to handle.

More Details on VBA - Learning the Magic of Macros