If you have a calculated field in your Excel Pivot Table then you may well come across the dreaded #DIV/0! error, which just means that you are attemping to divide a number by zero. To avoid the...
Tag: Excel Tips
Hello, Excellers. Welcome back to another blog post in my Excel tips series. Today's topic will show you how to re-order an Excel data series. When you create a chart in Excel, you may need to change...
How To Display a Plus + Sign On Positive Numbers With Custom Formatting In Excel
Most Excel users would be used to working with the concept of displaying negative numbers in a worksheet with a preceding - sign in front of the number, something a bit like this below, where I have...
In Excel (and other Office Documents) did you know you can mark your workbook as Final?. If you have finished work on your workbook, you can discourage any further editing by users by using this...
Excel Charting Tip -How To Create a High Low Close Chart but not for Stocks!
I do not see these charts being used much - except for stock market ones but high low close charts are really useful where you have three data series like high, low and average data to show. The...
Excel Tip- How To Make cell value formatting stick in a Pivot Table
I have seen this a lot with Pivot tables, the frustration of Excel users when they format their data in a Pivot Table, but they hit refresh or they remove and add back data into the calculations area...