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

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Â® 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.

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

(Formerly known as Gaining Stunning Business Insights with Excel Powerpivot 2010)

WHO 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 2010 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.

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

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.

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