Hidden Secrets in Data Analysis with Excel 2007/2010

Stop copy and pasting data from one worksheet to another, just to update your reports week after week, month after month and find out how much time you have been wasted out all these years!

Here’s how you can quickly and easily master the commonly used functions and formulas in Microsoft® Excel guaranteed to generate your analysis and reports without working overtime to crunch those numbers manually throughout the spreadsheets!
Jason Khoo
Tuesday, 10:37 A.M.

How much is an Excel course worth to you?

Suppose you are spending 12 hours a week (30% of the time) on Excel. You can cut down conservatively 50% of this time spent or 6 hours per week. Based on a monthly income of about $2000, you are going to save $2,182 per annum.

No More Overtime

When I worked as a business analyst, I was told that my predecessor worked until 8 – 9 pm every night. But when I was on the job, I  knocked off at 6.00 pm sharp almost everyday after 3 months into the job. And I was not taking care of a small sales unit, they were the 2 largest sales units that generated about 50% of the company’s sales. The 2 units turnover was about $50m.

 Extra capacity at your disposal

When one of the business analysts working for another business group resigned, I was told to take over the group temporarily. With the added responsibility, I was still able to go home at 6.00 pm. And nobody in the company asked me how I did it because they were just too busy to hear anyone out. I know some of you must be thinking that I started the day early or I brought the work back home to do. The truth is I started work the same time as everybody else and I seldom brought work home to do. And in terms of work quality, it is the same or even better. Because my business group managers are always full of praises for me. Other business group managers know about the good quality work I produced because my business group managers told them. They even showed what I produced to these group managers.

I make Excel work for me

The secret to my efficiency is MS Excel. I know how to make Excel work for me. It was achieved through years of experience solving different problems in Excel for the different departments such as Finance, HR, Sales, Marketing, Operations, Customer Services, etc. I read through all the Excel books that I could laid my hands on. Imagine reading a thick Excel book containing hundred of pages. As I worked on these problems, I began to discover the problems are similar in nature. And some times, it is not caused by Excel but by the way we visualize and handle the data in the spreadsheet. I created the first course (now know as Hidden Secrets in Data Analysis with Excel) and taught it to a group of my customers. Needless to say, they seemed to be bestowed with a power previously unknown to them. They worked faster with Excel and were soon enjoying what they could do with it.

I enjoyed the lesson and how my clients beamed with joy and called me to thank me for what I have done for them. The course was not cheap compared to what other Excel courses charged in the market. But it was worth every dollar they paid. They even told me I should increase my price. I charged too cheap for the knowledge that I have imparted to them. I decided to train others and it was satisfying to know that they could work faster than before and have more time for their families.

A course that has been tested and proven to benefit you


This course used to be a classroom based course. It was so well received that our participants will refer others to the courses. When somebody from an organisation attended our course, there is a high chance that more staff from the same company will attend the subsequent runs.

In appreciation of their support for my course, I have set up this website and re-produced the lessons into videos for them so that they can go through some of the case studies if they needed a refresher. In each training, I will try my best to provide solutions to problems and answers to questions raised by the participants.

Now the course is on video


I thought it would be good to let you, who are living overseas, benefit from the course too. You will have access to the same stuff taught in class. By signing up for the course, you are automatically included in our community where you can ask questions and have them answered by me or one of the members. If you need more practice, you can also help answer some of the questions posed by other members.

A course that solves multitudes of problems
“Highlight filtered row all at one go”
Before this course, I would manually edit spreadsheet. Now, I learnt to use Auto-Filter to help me filter data and do formatting using “Visible Cells Only”.
Shirley from Tayonn Pte Ltd
“Store and analyse data using Pivot Table”
I used to use different tabs to segregate data for different customers. I realised that just by keying in the same worksheet, I can manipulate (organised) the data using pivot table.
“Comprehensive tool not only for big companies but also smaller organisation”
Extremely useful for start-up/organisation that doesn’t run on SAP/MRP etc. Excel can be a comprehensive tool to evaluate/analyse data with basic data entry. Achieved 30% savings.
Cindy from Taytonn Pte Ltd
“Generate Report Directly from the company database servers”
The Excel Pivot Table combined with MS Query are fantastic tools! I managed to use them to extract the required data from Accpac and submit it to my Organisation’s HQ in Germany. I actually recommend your course to one of my business associates who claims to work a lot with Excel and databases. When I showed him how quickly I could sort out databases for e.g. with VLookup of the Industry Class, he was SOLD! Thanks to your Excel course plus your guidance!
Bilal, MD of Igus Singapore Pte Ltd
“Manager data on your own without using expensive and complex system”
I learnt many shortcuts and functions that I didn’t know of. This course is most beneficial to people who handle huge data and want to manage it well. 
“Cost and time savings, increase in efficiency”
Companies should have a customized excel course conducted by this trainer that matches their needs – will certainly result in time/cost savings and efficiency.
Maggie from Sumitomo Corporation (S) Pte Ltd


How This Online Course Could Save you Time and Money


  1. Learn how to merge two Excel lists into one
  2. Highlight and format filtered records
  3. Split comments into multiple cells
  4. Churn out data/information within shorter period of time using pivot table
  5. Discover useful shortcuts
  6. Retrieve data from company systems 

With this one time subscription, you get UNLIMITED access to the tutorials.

Okay, So What Is The Cost For This Incredible Resource?

Considering that you are most probably going to save thousands of dollars per annum from the course, I could have easily sell you a regular subscription plan with regular updates and new exercises. But I am not going to charge you anywhere near that amount or even the price my classroom’s participants are paying right now. In fact, your total investment for this PREMIUM Excel course is only US$47. The money you are going to save as a result of this online video course is easily going to be ten times more than your meager investment. 

So what’s the catch? Why am I practically giving the course away?

Well, it’s really quite simple. Since you’re accessing these directly from the Internet, I do not have to incur rental cost for the room and computers, and no fulfillment costs. I don’t need to pay anyone to take the orders over the phone (though, you are welcome to call me at (65) 6226 1619 to rest assured that I am a real person. This way I can pass along my cost savings to you. So you win and I win.

100% Risk-Free Guarantee

Your success in using this Online Excel Course is completely guaranteed. In fact, here’s my 100% Better-Than-Risk-Free-Take-it-To-The-Bank Guarantee:

I personally guarantee that if after a full 56 days (8 weeks), you honestly believe I haven’t delivered on this promise, then let me know and I’ll issue you a prompt and courteous refund.

Is that fair or what?

That means you can try out all the tutorials at my risk, while you see if they work for you or not. And if they don’t produce the results, I honestly want you to ask for your money back. 

Zero Risk

There is absolutely no risk, whatsoever on your part. The burden to deliver is entirely on me. If you don’t save any time after watching the videos for “Hidden Secrets in Data Analysis with Excel 2007/2010″, then I’m the loser, not you.

Look at it this way — $47 is really a painless drop in the bucket compared to the money you’re going to waste on ineffective course that only show you that those functions exist. That’s why…

You Really Can’t Afford Not To Invest In This Hidden Secrets To Excel Data Anaysis eCourse!

It’s easy to get started right away.

Just click the button below

Jason Khoo
Chief Trainer
everydayExcel Business Lab

P.S. Just think! You’ll never again suffer the pain of staying up late to manually analyze and prepare those sales reports.

P.P.S. You will be able to spend more time with your family and at the same time, impress your boss using your new found skills!

If you are looking for physical Excel Training workshop in Singapore, take a look at our Microsoft® Excel courses for Business Professionals.