|
De-duplication of customer names are now made so much easier. We used to highlight
them in different colors and manually identifying them and removing it. It took days.
After going thru the case studies, it just took seconds to have it done. Pivot
Table and Charting is a dynamic way of summarizing data into useful charts and
make things very visible for marketers, especially when they don't think
in grids.
Amie Choy, Strategic Marketing Manager,
Robert Bosch Security Technology, Asia Pacific Region
|
Stop attending Excel courses that ONLY show you what is available in Excel!
Here's How
You Can Effectively Analyze
Your Data And Present Reports
With Microsoft® Excel
WITHOUT Spending Hours
Processing The Data!
Looking for ways to convert, consolidate, analyze
and summarize your data?
Just click a few buttons and presto...
You have just completed your report in a matter of minutes!
Dear Business Excel User,
Are you sick and tired of spending hours and hours attending Excel courses that only
show you the formulas and functions that are available in MS Excel?
Suppose you have just attended an Excel course and your boss gave you an Excel
spreadsheet containing 10,000 records of sales data. He wants you to identify the
top 10 selling products and the customers buying them. He believes that you are the
right candidate for the job since you have just completed an Excel course and
was awarded a certificate for passing the test. Can you tell him that after
spending hundreds of dollars on the course and a few days from work that you
are still not able to complete the task on hand?
I thought I have mastered Microsoft Excel...
When I learnt all the formulas and functions available in Excel, I thought
I have mastered Microsoft Excel. I was shocked when I realised that my Excel
knowledge did not help me solve the problems I was facing at work. I browsed
through book after book, putting bits and pieces of tips from each book together
to get my solution. Some times, the solution came too late. I have already completed
the task given to me, using the inefficient approach due to the project deadline.
One of the most memorable cases I had was on splitting the data in a text file
into columns using data downloaded from a system. The size of each character
was of different width with "W" being widest in the 26 alphabets. As a result,
the characters meant for one data column spilt over to the next column. When I
seek help from my friends and colleagues, the answer is always the same - I have
to manually copy and paste the text for each column into the respective columns,
row by row. Can you imagine how frustrated I felt?
That missing link...
Not wanting to accept the answer as final, I went through
every Excel books I could get my hands on. Numerous hours were
spent on this mission. Thanks to my persistency, I finally found
the solution! That one simple tip that was relatively unknown to
many Excel users was the culprit for the numerous hours I spent
on the books. That missing link helps to split the text up neatly
into each column in less than 5 seconds!
That was years ago. Now, I can confidently solve most of the problems
faced by Excel users across all business functions. My colleagues were
impressed with my Excel skills and wanted me to recommend them good Excel
courses that could help them work as efficiency as me. When I started my
Excel consultancy business, my clients made the same request. Not wanting
to divert my attention from my Excel consultancy business, I started to
evaluate the Excel courses I cam across. But I found that most of them
did the same thing, just showing what Excel has. None of them demonstrated
what Excel could do for business users.
I figured out that I might be better off...
After months of searching, I figured out that I might be better off
conducting the training myself. I reviewed all the Excel projects I have done
and selected business cases that are more likely to be encountered by most
Excel users such as:
- How to find month from dates
- Remove duplicates in a list
- Create subtotals automatically for each sales category
- Retrieve text of varying length intelligently
- Creating Pivot Table and Pivot Charts
- Macro recording for non-programmers
- Organised data retrieve from a web site
- Consolidate the data from worksheets in a workbook
- Tracking Changes
- Group records in Pivot Table
- Converting Multiple Row Records to one Row
To my surprise...
To my surprise, the courses were very well-received. Each
class was run at full capacity. Before I knew it, I have already
trained hundreds of them. I was elated that my courses are so well
received. But I found that there are many who have heard about my
courses are staying in other countries and could not fly all the way
here to attend my courses. I decided to explore how I could help them.
Thanks to the availability of the internet and other technologies, I was
able to turn the training into videos and uploaded the videos into the
website anyone could attend my training without being physically
present in my workshop.
But don't just take my word for it, here's what customers from all over the
country are saying about this unique MS excel course:
UnSolicited Testimony
I am impressed with `Unleashing Excel Potential' that I just bought. It is
one of those rare times when what is advertised is what you get.
Nur Ruby Lee
Patricia Pong, Senior Associate
|
"I am now able to track forecast changes which each country give without
having to remind them to mark changes in a different color. Pivot chart is also
a great eye opener."
Diana Ng, Demand Planning Manager,
Symrise Pte Ltd
|
"I have learnt the power of using formulas to prepare a detailed price contract
in much a shorter time frame by saving about 20% of the time and with much less mistake."
Sharon Long, Manager,
NCS Group
|
"This course has taught me how to use the pivot table effectively, and
helped me see the benefits of some functions to help me save time in analyzing
and retrieving useful sales data, and on the use of some functions which I
did not know of before."
Dawn Lee, Sales Manager,
Research Biolabs Pte Ltd
|
"In my organization, we need to analyze & present data at a regional level.
However, our data is only available in separate tables by country. I learn
how to merge data from these files & present them at a consolidated level.
The pivot charts are also very useful in presenting our KPIs on a regular
basis."
Patrina Kuek, Financial Analyst,
Acushnet Singapore Pte Ltd
|
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 realize 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. I'm 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.
Rachael Low, Trade Marketing Executive,
Johnson and Johnson Vision Care Singapore
|
I have learnt many powerful tools in excel. I used to spent a couple of
hours compiling and presenting the information from databases for
reporting. Now, I am able to extract valuable information from various
databases for my reports within minutes. After going through the case studies,
I manage to get the report together with charts out within 10 minutes,
with the pivot table and chart function.
Agnes Tan,
Singapore Heart Foundation
|
I learnt that Excel has many more functions that I'm not aware of. It opens
my mind in exploring more and thinking of how I can make use of it to collect
data. I'm hoping the knowledge gained here will help me do data query and
improve my productivity. I want to cut down the time needed to collate data
and present it in good visual presentation too. I think I should be able to
do that now.
Ivy Low, Administrative Executive,
Breastfeeding Mothers' Support Group
|
I now have a much better understanding of what can be done using Excel
for my business and also know how to do it! As the course has real
examples and each case study is a build up, it is easy to understand
the context and immediately make reference to my own company and
problems I have faced.
Neeraj Sundarajoo, Senior Consultant ,
Comwerks Interactive
|
I discover the power of pivot tables and charts which allows me to chart
very quickly. I now know what my staff can do to extract data and better
design forms for feedback survey after each talk or event.
Ho Sun Yee, Chief Eexecutive Officer,
Singapore Heart Foundation
|
In my day-to-day planning function, I have to manage a lot of data, to
translate these data into meaning reports for analysis and planning purpose.
This course has enabled me to use some useful formulas & functions to get the
report I want in a reduced time.
Lynn Soon, Demand and Supply Planning Analyst,
Acushnet Singapore Pte Ltd
|
"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, Managing Director,
Igus Singapore Pte Ltd
|
You may still be a bit skeptical and have some reservation,
but think about this - if you keep doing the same things over and
over again - you'll only succeed in getting the same old results.
So, try out my proven Excel course - completely and totally risk-free!
(I'll tell you about my unique guarantee in a moment.)
Which Of These Powerful Secrets
Could You Use To
Increase Your Productivity by up to 90%?
- How to find month from dates
- Remove duplicates in a list
- Create subtotals automatically for each sales category
- Retrieve text of varying length intelligently
- Creating Pivot Table and Pivot Charts
- Macro recording for non-programmers
- Organised data retrieve from a web site
- Consolidate the data from worksheets in a workbook
- Tracking Changes
- Group records in Pivot Table
- Converting Multiple Row Records to one Row
Okay, So What's the Cost
for This Incredible Resource?
At present, the Excel
course in Singapore is priced at US$450 per person. If I
were to conduct this course on a one-to-one basis and at your convenience, the
price could have easily triple or quadruple. On top of that, the website contains
more case studies than I could have covered in my two days course. So at bare bones
minimum, I could have charged in the region of $2,000 to $4,000 for the
Excel course.
But I am not going to charge you anywhere near that amount or even my
standard course fees of $450. In fact, your total investment for this
scenario-based Business Excel course is only $47.00.
So what's the catch? Why am I practically giving this resource away?
Well, it's really quite simple. Since you're accessing these directly from
the Internet I have no inventory and no fulfilment costs. I don't need to
pay anyone to take the orders over the phone (though, you are welcome to
call me at +65-6873-6646 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.
2 FREE Bonuses For Ordering Immediately!
Free Bonus Gift #1: Get a FREE one time E-Mail
Consultation from me, Worth $100.
You can send me any of your problems you
are currently facing and I will think of how best it can be resolved or worked out using
Excel. Most solutions I developed can potentially save you hours of manual work on the task,
excluding the time you need to spend to think of the solution. In one of the courses,
I managed to help a trainee reduce her Excel processes from one day to less than
one minute. That's right, there is no typo, less than one minute.
Free Bonus Gift #2: My detailed step by step eManual which contains 18 real
business case studies, Worth $27.
This book contains solutions to practical
problems asked by expereinced sales and marketing people. The solutions saved them
the headache of having to work on those analysis and reports manually.
Together these [2] free bonuses are worth more than 10 times your
investment in the Hidden Secrets To Excel Data Anaysis eCourse --
but they're all yours absolutely free when you order by now.
100%
Risk-Free Guarantee:
|
Your success in using Hidden Secrets
To Excel Data Anaysis eCourse is
completely guaranteed. In fact, here's my 100% Better-Than-Risk-Free-Take-it-To-The-Bank
Guarantee:
If in the next 56 days, you don't believe I've delivered on my promise to you,
I want you to ask me for a complete, prompt and courteous refund. However,
you keep the bonus gifts anyway, just for your trouble.
|
Is that fair or what?
That means you can review all the business case studies at my risk,
while you see if they work for you or not. And if they don't produce,
I honestly want you to ask for your money back. And I'll let you keep
the free bonus gifts as my way of thanking you for giving Hidden
Secrets To Excel Data Anaysis eCourse a shot.
There is absolutely no risk, whatsoever on your part. The burden to deliver
is entirely on me. If you don't generate your analysis and reports much faster than
before, then I'm the loser, not you.
|
 In spite of my 10 years of experience with spreadsheets, am pleasantly surprised
to confirm your claims made in your website. I kept shaking my head
at the priceless “revelations” contained in the video recordings.
The concepts and methods are patiently explained and one cannot over
estimate the worth of using practical examples which add dimension to what you learn.
I appreciate the value of the product which I have already commenced using.
Indeed on the basis of this I am likely to want to purchase more of your courses
Shmuel Oluwa
|
Look at it this way -- $47.00 is really a painless drop in the bucket
compared to the increase productivity you gained after the course. 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 Here!.
Get ready to WORK LESS ACHIEVE MORE!
Jason Khoo,
Founder
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!
(Order now through our Secure Server, and get instant access!)
Click Here Now!
If you are looking for physical Excel Training workshop in Singapore, take a
look at our Microsoft®
Excel courses for Business Professionals.
Microsoft® and Microsoft Excel® are registered trademarks of Microsoft Corporation.
everydayExcel is in no way associated with Microsoft |
