Use MicrosoftÂ® Excel Differently to Gain a Productive Edge
Issue - Mar 2010
In today's corporate world, most managers and executives are proficient in using the computer. Thus, it is not at all difficult for them to pick up the basics of MS Excel, a common application used by every organisation. The basics of Excel can be mastered in less than an hour. And when encountering a problem related to opening and saving workbooks, entering data and numbers into cells, sorting, auto-filtering, modifying the data in a spreadsheet, just to name a few, they can easily grab and ask someone around them, such as colleagues, their spouses, siblings or even their parents. So, attending a basic Excel course would be a complete waste of time.
In an Advanced Excel course, managers and executives are taught how to use templates, auditing tools in Excel and tons of formulas that are hardly used in their day to day jobs. Furthermore, a typical Excel trainer conducts only technical training and usually does not have the practical experience or view on how Excel is used in the pragmatic corporate world. Each of the formulas and functions is taught in isolation without any real business context applied. No matter how familiar these trainers are with the formulas and functions of Excel, they would not be able to demonstrate on the spot the real power of Excel by solving real business problems that challenge managers and executives on a daily basis. As such, attending an Advance Excel course is also a complete waste of time and money for managers and executives.
If a manager or executive wished to attend an Excel course, it HAS TO BE a course that can help them solve real, unique Excel problems in the corporate environment. Knowing what each Excel function does is not enough. The course must reveal the secrets of tweaking the formulas and also show how formulas and functions can be combined. Learning this skill will help to automatically convert raw data into quality business information speedily without the common manual copying and pasting. So, a real time saver for any manager or executive!
Having quality business information and not able to analyse it is a common serious problem faced by managers and executives. Therefore, what they need is to learn how to make use of the powerful and yet simple functions to analyse the business data they have, either directly from the system or from the data processed using Excel formulas. Combining functions together can automate the entire business reporting process and leave more time for business managers and executives to interpret the data. Hence, a must-have in an Excel course.
Our training is developed by practitioners who are constantly working on Excel through consultancy works with our clients. Therefore, we have a view to the issues faced by most managers and executives who usually are not even aware that the work they are doing now can be reduced to mere minutes! Our courses have proven to save managers and executives as much as 90% of the time they spent on Excel. That is 45 times more than the productivity target set by the government. Our course graduates no longer have to perform frequent laborious manual copying and pasting of data from one cell to another or from one worksheet to another (By the way, do you know that a normal user will do a copy and paste once every 5 mouse clicks?). The skills they acquire in the course help them speedily clean and re-organise data accurately without human error. Processing the data accurately now take them no more than 5 minutes, compared to a typical Excel user who takes at least half a day for the same task.
Click on this Excel Courses page and check out which course(s) your managers and executives should attend. Alternatively, contact us now at 6873 9946 or email us at firstname.lastname@example.org for advice on which of our excel training programs is suitable for you.
If you received this newsletter from a friend and would like to be included in our mailing list, please go to our Excel Today's page.
If you have a facebook account, you can like us at facebook or linkedln. From facebook or LinkedIn, you will be notified on mini cases and ideas how we use Excel on a day to day basis. These tips may not be published in our newsletter.
everydayExcel Business Lab Pte Ltd
Author of "Hidden Secrets of Data Analysis with Excel" and
"Excel Secrets for Highly Effective Marketers"
Received this newsletter from a friend? You can request to be included in our mailing list by signing up at our Excel Today's page. If you have friends whom you think might be interested in this newsletter, feel free to send it to them.