everydayExcel Business Lab Logo

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


HOME
TRAINING PROGRAMS
OUR CUSTOMERS
TESTIMONIES
EXCEL BOOK
NEWSLETTER
FAQ
TRAINING ROOMS
VACANCIES
ABOUT US
CONTACT US
MEMBER LOGIN