Hidden Secrets of Data Analysis in Excel (In-Person)

Achieve breakthrough performance in Data Management like never before.


This course is also know as Business Analysis with Excel.

In-House sessions are available upon request.


Course Overview:

Hidden Secrets of 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.


Learning Objectives:

Upon completion of the course, participants will be able to:

  • Apply useful built-in functions in Excel to process data and enhance the usefulness of the data.
  • Apply the function learnt to consolidate records.
  • Acquire skills to analyse the records for operations and reporting purposes.
  • Employ new ways of tabulating and managing data.


Who Should Attend:

Managers and Executives who have to manage, analyse and prepare reports using data downloaded from systems. They must have some basic to intermediate knowledge of Excel i.e. navigate around a worksheet, format cells, auto-filter, sorting, create a simple template and enter simple formulas (e.g. SUM) into the worksheet.



“I have always been clueless about the power of Excel, doing many things the manual way like counting amount in cells and doing manual layouts. To me, Excel has always been just another program i layout my reports with. But after attending this Excel course, i realise that there is so much more power stored in Excel to help enhance and make efficient daily work reports that i have to do especially with ensuring accurate details in figures in big amounts. Im sure as i continue to explore what has been taught, i will be able to save a lot more time and stop pulling my hair out while i face my reports again.”

– Rachel Low, Trade Marketing Executive, Johnson and Johnson Vision Care SG


“The lessons 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


“Learnt many new formulas which are able to help me re-define those conventional and complicated ones that im currently using.”

– Tang Ee Koon Catherine, Defence Science & Technology Agency

Course Curriculum

Section 1: Manage The Use of Dates: MONTH, YEAR, DAY, DATE, COUNTIF, SUBTOTAL, DATEDIF formula, Advanced Auto-Filter Function, Absolute and relative reference
Section 2: Quick and Accurate Way to Select Records: GOTO function
Section 3: Building Complex formulas: MID, SEARCH
Section 4: Merging 2 Lists into One: VLOOKUP formula, SUBTOTAL, REPLACE ALL function
Section 5: Unleashing The Power of Formulas: SUMIF Formula, TEXT TO COLUMN Function
Section 6: Analyzing Business Data in Double Quick Time: PIVOT TABLE function
Section 7: Making Your Report Update Automatically: MS Query Function
Section 8: Consolidate Data From Multiple Workbooks: MS Query Function
Section 9: Tapping the Power of Pivot Chart
Section 10: Recording Macros to Speed Up Repetitive Tasks
Hidden Secrets of Data Analysis in Excel (2-Day) 14:00:00

Course Reviews


  • 5 stars0
  • 4 stars0
  • 3 stars0
  • 2 stars0
  • 1 stars0

No Reviews found for this course.

  • SGD 600
  • 2 days
  • 1 Units
  • 840 Minutes
  • Wishlist

Enrol With Confidence

PayPal Acceptance Mark

Registration Support

If you require further assistance on registration matters, email to

In-House Enquiry

Achieve higher ROI with your training budget with In-House trainings, email to
everydayExcel Business Lab is a training company offering Professional Microsoft® Excel Courses with a Business Perspective. We tailor-made Excel courses for busy Executives and Managers who do not have the time to explore the various uses of formulas and functions to solve real business problems in sales and marketing, human resource, administration, business development, etc. Our excel course trainers are not just Masters of Excel who teach people how to use Excel. They are business analysts who can naturally appreciate the decisions made in businesses and the common business problems encountered and at the same time able to make expert use of what is available in Excel to solve analytic and reporting issues in business. Bottom-line for our client is always about how we can use Excel in a way to save a great deal of time and resources for the business. At EverydayExcel, we don't teach people how to use Excel as an end in itself. We teach people how to use it as a means to an end; that to apply the skills and techniques in solving solve their various business problems. For us, there is a huge difference in the two. We do not set out to train people to become gurus in using Excel who are unable to apply it to real-life business situations. We engage with our training participants in such a way that they are triggered to relate what they learn in Excel to their business problems that they face, and then go step by step to tell them how to approach them by creating powerful solutions in Excel. About Your Chief Trainer: Jason Khoo is the author of the two books "Excel Secrets for Highly Effective Marketers", "Hidden Secrets of Data Analysis with Excel" which are sold in all the major book stores in Singapore and in online Amazon. An expert in spreadsheets and databases, Jason also founded SynergyWorks, a consultancy firm which has helped many companies extract valuable information from databases using Microsoft® Excel. He has helped companies save significant amount of money by providing solutions using existing PC applications such as MS Excel instead of purchasing new systems. His clients include multi-nationals corporations such as Discovery Asia, 3M, NCS, Cold Storage, Nippon Paint Singapore, Heinz Asean, Tanah Merah Country Club, and etc.
More Courses by everydayExcel Business Lab

Students Who Viewed This Course Also Viewed