I download a lot of data form various sources, so the quality and formatting of it can vary significantly. One issue that occurs a lot of the time is a date field being formatted as text. It...
Posts by Barbara
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...
Until you know this setting in Excel, it is difficult to see how you can have great looking static images on your Excel sheets. Being able to lock down your images on a dashboarrd for example to...
It can be really frustrating if you have set up your VLOOKUP formula, all is working great and then you have to manually adjust the formula if you want to copy it across multiple columns. See my...
Formula Friday -Using The Workday Function To Calculate Status Of An SLA
I dont know about you, but our IT department at work has an SLA turnaround time of 8 days. That is 8 working days, so we can't really chase them for any updates until that time has elasped. ...