Era of electronic spreadsheets started from VisiCalc in 1983 and now well developed version of Microsoft Excel 2010 is available at this moment and too much is to appear yet.
Name any profession where employees use computers, Excel exists there. No organization working with computers for its communication and operations can live without using Excel. Although there are many advanced and focused tools available for statistical analysis and accounting tasks, yet Excel is the simplest and effective. Less expensive as well.
It is fact that many professional come across importance of Excel when they have completed their education and starting some job or internship. Before this point, Excel was almost of no use for them. Excel is widely used tool in corporate environment for creating basic reports and handling extensive data as well. This is being used as a simple calculator to high end data analysis assistant. Many a companies which can’t afford to have expensive ERPs, run their finances and operations using this software.
I got to know about Excel in 10th grade of school, back in 1999. That was limited to typing names, using different sort of text options and formatting outlook of cells. Later in 2000, I got opportunity to attend Microsoft Office Certification Course. This course introduced me to basics of using formula, creating basic line and bar charts and some taste of macro recording. During my Bachelors in Electrical Engineering, prime use of excel was to make a table to fill it with experimentation values and sometimes making a graph of available data. It was in January 2007 when I started my first job in Operations Core Networks department of a leading telecommunication company. Since then, Excel became part and parcel of my working life. Usage of formals, conditional formatting, different charts and pivot tables became a part of my job.
Aim of this blog is to prepare and share a sort of Excel tips and tricks library so as to document all my tasks such that those are understandable by you.