I have recently become a book addict. For anyone who knows me well, you can pick yourself up off the floor now – I hardly ever read books unless the subject involves Manchester United (although I did once pick up John Grisham’s The Firm and couldn’t put it down).
This morning one of my colleagues asked what time it was in a certain part of the world. I typed the name of the place followed by “Current Time” into the Google search box. Google responded by displaying the current time for that location above it’s normal results list.
Absolute cell references allow you to “fix” part or all of a cell reference in a formula. This can be a great time-saver when copying formulas, however, there is more to it than meets the eye…
The MOD function in Excel returns the remainder after a number is divided by a divisor. As an example, start a new spreadsheet and enter 172 into A1. This represents the number of minutes that a piece of machinery has been running (this figure is manually entered after the user has noted the value by [...]
I was recently presented with an Excel file which displayed a message every time it was opened indicating that it contained links to other files. I was assured by the owner of this spreadsheet that all links had been removed. Thanks to officearticles.com for helping me to solve the problem: Open the file with the [...]
In Word, selecting some text and pressing Shift+F3 will change the case of the selected text. It works on a cycle through the following – lower case , CAPITALS or Sentence Case. Excel does not have this feature but you can select a cell and use =UPPER, =LOWER or =PROPER. The format is =FUNCTION (CELL) [...]
Last year I wrote found a piece of VBA code (well I did find it but then adapted it so back to my original comment – I wrote a piece of VBA code) that split a Word mail merge output document (i.e. the one that is produced as a result of running a mail merge) [...]