Time to time, you need to compare strengths and weaknesses, skills, or performance metrics for people, teams, or companies. The dimensions have different qualitative meanings, and, if you choose a bar chart to plot such data, you need to create a separate graph for each aspect. A much better option is to normalize the data and use a spider chart, which renders multiple axes with the same scale.
Because of different standards of different countries and cultures, there is a lot of situations when you need to change commas to dots, decimal points or dots, decimal points to commas in an Excel spreadsheet:
After recent updates, the ribbon in Microsoft Excel can take up to 1/3 of the available screen space. Microsoft Office help tells that you can hide or unhide your ribbon, but you cannot reduce the size of your ribbon, or size of the text or the icons. False! You can change the mode and remove unnecessary white space around buttons, and, thus, reduce the ribbon size.
Excel offers a lot of different tricks to create great informative charts and diagrams. A lot of the useful adjustments related to the axis. E.g., you can hide an axis, use primary and secondary axis, change the presentation of data on the axis, etc.
There are a lot of different pre-defined charts in Excel, but for some types of data, pre-defined charts such as area chart or line chart can look fine but are incorrect.
When you work with digits, it's crucial how you round them. It doesn't depend on what exactly you are rounding - decimals, thousands, or millions. You can see very different amounts after summing the figures, rounded in different ways:
For the analysis of the investment portfolio, it is helpful to see the unrealized gain or loss. These amounts show how many you will receive or lose if you realize all available stocks right now. Sure, there are some fees for the operations that can decrease gain or increase loss, but, at least, you want to see the least approximate amounts:
There are countless reasons why you might need to have stock prices in your Excel spreadsheet. In the past, you had to copy and paste from Yahoo Finance or another financial service, but at the moment, Microsoft offers a new way to add and update some stock information such as stock prices, changes of price, etc.
Many financial and non-financial companies like Yahoo provide investment portfolio tracking services but do not offer the ability to change the appearance of the charts. Microsoft Excel gives you full flexibility by providing different types of customizable charts. E.g., there are a few variations of the Area chart for tracking the value and costs of your portfolio.
One of the essential parts of any work with data is presenting results. You can use many different charts, diagrams in Microsoft Excel or PowerPoint.