Sometimes when you import text from another source it may not be formatted in the case you want. For example it may be ALL IN CAPITALS, all lower case, or a combination of the two. There are a few functions in Excel that we can use to quickly fix the formatting of text, namely UPPER, [...]
May 2011
I often create Excel workbooks that contain a series of sheets for each region (or product, month, or sales person) with a summary sheet at the front that gives me a total of all the sheets. But building workbooks like this can be onerous so I’d like to share with you a few tips for [...]
In Australia we did away with 1 and 2 cent coins years ago. So all prices, where paid in cash, are rounded down to the nearest value divisible by 5 cents. In Excel we can use the FLOOR function to calculate this value. For example: Say our price is $4.32 and we need to round [...]
... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses
