Absolute Cell References in Excel
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…
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…
Suggested to a client that they buy a Mac. Well, he’d already decided that his next laptop will be a Mac, so I can’t really count that as a sale – but at least it confirmed it in his mind.
A question arose today about entering random text into a Word document. You probably know that if you type =Rand() into a Word document you get 3 paragraphs each containing 5 sentences where each sentence is “The quick brown fox jumps over the lazy dog” And if you type =Rand(X,Y) where X and Y are [...]
This was the top story in my RSS feed this morning. As someone who works for IBM and has spent the past 12 months trying to convert my colleagues to the Mac, I just had to smile at this one! IBM’s Research Information Services division is investigating the possibility of moving a significant number of [...]
Tonight I attended an online presentation which was run by the North West Adobe User Group. The excellent presentation covered 2 subjects – Adobe Acrobat Connect (an online collaboration and web conferencing tool) and Photoshop Express – a free online image editor (you also get 2GB of space to store your photos online when you [...]
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 [...]
When using Outlook with MS Exchange, you can open another user’s mailbox (providing that they have assigned permissions correctly). This is useful if you want to check whether a colleague is available..or you just want to snoop at an ex-colleague’s whereabouts! However, Outlook remembers the names of the previous few users whose mailboxes you have [...]
Unfortunately at work I am limited as to the software I can use. I occasionally have the need to work with photos and if I’m lucky I may find that the PC I’m using has Paint Shop Pro installed but more often that not I’m reduced to using Microsoft Photo Editor. There’s a known issue [...]
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) [...]