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...
Tag: Excel
Yes that's right, you can create not just a quick chart but a super quick chart in excel with just one click of a key. Select your data Hit the F11 button Bang!! that's it. One quick...
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...
The mouse pointer in Excel will take on different shapes depending where it is on the sheet, and each pointer type relates to a particular action. Selecting cells is Excel is one of most common...
Performing calculations is one of the main uses of spreadsheets and Excel allows you to build quite complex formulae using arithmetic operators, but it also has a myriad of predefined functions for...