Tag Archives: Tip

Fixing an annoyance in Outlook 2010

The scenario:

You like to flag your mail for Follow Up on a specific day. But Outlook always defaults to setting the reminder at the end of the day. Can this be changed to the beginning of the day?

It makes sense that if you want a reminder set for Today, that the default time for that flag is set to one hour before the end of your work day (as defined in your Calendar settings).

It makes sense that flagging a reminder for one of the pre-defined future dates (Tomorrow, This Week or Next Week) uses the start of your work day as the default time.

It makes NO SENSE that flagging a Custom date reminder reverts the default time to one hour before the end of the work day.

To change this default to the start of your work day.

Finding the Quick Click menu
Finding the Quick Click menu

Click on the drop-down arrow on the Follow Up button on the Home Ribbon.

Select Quick Click

The Quick Click dialog box
The Quick Click dialog

The Set Quick Click dialog appears. Choose Tomorrow as the default. Click the OK button.

Done. Future custom reminder times will now default to the start of the work day – not the end.

 

 

 

 

Google Timer and Stopwatch

Do you wish that you had a timer on your desktop just like the one on your smartphone?

Just type “timer 5 minutes” (or 3 minutes or 10 or whatever) into your Google search bar. A timer will appear. You can maximize it to fill the screen and there will be an audible beep (which you can mute) at the end of the timer.

You’ll notice a Stopwatch panel on the screen too. To get to the stopwatch directly, type “stopwatch” (unsurprisingly) in the Google search bar.

 

Social Media tips – free photo resources

  • Library and Archives Canada –Image Search
  • New York Public Library  – Search Page
  • The Rijkmuseum in Amerstdam has digitized its collection. All of its works are free to use. Its’ policy “If you use our images for publication, then we request that you acknowledge the source (Rijksmuseum, Amsterdam). We would also like to receive a copy of the publication for our library.”
  • Try the Creative Commons search tool.
  • This post from Hootsuite offers a list of 20 different Free Stock Photo websites. The one I like the best is Pexels, which is where I found this posts’ featured image.
  • University of Alberta Peel Image search.

PowerPoint: Save a Slide as a JPG

Do you like those inspiring combinations of words and pictures you see on many social media sites?

Photo courtesy of National Archives of Canada. Children Reading Art books 1931-1959. Superimposed quote "There are many little ways to enlarge your child's world. Love oa books is hte best of all. - Jacqueline Kennedy Onassis"
Photo courtesy of National Archives of Canada. Children Reading Art books 1931-1959. Quote courtesy of ebookfriendly.com

You can use PowerPoint to combine pictures and words and then use the Save As command. Select the JPG type.  Perfect for  uploading to your social media feeds. Here’s a  link to the PowerPoint template  sized for Twitter pictures I used to create the above  sized for Twitter pictures I used to create the picture above. You are welcome to download and use it.

Also, here’s a link to the image search page at the Library and Archives Canada.  And for my fellow book nerds – quotes about reading.

 

Excel: Select Visible (1)

I built my Social Media spreadsheet in an Excel spreadsheet with all the tools I want built in (formulas, conditional formatting and data validation). Ultimately, I will transfer my information into a stripped down spreadsheet in csv (comma separated) format. This is the format that Google Calendars will accept.

When I transfer my posts to this spreadsheet, I don’t want to include any blank rows AND I only want to copy and paste once. How do I perform this little piece of magic? I use the Excel command for selecting visible cells only.

Go To Special Dialog, select Visible cells only
Go To Special Dialog, select Visible cells only

Tucked away in the Go To Special dialog is the option for selecting only the visible cells in a region. This takes what could be multiple copy/paste operations and condenses them into one step.

First filter your data so that blanks do not appear, then press the F5 function key to bring up the Go To dialog box.

GoTo Dialog - Special Button
GoTo Dialog – Special Button

Press the Special button to open the Go To Special dialog box, choose Visible cells only and press OK. Now when you copy the selected cells, only the cells you can see are copied.

In my next post I’ll show the method to put this useful button on your Quick Access Toolbar.