Interactive Charts Interactive Charts Charts visuals are better in data depiction, but interactivity gets it better.

In other words, the tool helps answer the question, “what should be the value of the input in order to attain the given output?”

Goal Seek Analysis Goal Seek Analysis The Goal Seek in excel is a “what-if-analysis” tool that calculates the value of the input cell (variable) with respect to the desired outcome.

There are plenty of uses of excel, and the list goes on, but here we have listed some of the important uses of Microsoft excel to start the things for a beginner.

Depending on the circumstance, you might need to write a letter, a table, or maybe a year end report that contains a combination of both.ġ.Word is a word processing application while Excel is a spreadsheet applicationĢ.You usually use Word in writing letters or essays while Excel is good for creating documents that has a lot of data that needs to be presented in table formģ.You can insert Excel tables inside a Word documentĤ.Excel lacks some advanced formatting abilities that are present in Wordĥ.List of Top 12 Important Uses of Microsoft Excel You would not find this type of capability within Word.Įven though both applications serve a different purpose, it is often common to see people who use them in tandem to create their paperwork. This can be as simple as the sum of all the entered data, taking their average, to even more complex equations. This capability allows users to create pre formatted documents that only need certain data and derives the rest. A feature of Excel that a lot of users find to be very convenient is its ability to analyze and compute formulas and conditional statements. The font, paragraph, and page formatting options of Word makes it easy to create documents that are free flowing and conversational, which is quite difficult in Excel. But each application has strengths that makes them well suited to the tasks they perform.

You can insert tables in a Word document or write whole paragraphs inside a single Excel cell. From the table, you can deduce or calculate how the information is related to each other and you can even create graphs to visually represent the said relationship.īoth applications can create printable documents and it is therefore possible to use one to simulate the function of the other to some extent. Excel, on the other hand, is a spreadsheet application where you can input data in tables in the pattern you choose.

Word is word processing application that is used to write documents like letters or essays where text formatting is very essential to provide a printable document that can be read very easily. In it, the two most commonly used applications are Word and Excel. Aside from Microsoft Windows, you would probably need to have another software suite from Microsoft called Microsoft Office.

5 uses of microsoft excel