Our economy has been hard hit and we’ve got less spare time than ever before. So in this business climate it’s a natural reaction to cut costs, and we should. For small businesses the training budget will be one of the first to go since it’s seen as an overhead, but for corporate organisations training [...]
March 2011
You’re not likely to hear about Excel’s Camera tool on a training course and you certainly won’t find it on the ribbon. It is one of those insider tips that are hidden away in the toolbar options. What is Excel’s Camera Tool The camera tool takes a snapshot of a range of cells from somewhere [...]
In my last tutorial I showed you Excel’s T function, today we’re looking at the other one-letter function in Excel; the N function. Funnily enough the N function was only provided for compatibility with other spreadsheet programs, but it does have one handy use if compatibility is not your raison d’etre. The syntax is: =N(value) [...]
Did you know there are only two functions in Excel that consist of one character? They are the T function and the N function. Both are simple and very handy. In this tutorial we’re covering the T function and I’ll show you a few different uses for it. And just like Excel’s T function, this [...]
Often data imported into Excel from another system isn’t quite in the format we want. Text can be split across columns, for example; the telephone area code below is in column A and the remainder of the number in column B. Here you can use the CONCATENATE formula to merge cells together into one cell, [...]
... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses
