everydayExcel Business Lab Logo

HOME
TRAINING PROGRAMS
EXCEL BOOK
TESTIMONIES
ARTICLES
FAQ
TRAINING ROOMS
VACANCIES
CONTACT US
MEMBER LOGIN

SCENARIO-BASED LEARNING EXCEL COURSES

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

REVOLUTIONARY APPROACH TO EXCEL BUDGETING

WHO SHOULD ATTEND:This course is specially tailored for budget managers who are currently using or intend to use excel as the primary budgeting and forecasting tool.

Revolutionary Approach to Excel Budgeting makes use of available worksheet functions and formulas to manage the entire process of budgeting from data collection to preparation of reports. It avoids the pitfalls of Spreadsheet Hell and is able to shorten the budgeting process by at least 50% over the conventional method of excel budgeting

More Details on Revolutionary Approach to Excel Budgeting

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