Kamis, 10 Oktober 2013

Hidden secrets in data analysis with excel 2007/2010 | everydayexcel

hidden secrets in data analysis with excel 2007/2010 | everydayexcel


Click here for more images

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!


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.


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.


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.

Read More detail...

Tidak ada komentar:

Posting Komentar