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)

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:

  1. Take a screenshot that includes the Google copyright © information at the bottom of the map, or
  2. If you are going to crop out the bottom of the map, you need to include the text that would have been included at the bottom, exactly as Google had it. Eg. “Map data ©2013 Google” (see screenshot below)

    darwin-screenshot

screenshot

Taking the screenshot itself will vary depending on the operating system you are using. Some common examples are described below.

Windows 8

Windows 8 adds a much easier way to take screenshots. Instead of having to use the Print Screen button and then paste into Paint (or a similar application), you can now automatically save a screenshot to the Pictures folder as a png with just the touch of a couple of buttons. Here’s how.

  1. Set up the screen exactly as you want it to appear in the screenshot.
  2. Hold down the Windows Key and Print Screen.
  3. You’ll find a new screenshot in the Pictures folder in your Library.

Windows XP & Windows 7

  1. To take a screen shot and save it as a picture Click the window you want to capture. Press Alt+Print Screen by holding down the Alt key and then pressing the Print Screen key.The Print Screen key is near the upper-right corner of your keyboard. (Depending on the type of keyboard you have, the exact key names on your keyboard may vary slightly.)

    Note: You can take a screen shot of your entire desktop rather than just a single window by pressing the Print Screen key without holding down the Alt key.

  2. Click Start, click Accessories, and then click Paint.
  3. In the Paint window, click Edit, and then click Paste.
  4. When the image appears in the Paint window, click File, and then click Save As.
  5. In the Save As dialog box, in the File name box, type a name for the screen shot, and then click Save. You can now print or email the saved screen shot just like you would any other picture.

Macs – OS X

There are a number of keyboard shortcuts to taking screenshots on Macs, depending on whether you wish to take the whole screen, a window, or a particular area. These are:

  • Command-Shift-3: Take a screenshot of the screen, and save it as a file on the desktop
  • Command-Shift-4, then select an area: Take a screenshot of an area and save it as a file on the desktop
  • Command-Shift-4, then space, then click a window: Take a screenshot of a window and save it as a file on the desktop
  • Command-Control-Shift-3: Take a screenshot of the screen, and save it to the clipboard
  • Command-Control-Shift-4, then select an area: Take a screenshot of an area and save it to the clipboard
  • Command-Control-Shift-4, then space, then click a window: Take a screenshot of a window and save it to the clipboard

Once you have a screenshot, you can then insert it as an image in your document.

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

Hide Zero Values in LibreOffice Calc and Excel

excel-accounting

Sometimes you don’t want the zero values to show in your spreadsheet. Different Office programs can handle this in different ways. Below are some examples. Do you have any way that you remove zeros from your spreadsheets? If so, please feel free to contribute in the comments section below. OpenOffice / LibreOffice OpenOffice / LibreOffice [...]

[Continue reading…]