Advantages of Microsoft Excel

Why use a Microsoft Excel spreadsheet?

I am an accountancy professional with 25 years experience in working in busy finance departments. I've seen the development of spreadsheets from cumbersome tools that were barely used into multimedia suites that integrate multiple sources and streamline time consuming tasks within the busy office.

I was first introduced to a spreadsheet (Lotus 123) in 1987 and immediately realized the impact it could have on my working life. At the time I was in charge of the day books for a large organization and found that I spent half my time searching for minor calculating errors within each book - this was not only time consuming but also very frustrating.

With the introduction of Lotus 123 to my firm I was able to create spreadsheet versions of the day books that automatically subtotaled themselves thus removing any errors and making the whole process more efficient.

Back in 1987 the spreadsheets were very cumbersome and unless you were very computer oriented they were very difficult to use and understand and therefore initially there was a lot of reluctance to use it from "Old School" accountants.

Several years later Microsoft released their Windows based version of their spreadsheet and caught Lotus by surprise. The Office suite that Windows produced was easy to use, intuitive and allowed interaction between different modules such as a spreadsheet, a word processor and a database. Lotus were stuck back in DOS and really lost ground never to truly recover.

Microsoft revolutionized the Office Suite and bought it to the masses - as accountants began to see what the spreadsheet could do and how it could take complex tasks and automate the calculations it began to gain traction and the rest is history.

As someone who uses a Microsoft Excel spreadsheet daily I cannot imagine what life was like back in the 80s when everything was hand-written and hand calculated!

Example Expense Worksheet created with a Microsoft Excel 2010 template.
Example Expense Worksheet created with a Microsoft Excel 2010 template. | Source

What is Microsoft Office?

Microsoft Excel is part of the Microsoft Office suite. The whole suite also includes the following products:

  • Word 2010 - a powerful word processing tool.
  • Powerpoint 2010 - an intuitive tool used to create great presentations
  • Onenote 2010 - a simple program that allows you to gather notes and information in one place
  • Outlook 2010 - a great tool that allows you to manage all your email accounts
  • Publisher 2010 - helps you design and publish great looking documents
  • Access 2010 - a very powerful database tool

Advantages of Microsoft Excel

Microsoft Excel allows you to manipulate, manage and analyze data helping assist in decision making and creating efficiencies that will directly affect your bottom line. Whether you’re using it for business or to help manage personal database and expenses Microsoft Excel gives you the right tools to enable you to accomplish all your needs.

The advantages of Excel are wide and varied; here are the main advantages:

  • Easy and effective comparisons - With the powerful analytical tools included within Microsoft Excel you have the ability to analyze large amounts of data to discover trends and patterns that will influence decisions. Microsoft Excel’s graphing capabilities allows you to summarize your data enhancing your ability to organize and structure your data.
  • Powerful analysis of large amounts of data - Recent upgrades to the Excel spreadsheet enhance your ability to analyze large amounts of data. With powerful filtering, sorting and search tools you are able to quickly and easily narrow down the criteria that will assist in your decisions. Combine these tools with the tables, Pivot Tables and Graphs you can find the information that you want quickly and easily even if you have hundreds of thousands of data items. While you will need the latest technology to get the best out of Microsoft Excel it is scalable and can be used at home on your low powered PC or at work on your high powered Laptop.
  • Working Together - With the advent of the Excel Web App you can now work on spreadsheets simultaneously with other users. The ability to work together enhances your ability to streamline processes and allows for ‘brainstorming’ sessions with large sets of data – the collaboration tools allow you to get the most out of the sharing capabilities of Microsoft Excel.The added bonus is that as the Excel Worksheet is web based you can collaborate anywhere – you are no longer tied to your desk but can work on spreadsheets on the go – this is ideal for a businessman on the go.
  • Microsoft Excel Mobile & iPad Apps - With the advent of the tablet and the smart phone it is now possible to take your worksheets to a client or a meeting without having to bring along your Laptop. The power of these mobile devices now allows you to manipulate data and update your spreadsheets and then view the spreadsheets immediately on your phone or tablet.

Microsoft Excel is a very powerful tool, but it is versatile enough to have some fun. Within the templates is a section of games - this is an interactive Battleships worksheet.
Microsoft Excel is a very powerful tool, but it is versatile enough to have some fun. Within the templates is a section of games - this is an interactive Battleships worksheet. | Source

Advanced users of Microsoft Excel can use Visual Basic for Applications to automate Excel. VBA is a very powerful programming language that allows you to enhance the overall functionality of Excel.

