Anybody who has used a pencil and a paper along with a calculator to calculate formulas would know that it is very easy to use a Microsoft Excel worksheet. In this manner, he can make sure that all the functions of the worksheet are working perfectly, and the calculations are being done in a fraction of the time, which it took in the punching of every single number upon the calculator!

Not only can you make sure that the data which you have collected is displayed in a systematic and well analyzed manner, as well as the analytical results which have been calculated on the basis of that data, but there are new excellent charting tools as well as a charting engine, which can be used to make sure that all of the data is displayed in a chart which looks very professional and systematic. The Excel program has the added benefit of a new interface, which is known as Fluent User. Not only does it add transparency to your final product, but you can also get 3-D effects, as well as shadowing, and as it happens to be an interactive program, you can put in PowerPoint and Word documents into your final Excel chart.

If you happen to be working a lot with different tables, you can get extremely improved support by which you can filter, refer, format, create, expand, change, and do any other functions within any sort of formulas, and even elaborate them to suit your own specifications and requirements.

The best thing I found about Excel is that I can manage to freeze the table headings and keep them in the view when I happened to be scrolling all over the place in an extremely huge database. So I know that I am on H 89, and looking upon because in which shows me the sales for the period January to March in Vancouver, which I can compare with G89, showing me the sales for the period January to March in Ontario.

Now I'm interested in seeing the exceptions and the important trends in the data which is displayed in front of me. All I have to do is apply some conditional formatting to all that data, so that I can discover any relevant items which are occurring again and again, and also highlight all the trends, which are appearing regularly in my data. This can be done by making my choice of data bars, heat maps, color gradients, and even indicator icons, based upon the performance. After I have selected all these trends, I need to send the information to the branch offices in Vancouver and Ontario. It is very easy to turn this spreadsheet into an HTML document thanks to the use of Microsoft's server.

Now all they have to do is go online and my people are going to use their browser to open up the file. It is very easy for all these users to filter, sort, navigate, interact with all the information which I have given to them, and even input all the parameters, right in the browser itself and online and then send that information back to me.