Issue - October 2014
You probably do not notice how you enter data into Excel so long as the number or text appears in the cell you want. But the way you enter data into the cell will determine whether you have to spend hours or just in a few minutes in data cleanup. To test whether you have that “bad habit”, take this test:
You should see the letters “abc” in the range “B2:B6”.
If you have the bad habit, you will only see B2 contains the letters “abc”.
So what is the “bad habit”?
The “bad habit” is to double click on the cell before typing the letter “abc”. If you double click on the cell, the selected range B2:B6 would have disappeared. Thus, only B2 will have the letter abc.
Next issue: The second bad habit….
Click on this link to post your question.
With the newly introduced PIC bonus, you are now paid (not paying) 60% of the course fees for sending your staff to our courses. Check out now in this IRAS PIC Link.
Hidden Secrets in Data Analysis with Excel 2007/2010 - 13 & 14 Nov 2014 (Limited Seats)
Gaining Stunning Business Insights with Excel Power Pivot - 10 & 11 Nov 2014 (confirmed)
Hidden Secrets in Data Analysis with Excel 2007/2010 - 29 & 30 Jan 2015 (confirmed)
The Hidden Key to Excel Reporting and Charting - 19 & 20 Mar 2015 (confirmed)
Unleash the Power of Excel Power Pivot for Data Insights - 22 & 23 Jan 2015 (confirmed)
Learning the Magic of Macros 2007 (Excel VBA) - 5 & 6 Mar 2015 (confirmed)
Breakthrough Performance for HR in Excel 2007/2010 - 12 & 13 Mar 2015 (confirmed)
Dynamic Real-Time Forecasting with Excel 2007/2010 - 23 & 24 Mar 2015 (confirmed)
For the details of the courses, please refer to our Excel courses page.
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.