Disadvantages of Microsoft Excel

  • Not easy to share – Microsoft have made great strides with their Web applications but the sharing functionality still has a long way to go to become world class. Part of the problem is that often the ability for sharing a tool requires extra software to be installed on the PC and this often becomes cumbersome. Tools like Google Documents are revolutionizing the way people share documents online.
  • Non relational – I use MS Access for databases and love the relational aspect of the database. The idea that you can link data by common elements (such as employee ID, Stock Number etc) greatly assists in the reduction of data, and the ability to analyze data. Aside from some database functions and some lookup tools Microsoft Excel lacks any true relational functionality.
  • Scalability – Excel 2010 has introduced larger spreadsheets and binary formats, howver using large amounts of data on the average PC will slow down and often freeze the PC. As some of the competing tools are in the 'cloud' file size does not become a problem.
  • No Forms – while you can use forms within VBA, the average user will not have much knowledge of VBA and therefore not be able to incorporate functional forms into their spreadsheets quickly.
  • Customizable Graphs – Microsoft Excel does offer a good variety of graph capabilities, however the customization of the standard formats, and the combination of different data sets and different types of graph is awkward and not intuitive. For a powerful worksheet this is a big disadvantage.

What can Microsoft Excel be used for?

Microsoft Excel is a very versatile tool and can be used for almost anything that you can imagine:

  • Agendas
  • Budgets
  • Calendars
  • Cards
  • Charts and Diagrams
  • Financial Tools (Loan calculators etc.)
  • Flyers
  • Forms
  • Inventories
  • Invoices
  • Lists and to-do checklists
  • Planners
  • Plans and proposals
  • Reports
  • Schedules
  • Timesheets

This is a small selection of what can be achieved on Microsoft Excel. I have provided some examples on the right - all of these example used the Microsoft Excel templates that are available online for free.

Click thumbnail to view full-size
Microsoft Excel Agenda worksheetMicrosoft Excel Expense worksheetMicrosoft Excel CalendarMicrosoft Excel ID CardMicrosoft Excel ChartMicrosoft Excel InvoiceMicrosoft Excel Loan CalculatorMicrosoft Excel Planner (401k)Microsoft Excel ReportTimesheet
Microsoft Excel Agenda worksheet
Microsoft Excel Agenda worksheet | Source
Microsoft Excel Expense worksheet
Microsoft Excel Expense worksheet | Source
Microsoft Excel Calendar
Microsoft Excel Calendar | Source
Microsoft Excel ID Card
Microsoft Excel ID Card | Source
Microsoft Excel Chart
Microsoft Excel Chart | Source
Microsoft Excel Invoice
Microsoft Excel Invoice | Source
Microsoft Excel Loan Calculator
Microsoft Excel Loan Calculator | Source
Microsoft Excel Planner (401k)
Microsoft Excel Planner (401k) | Source
Microsoft Excel Report
Microsoft Excel Report | Source
Timesheet | Source

How to learn Microsoft Excel

There are many ways to learn Microsoft Excel. Which one is most effective will depend on you and your own personal preferences:

  • Learn as you go – the way I learnt how to use spreadsheets was to simply jump in and try things out. For me the best way to learn anything is by trial and error. Once I knew the basics and had taught myself some intermediate skills I started reading some books and attending some courses to perfect my skills.
  • Training Books – there are literally hundreds of books available that will cover all aspects of Microsoft Excel training. Excel 2010 for Dummies is a great book to start with. It is well written, covers all major aspects of a spreadsheet and is a great introduction to Excel. Excel 2010 Bibleis essential for intermediate users who want to go to the next level or for experts who want to delve deeper into the intricacies of Excel.
  • Training Courses – Microsoft have a lot of training courses available on their office website. These courses are mostly video based and are a great resource for all levels of users – most of these courses are free. You can also find many professional organizations that have beginners, intermediate and advanced courses, as well as many companies that will come to your office to provide training.
  • Mentor one resource that is often overlooked is finding a mentor. Often a mentor will know tips and tricks that will not normally be covered in an intensive training course. Not only are you able to use the experience of the mentor to learn but you can all ‘bounce’ ideas off your mentor.

How to get help with Microsoft Excel

You’ve attended every course on ‘How to use Microsoft Excel’ but have come across a problem you have not covered – what should you do?

You have several options:

  • Search the Microsoft Support website – there is a large amount of help within the knowledge base and most problems you encounter will have a solution or workaround on their support site.
  • Forums – there are hundreds of excellent forums on the web dedicated to Microsoft Office. You can search these forums for a solution to your problem or pose a question if you cannot find an answer.

Microsoft Excel Competition

