Quickly See All the Formulas in Excel with This Shortcut

20131108-083027.jpgI’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...

Making Search Relevant and Recent (Getting Help that Helps!)

Often, when people search for information on the web, they put search terms into Google and click search. This is especially relevant to searching for solutions to software problems as you want the solution to apply to the version of software that you currently have (if you have the most up-to-date version).

Unfortunately, this general search method gives you a very large selection of web pages as a result, and not all of these will be relevant to your search term, or your software.

Now I’m not going to teach you how to refine your search term. There are a number of websites that do this really well, and I’ve listed some of these at the end of this post. However when dealing with software, often you want to have the latest information that is out there, and that can be done on google with a very simple tweak.

Go to Google and enter in your search terms. On the resulting search, immediately under the search box, you should see the option to click on ‘Search tools’. You then:

(1) Click on ‘Search tools’, then

(2) Click on ‘Any time’, and then

(3) Select the time for which you want to limit the search. Eg. ‘Past month’ or ‘Past year’.
When looking for solutions for software problems, I usually select ‘Past year’ as I am after solutions for software versions that were released within the last year.

google-search.png

Now if you want to refine your search terms further, try these tutorials and tips:

Integrating Google Maps in your documents (taking screenshots)

screenshot

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 […]

[Continue reading…]

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

rename-zip

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 […]

[Continue reading…]

FAQ: How to I change the default language in Word for Mac? [Word 2011]

language-menu

With Office 2011 for Mac, you can check spelling and grammar in languages other than English. Word 2011 for Mac comes with foreign-language dictionaries such as Czech, French, Russian, and you can also change the ‘brand’ of English (UK, US, Australian). The default dictionary determines which language’s proofing tools Word uses for spelling and grammar. […]

[Continue reading…]

FAQ: How to Show Column A in LibreOffice Calc

I recently had a comment in response to FAQ: How to hide columns in OpenOffice.org Calc [Show / Hide] and decided to answer it with a video. It details two methods: A method in which you can show (unhide) all columns (this can be applied to rows), and  A method for unhiding column A alone  

[Continue reading…]

Changing case in Pages (iWork for Mac)

change-case-nac

For my OpenOffice fans, my apologies for not posting on OOo or LibreOffice for a while, however I have been working in Pages for Mac recently. Just a quick tip as much for my own reference as for anyone else’s – for some reason I keep losing this reference. Changing the case of letters in […]

[Continue reading…]

Quick tip: Changing Spelling on a Single Document in Pages (for Mac)

spelling-pages

To change the spelling for a document in Pages, select the text you wish to use (CMD-A if all text in the document). Then open the inspector, click on the ‘T’ for text. Then click on ‘More’ Then under the heading ‘Language’ select the dictionary you wish to use (see screen shot)

[Continue reading…]

Update notifications for OpenOffice.org 3.3.0 Installations [from Rob @ Apache]

2012_to_Present_Apache_OpenOffice_Project_Logo

I received this in my email this morning. Get your Upgrade! We have enabled the upgrade notification server for OpenOffice.org 3.3.0.  By default OOo 3.3.0 checks for updates once a week.  When an upgrade is available, a dialog pops up and notifies the user about the update, and directs them to a website where they can learn more […]

[Continue reading…]

LibreOffice Portable Apps v 3.5.4 released

libreoffice

On June 1, 2012, PortableApps.com and The Document Foundation announced the release of LibreOffice Portable 3.5.4. LibreOffice Portable is a full-featured office suite — including a word processor, spreadsheet, presentation tool, drawing package and database — packaged as a portable app, so you can take all your documents and office suite wherever you go. This release […]

[Continue reading…]