What is Microsoft Excel?
Microsoft Excel is a software that is widely used for organizing, analyzing, and storing data. It is helpful for handling both numerical and non-numerical information, including text, dates, and other data types. Whether you need to perform basic arithmetic calculations or to build a sophisticated financial model, Excel will help you do it quickly and easily.
Because the tool offers a very broad set of functionalities, compiling an exhaustive list of all possible reasons to create an Excel workbook would be a challenging task. However, here are a number of most popular Microsoft Excel uses:
- Data mining – Understand the Past
- Find trends and patterns in existing data
- Identify drivers behind the trends
- Visualize your insights to share with others
- Modeling – Forecast the Future
- Lay out your most critical assumptions
- Perform necessary calculations to convert assumptions into model outputs
- Visualize your outputs to share with others
- Automation – Become more efficient
- Outsource analytical tasks to a machine
- Speed up your analytical work and avoid “human errors”
Let’s say, Max wants to save $10K this year to buy a car. He wants to understand whether he’s on track to reach this goal and, if not, what corrective actions are needed.
Using Microsoft Excel, he analyzed his bank statement and realized that he is not saving enough to reach the goal on time. Then, he built a simple Excel model and found out that, to reach the target, he needs to move to a cheaper apartment and stop visiting a local coffee shop twice a day. If both conditions are satisfied, he will be right on track to buy the car in one year from now.
How to do it
- First, Max converted his account statement to Excel format. Nowadays most service companies provide an option to export monthly statements to Microsoft Excel. Otherwise, you can just directly copy them from the web page and paste in your Excel workbook. Figure 1 shows what Max got as a result.
Next, Max created an Excel pivot table to summarize the data (see Figure 2) and got two major insights from it:
- He has been only saving a little more than $120 a month. If he continues like that, he will only get $1.5K in one year, not the $10K he needs
- After his monthly rent ($2K), the second largest expense was actually a local coffee shop. He stops there every morning to get a cup of amazing latte and then after lunch again for a cup of tea
- Then, Max built a simple Excel model to see what it takes for him to reach $10K savings by the end of the year:
- First, he assumed that all monthly expenses stay the same. That gave him ~$1.5 annual savings (see Figure 3, highlighted in yellow)
- Second, he assumed he can move to a cheaper apartment ($1.5K per month instead of $2K) and start brewing coffee at home instead of visiting a local coffee shop. He has a huge supply of coffee at home, which he rarely uses, so the cost of buying coffee beans can be neglected. That scenario actually proved to reach just about his targeted savings of $10K per year (see Figure 4).
All in all, Max spent less than half an hour to analyze the data and make the decision. The functionality of Microsoft Excel made this task very easy for him, so he could immediately move on to searching for a new apartment as his next step.
Excel Introduction Quiz
0 of 3 questions completed
Take a quick quiz to test how well you understand this topic:
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading...
You must sign in or sign up to start the quiz.
You have to finish following quiz, to start this quiz:
Time has elapsed
You have reached 0 of 0 points, (0)
Question 1 of 3
Which of the following Excel is most useful for?Correct
Although Excel can accomplish all the goals listed above, only one option highlights its major strengths. You might consider reviewing our description of what Excel is used for
Question 2 of 3
In which of the following situations Excel might be considered a relevant tool to use?
Select all that applyCorrect
Most of the above-mentioned tasks can be accomplished in Excel. However, writing articles or creating commercial software in Excel wouldn’t really leverage its major strengths. There are other helpful apps that would solve these two tasks more efficiently. You might consider reviewing our description of what Excel is used for
Question 3 of 3
Which of the following can be created in Microsoft Excel?
Select all that applyCorrect
All this can be done in Excel. You might have another look at our introduction to Excel article. It includes a pivot table example and a simple Excel model, as well as mentions other potential uses of Microsoft Excel, including task automation and visualization of your insights