While Microsoft Excel is the most used spreadsheet in the world, there are some decent alternatives that are a lot of cheaper. While they may not provide the same functionality as Microsoft Excel, they are suitable for beginner and intermediate users:

  • OpenOffice.Org - this is probably the most widely used and well known free alternative to Microsoft Office and Microsoft Excel. The spreadsheet is good but does not compete well with Microsoft Excel. It has decent functionality for beginner and intermediate users but really doesn’t compare well in terms of functionality and ease of use.
  • Google Documents – Google were the first company to move office applications into the cloud (Microsoft are slowly catching up) – this allows you to access your spreadsheets from anywhere in the world as long as you have access to the internet. The basic services are free and the spreadsheet is decent but still does not compare well in terms of functionality with Microsoft Excel. The biggest advantage Google Documents has is the ability to collaborate easily and quickly.
  • Lotus Symphony – this essentially is a derivative of Open Office (which is open source). Backed by IBM this free product offers more functionality than Open Office and is a decent competitor to Microsoft Excel. It still lacks quite a lot of functionality though and won’t replace Excel just yet.
  • Lotus 123 – this is one of the best competitors to Microsoft Excel. The functionality is much the same as Excel and you have the ability to import or export Excel spreadsheets. With the backing of IBM Lotus 123 is a great alternative to Excel, however the advantage that Excel has is that it is widely used in the business world.

Comments 20 comments

twinstimes2 profile image

twinstimes2 4 years ago from Ohio

Great overview of Excel, Simey C! I am not sure people realize Excel has come a long way to becoming more user friendly. Great job!

theraggededge profile image

theraggededge 4 years ago from Wales

I love Excel - it's what computers were invented for. I even used to dream in Excel! I used to teach it many years ago - we also used it with Vis Basic for programming. However, these days, I have switched to Open Office and Libre Office due to the cost of MS Office.

SimeyC profile image

SimeyC 4 years ago from NJ, USA Author

theraggededge: If you work for a firm that licenses Microsoft Office depending on the license agreement you can actually get a full copy of Office for about $10 - you can keep the full version as long as you work for the firm!

ThePracticalMommy profile image

ThePracticalMommy 4 years ago from United States

This is a great explanation of why Excel is truly an awesome program to utilize in the business and personal world. I had no idea it wasn't the first program of its kind; I never heard of Lotus before. I have used Excel since I was in high school and assumed it was one of a kind. Now I know better!

Well done!

LauraGSpeaks profile image

LauraGSpeaks 4 years ago from Raleigh, NC

Great informative hub on Excel. I haven't used Lotus in years, but I always found Excel to be much more user frendly.

Cardisa profile image

Cardisa 4 years ago from Jamaica

I love office even though I really don't like MS operating system at all but The entire office suite is awesome. I have been using a trial and need to make a purchase now and I certainly will be doing that.

Loved the article SimeyC.

klanguedoc profile image

klanguedoc 4 years ago from Canada

This is a great overview of Excel. I also liked your overall page layout. Very nice. I use Excel as part of our BI solutions at work and I have developed several interfaces with SQL Server as a way to share data, using Excel as a client and analysis tool.

Love your article SimeyC

idigwebsites profile image

idigwebsites 3 years ago from United States

I use this for counting my monthly expenses. I love the new features there. I even use the keyboard commands which in fact make using Excel more fast and efficient. Thanks for posting. :)

pocono foothills profile image

pocono foothills 2 years ago from Easton, Pennsylvania

I frequently use Microsoft Excel to graph data at my job, but I know the program is capable of a lot more than I would ever use it for. I tried to learn Microsoft Access a couple of years ago, but for me, that was a totally lost cause. Way too complicated for a non-computer whiz like me.

oliwier profile image

oliwier 2 years ago from London, United Kingdom

Microsoft excel have lots of functions. One can learn it from trial and error.

upal19 profile image

upal19 24 months ago from Dhaka

Excel is excellent. This is part of my everyday life. I'm learning excel. There are many things to learn yet. Thanks for this valuable piece.

WestelCS profile image

WestelCS 22 months ago

I do believe that Microsoft Excel has become the standard spreadsheet for most business use with it’s ease and functionality. Excel allows business users to unlock the potential of their data, by using formulas across a grid of cells. Thanks for updating the benefits of Microsoft Excel as it will help the business making the most of resources.

CISSPTutor profile image

CISSPTutor 22 months ago from Hyderabad, India

Great article. I am an avid user of excel but refreshing to see an actual article about it. Also like the references given in the call outs for further exploration. Please provide more links to quality articles about excel advanced tips and tricks if you could and this would be the perfect article for me.

mehak 17 months ago

Explanation good

hsrshita 16 months ago

Its good

tracy 15 months ago

this is an awesome MS Excel.That helps the students alot...

Tracy 12 months ago

it is nice because excel has done a great job towards the calculation part

justine 12 months ago

explanation good buddy

Avisha 2 months ago

Amazing and awesome explanation. Adored it.....

Davor Geci 6 weeks ago

Hello Simon,

I think that you can slowly remove the No Forms and Non Relational from the list, because the project Virtual Forms for Microsoft Excel is a new product that fills the gaps in segment of creating Userforms without coding in MS Excel.


I'm the CEO of the company behind the Virtual Forms project

    Sign in or sign up and post using a HubPages Network account.

    0 of 8192 characters used
    Post Comment

    No HTML is allowed in comments, but URLs will be hyperlinked. Comments are not for promoting your articles or other sites.

    Click to Rate This Article