Display The Details Behind Your Pivot Table Data With One Click
Ever need to drill down into your Pivot Table to look at the details behind your summary calculations? Simple stuff with the double click of a mouse and Excel will display all of the details behind...
Have you found when you try to reference a cell in a Pivot Table that Excel will sometimes automatically creates a cell reference with the prefix GETPIVOTDATA? ......even when you just want a simple...
Did you know that Excel can add a trend line to the data points in your charts?. Say we have a weight loss tracker, and we have been tracking weight loss for 4 weeks, The BLUE line is the...
If you want to add chart titles that are live or active, it is really easy to do in Excel with just a few clicks of the mouse. Create your chart as normal in Excel Select the chart title you...
A tally or a running total can be carried out on data in Excel with a range of formulas, but it is really easy to do the same thing simply, with a pivot table. Let's use an example with some random...
This tip really is a fun one for spicing up that boring chart for your presentation, some peoples charts really are snoozy, so here is how to pep yours up a little with a few clicks. First of all...