Power What??? Do you spend a lot of time building dashboards and reports in Excel?. Do they take a lot of time and effort to repeat the same task over and over again? If your answer is yes then it...
Posts by Barbara
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...
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...
Add A Company Logo To All Excel Worksheets- (so it prints on all pages)
I am sure you aware of headers and footers if you are a user of MS Office. It really is the best way to ensure that either an object or text appear on every page when printing. Here is how to...
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...