Switching Rows and Columns in a PivotChart
Switching between rows and columns in a normal chart is easy via a button on the Design tab. But how do you do it with a PivotChart? (more…)
Excel has Icons
If you have the subscription version of Excel, check out the Insert tab – you have Icons! (more…)
Free Excel Webinar Recording – Custom Number Formats
In April 2019 I demonstrated many of Excel's Custom Number Formats. CPD note - if you are claiming CPD for watching this recording you need to keep your own records. People who attend the live sessions receive an annual listing of attendances. Download Webinar Materials https://vimeo.com/330698381 In this brand new webinar we examine Custom Number Formats which hide away at the bottom of the Number Format tab. These custom made formats offer some useful techniques. They can display negatives in…
Selecting the same cell in all the sheets
Let’s say you want the active cell to be A1 in all the sheets in a file before you save the file. There is an easy and quick way to do it. It doesn’t matter how many sheets are involved, but it does come with a warning. (more…)
Automate Input Cell Colour
It is best practice in Excel to have a consistent colour for input cells so that users know where they can and need to make changes. You can automate this process by using a Conditional Format. (more…)
Excel, Subtraction and Accuracy
It’s not mentioned a lot, but some of Excel’s subtraction calculations are not exact. When you look at them at 15 decimal points they are slightly out. Most times this make no measurable difference to the result. But sometimes when you round, it does. (more…)