OUR SOLUTION-BASED EXCEL COURSES

Our Solution-based Excel courses are specially designed to share with you worksheet formulas and functions which you may and may not know and show you how they can be effectively applied to your daily work. We do not classify them by basic, intermediate and advanced level but by the business uses of Excel. If you are looking for basic, intermediate and advanced Excel courses and would like us to make some recommendations, drop us an email at recommend@everydayexcel.com

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.

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.

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.

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