Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
When you have a big dataset with blank cells scattered through it, manually clicking each one is a waste of time. Excel has a few quick ways to grab every blank cell at once so you can fill them, delete them, format them, or do whatever else you need. In this article, I’ll show you …
Apart from being super cool, Excel dynamic charts are really helpful in presenting a comparative analysis from the data. Suppose you have the financial data for a company ABC Ltd, and you want to see how the revenue has grown over the quarters. At the same time, you also want to compare the growth with …
Combination charts in Excel let you present and compare two different data-sets that are related to each other (in a single chart). When you create a regular chart in Excel, it usually has only one X-axis and one Y-axis. But with combination charts, you can have two Y-axis, which allows you to have two different …
A lot of times we have charts that have to handle empty data cells. Excel gives you the flexibility to decide how the empty cells should be treated. Suppose I have the data for date-wise sales of a product from a shop. Assuming that the shop is closed on Sunday and national holidays, there are …
It is possible to create a multi-category chart in Excel (as shown below). The trick is to arrange the data in a certain way, that makes Excel interpret as having multiple categories. Suppose I have the data for the monthly expenses I make on the food items (as listed below). The idea to create a chart …
I often wonder why there is no provision to adjust the maximum value of a scroll bar in Excel based on a cell value. Had this been available, a scroll bar would automatically adjust its maximum value when the cell value changes. Something, as shown below, could then have been possible: Until the time it …
I often use scroll bars in an Excel dashboard, which gives a user the freedom to change its values and play with the data. If you have multiple scroll bars in your dashboards, it is helpful to display the current value of each scroll bar. Something as shown below: The idea is to display the value …
In this blog post, I will show you a formula to get a list unique items from a list in excel that has repetitions. While this can be done using Advanced Filter or Conditional Formatting, the benefit of using a formula is that it makes your unique list dynamic. This means that you continue to get …
Excel Custom Number formatting is the clothing for data in excel cells. You can dress these the way you want. All you need is a bit of know-how of how Excel Custom Number Format works. With custom number formatting in Excel, you can change the way the values in the cells show up, but at the …
©trumpexcel.com – Free Online Excel Training
