Adding a background image to a worksheet or workbook can really spice up a presentation where graphs and charts, let face it, can get a little monotonous. These background images will really set...
Tag: Excel Tips
If you find you use the same set of multiple workbooks for the one task or project ( as I often do), then it can be time consuming to constantly have to open each of the workbooks individually....
Typically most people create charts with one style such as a column chart, a line chart, or a pie chart. If my chart has more than one data series for example monthly targets and actual monthly...
I received an Excel file today from one of my colleagues that contained carriage returns at the end of each line of text, these were displayed as small boxes. They were having trouble splitting out...
I had a question form one of my colleagues about this. They have a validation list of products which has been used using for some time, with no new products being added. Then today- they are...
Data Validation- Setting Up Lists To Control User Data Entry
Sometimes you really want to control what people type into Excel, especially if you need to do some analysis on the data at a later date, so all the input are uniform and easy to analyse. There are...