• About
  • Contact
  • Privacy Policy
  • Submit For Review
  • Template Gallery
  • Excel 2016 Udemy Course
  • Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

TheAppTimes

App Reviews, Tutorials, & Gadget News Hub

  • Gadgets
  • How To
  • Mobile Apps
  • Software and Web Apps
  • Buying Guides
  • Shop
  • Show Search
Hide Search
Home » How To » How To Make Important Business Decisions Using Excel

How To Make Important Business Decisions Using Excel

August 19, 2013

A good command over computers and software is an invaluable attribute for any business leader. While you might be the best project manager/site manager in the world, but there is only such information you can store and juggle in your mind. Using technology allows you to visualize that information, to store data and to predict the future which can be highly useful in a whole range of different situations. In particular it can help you to navigate difficult decisions and make the right choices when faced with a lot of information and a lot of potential options. Excel in particular is a fantastic tool for decision making, and can help any manager to organize, plan and decide. But in order to use it well, you need to know the best methods. Read on to learn what those are…

How To Use Excel for Decision Making

Decision Making

How To Make Important Business Decisions Using Excel

Excel is an incredibly useful tool for decision making or choosing between multiple options – whether those are purchasing decisions, marketing decisions, or investment decisions. To do this, you will essentially be creating a ‘pros and cons’ list for each decision, but with a much more complicated system behind it.

Start off by making a list of the criteria that you need to meet. For instance then, if you’re looking at hiring a new member of staff, that criteria might include: ‘experience’, ‘likeability’, ‘creativity’, ‘skills’ etc. Alternatively if you’re thinking of moving to a new office, the criteria may be things like ‘locality’, ‘size’ and ‘cost’. Write these as headings on your Excel spreadsheet and leave a few spaces underneath each one.

From here you are then going to take your options and score them out of ten for each category. Perhaps one candidate is a 10 for experience and an 8 for likeability, while the other has the opposite scores. This way you can immediately get a picture of where each candidate’s skill lie.

Next you are going to add up the scores in each of those categories, but not before turning them into percentages that represent the weighting of each criteria. So for instance, you might value a good price for your next office more than the extra space, so in which case you would make cost 30% and space 10%. Now if the property scored 8 and 9 respectively, that would be 80% of 30% and 90% of 10%. Add up these totals to get 100% and you have a final score for each option that takes into consideration the weightings of the various criteria – now you know which option will best fulfill all of your requirements and hopefully you know which one to choose as a result.

ALSO READ:  Excel 2010: How to Match Two Lists of Items in Microsoft Excel

Financial Modeling

financial modeling

image source

Simpler is financial modeling. This essentially means creating a spreadsheet of all of your overheads and incomes in order to create a complete picture of your finances on any given month. Include in this your total assets and add to this the amount of profit left over at the end of that month/subtract the difference. This way you can not only see where your money is being spent each month, but also how this is going to affect your finances over time, and what it will ultimately result in if you continue to follow the same patterns. Of course some elements might factor in bi-monthly or tri-monthly, and should be entered accordingly.

This then also allows you to make ‘projections’ of where your finances should be at any given time and those projections can be visualized as graphs and charts. This can be useful when demonstrating to clients/business partners/investors why your business is a safe bet, but it can also be useful for financial decision making as it allows you to ‘test’ the financial impact of those moves.

For instance you could sample what would happen to your finances were you to move to a cheaper energy provider by entering it into the spreadsheet and then decide whether or not the savings would warrant the hassle of making the move. Likewise it can also be used to show you what you would be able to afford at any given time. Can you afford to invest in a new marketing campaign next month? Or would you be better served by waiting just one more month?

By using financial modeling templates and using Excel spreadsheets well it can become your crystal ball for divining the future of your business and testing out various scenarios. Your company will be able to dance between the rain drops…

This post is contributed by Thomas Ethan, a project management consultant who works for Procept Consulting, one of the best consulting services providers. Whenever he isn’t busy, he likes to spend time with his family and learn about various gadgets.

Tweet
Share1
WhatsApp
Pin84
Buffer2
87 Shares

Filed Under: How To Tagged With: excel

You May Also Like

How to Delete Blank Rows in Excel 2016
How to Delete Blank Rows in Excel 2016
excel 2010 tutorials
How to Create Summary Worksheets in Excel 2010
excel 2010 tutorials
Remove Duplicate Rows in Excel 2010 in 4 Super Quick Ways

About Community Contributions

This post is written by a community contributor. You can find details about the writer within the article content, either at the top of the post or towards the end.

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Hottest New Gadgets!

Fast External SSD Gadgets for your Mac - TATFI

4 Fast External SSD Gadgets for your Mac (2021)

Anker Powerhouse 100 - TATFI

Charge Your iPhone, Galaxy, iPad, or MacBook with the Portable Power Bank Anker Powerhouse 100

Logitech Circle View - TATFI

Logitech Circle View – A Great Wired Outdoor Camera for HomeKit Users

Spigen Galaxy S21 Cases - TATFI

Spigen Galaxy S21 Cases is Perfect for New Samsung Smartphone

Samsung Galaxy SmartTag Bluetooth Tracker - TATFI

Find Lost Items with the Samsung Galaxy SmartTag Bluetooth Tracker

Popular Tags

android android apps android games android how to apple chrome extensions excel excel how to facebook gadgets gaming gmail google instagram ios apps ios games ios how to ios tips ipad iphone kids apps learn excel management microsoft music apps new releases outlook how to photo apps powerpoint powerpoint how to productivity Samsung security smartphone smartphones software tablet tablets technology twitter web browsers windows 10 word how to xbox youtube

Disclosure

TheAppTimes is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.

TheAppTimes © 2021 // Runs on StudioPress