Quickly See All the Formulas in Excel with This Shortcut

I've been flat out so haven't updated this in a while - apologies to those who've used it as a resource. I came across this today, which has been timely as I needed some help with a pesky spreadsheet. Something wrong with some numbers in that spreadsheet? Lifehacker has a shortcut that displays all the formulas in the sheet at once. Check out Lifehacker... … [Read more...]

Integrating Google Maps in your documents (taking screenshots)

A friend of mine recently asked how can he integrate a Google Map into his document. The easiest way to do this is using a screen shot, however it is important to note that if you are going to use a map from Google, you need to attribute it. According to my reading of this page on Google Permissions, and this page on Attribution the easiest way to do this is to: Take a screenshot that includes … [Read more...]

How to Extract Media from PowerPoint Files (works for both Windows and Mac)

Lately I've been receiving a number of files in pptx format, but I present using my iPad and so convert these presentations to Keynote. If the slides contain images and text only, this conversion is relatively painless - usually there are just a few formatting and alignment issues that need to be addressed and then I'm good to go. All I need do is open the pptx file in keynote, either on my Mac or … [Read more...]

Matching Colours in Microsoft Office [Powerpoint, Word & Excel]

I got a call from DH yesterday saying that all his greens didn't match in his presentation, and could I help him out? "Easy, peasy," said I. :) Here's how you do it! In this case I was working in Powerpoint, and needed to get to where you can format the background colour of the items that needed changing. Usually to do this I right-click or Control-click (Mac) on the item (in the example … [Read more...]

Read ODS, ODT & ODP Files on your iPhone or iPad

I always struggle with opening OpenOffice.org open format documents on my iPhone - Apple doesn't have this as a standard format that other applications can use. I don't know of any applications that can edit Open Document Format files, however recently I downloaded the IBM Lotus Symphony Viewer. This works a treat in at least allowing me to view the data inside, which is certainly better than … [Read more...]

5 Tips for Office Productivity [from my Weekend Reading]

Once again I caught up on my reading of blogs and linked tweets over the weekend (geez, I love Flipboard!) and I've noted these ones for tackling any office software (Microsoft, Apple or Open Source) related projects. From installing fonts, creating pivot tables and syncing documents with Google Docs... check it out! … [Read more...]

6 Tips for Microsoft Word [from my Weekend Reading]

Over the weekend I was doing some reading, and I noticed that I had flagged the following tips for use in Microsoft Word. I hope they're of use to you! Use F3 To Change An Entire Sentence To Uppercase, Lowercase, or BLOCK LETTERS What’s the quickest way to change an entire sentence to Uppercase, lowercase, or BLOCK LETTERS? 10 Ways to recover a corrupted Word document It sucks when docs … [Read more...]

OpenOffice.org, LibreOffice & NeoOffice on Mac Lion OSX – Part 2

Note: For those that don't have a Mac, we'll be back to regular programming shortly. :) On Thursday I did a quick take on what my experience was on OpenOffice.org, LibreOffice and NeoOffice after installing Mac OSX Lion. There is a website that can assist you in identifying programs that work with Lion OSX - including our favourites! … [Read more...]

OpenOffice.org, LibreOffice & NeoOffice on Mac Lion OSX

Today I decided to bite the bullet and install the new Lion OSX on my Macs. So far so good, however when you do the upgrade and if you use an Open Source Office software product, I suggest that you immediately open them after the installation of Lion and go through any recommended upgrades. … [Read more...]

What is line spacing and how can you set it? [Writer, Word & Pages]

A fair definition of line spacing comes from Microsoft: Line spacing determines the amount of vertical space between lines of text in a paragraph. By default, lines are single-spaced, meaning that the spacing accommodates the largest font in that line, plus a small amount of extra space. If a line contains a large text character or graphic, Publisher increases the spacing for that line. To … [Read more...]