Sunday, January 16, 2011

Power of Excel

The moment I log in to the office, the first things I need is an Excel spreadsheet. Whether it is getting the result of some calculations or providing a quick summary to my manager, excel has been doing it for me since the time I first stepped into office to start my professional career. This is not only my story but of millions of people around the world. MS Excel is the one of the most widely used software in the world, when it comes to the calculations or generating a summarized report. The first version of Excel was released for the Mac in 1985 and the first Windows version (numbered 2.0 to line-up with the Mac and bundled with a run-time Windows environment) was released in November 1987.
The Excel 2007 version which we are using these days supports much more data than its earlier versions. It has more than 1 millions rows & 16000+ columns. Excel 2007 also supports multicore processor platforms for faster calculation of formula-intense spreadsheets. Major benefits of this version include professional & better looking charts, much enhanced support to filters & tables. One change in this version which has left me speechless is the way we can utilize the feature of conditional formatting. Not only it shows the trends with the help of the traffic lights but can also show you in cell chart with the help of data bars. PivtotTables help me find answers to questions quickly, easily and responsively. I can drag and drop fields to make change the table's view.
Here are some of the things which I utilize for my work every day.

No comments:

Post a Comment