Step-by-step Excel guides, formulas, and tips. New tutorials added regularly.
You can group numbers in Pivot Table to create frequency distribution tables. This helps in analyzing numerical values by grouping it into ranges. A simple example of this could be to analyze how many students scored marks between 40 and 50 and how many got marks between 50 and 60 and so on.. Another example …
One of my readers Donna sent me this query. She did some scoring in Excel and created Harvey balls using conditional formatting. She wanted to display the Harvey Balls as well as the score together. She also wanted to increase the font size of the Harvey Balls only and not the font size of the …
Having the data in the right format is a crucial step in creating a robust and error-free Pivot Table. If not done the right way, you can end up having a lot of issues with your pivot table. What is a good design for the Source data for Pivot Table? Let’s have a look at …
I got a call from a friend who wanted to combine multiple Excel files into one Excel workbook. He had a lot of files in a folder and he wanted to get all the worksheets from all the workbooks into one single workbook. While this can be done manually, it would be time-consuming and error-prone. However, a simple VBA …
It’s common to find numbers stored as text in Excel. This leads to incorrect calculations when you use these cells in Excel functions such as SUM and AVERAGE (as these functions ignore cells that have text values in it). In such cases, you need to convert cells that contain numbers as text back to numbers. Now …
Excel 2010 version of the Pivot Table was jazzed up by the entry of a new super cool feature – Slicers. A Pivot Table Slicer enables you to filter the data when you select one or more than one options in the Slicer box (as shown below). In the example above, Slicer is the orange box on …
Once you have created a Pivot Table, it doesn’t automatically refresh when you add new data or change the existing data. Since your Pivot Table is created using the Pivot Cache, when the existing data changes or when you add new rows/columns to the data, the Pivot Cache does not update itself automatically, and hence, …
If you want to summarize a big dataset in Excel, like getting total sales by region or finding your top customers, a Pivot Table can do it in a few clicks, and you don’t need a single formula. It’s one of the most powerful features in Excel (no kidding). And the best part is that …
Often, there are two types of percentages that one needs to calculate in Excel. In this tutorial, I will show you the formula to calculate percentages in Excel as well as to format the cell so that the numbers show up as percentages (and not decimals). So let’s get started! Calculating Percentage as a Proportion …
©trumpexcel.com – Free Online Excel Training
