How to Print Extra Large Posters on Your Regular Printer

Submitted by schwarz on December 14, 2015 - 11:19am

When you want to make a large poster on your regular printer, try the free online service Block Posters. You can upload a graphic, then divide it into 8" x 12" chunks for printing. Print out each section and put them together on a poster board to make your own poster.

Note: if you've created your poster in Publisher, you'll want to follow these steps to save your document as an image first. Here's how:

Conversation View in Outlook 365

Submitted by schwarz on June 15, 2015 - 9:45am

If you don't like having Outlook 365 cluster email messages & their replies — but would rather see each email message on its own — here's how you can fix your view of email threads.

The screenshot below shows a set of email messages posted to the WisPubLib listserv as seen in Outlook 365, with Conversation View turned on (which is the default setting). I've circled in majenta (2) and red (4) the numbers that indicate there's multiple messages grouped together because they have the same subject line:

Transitioning to Office 365

Submitted by schwarz on May 15, 2015 - 5:11pm

The upgrade to Office 365 is nearly complete; Pete and Jody are contacting Winnefox libraries to coordinate the process before a library's staff are moved to the new system.

What does this mean to you?

3 Minutes to a Better Spreadsheet

Submitted by schwarz on December 15, 2014 - 9:01am

Learn how your Excel 2010 worksheets' data can be understandable at a glance by applying conditional formatting to cells. See how easy it is by reading the quick-start step-by-step instructions or take 3 minutes to watch this tutorial video to learn how you can improve your next spreadsheet:

That One Keyboard Shortcut That Will Save You Time

Submitted by schwarz on June 26, 2014 - 1:29pm

This keyboard shortcut has saved me lots of time when working with long documents and large spreadsheets:

Instead of scrolling down to hunt for the end of the text or the last spreadsheet cell, just press the Ctrl and End keys to quickly get to the bottom of the document.

How to Choose the Right Chart to Tell Your Story

Submitted by schwarz on June 13, 2014 - 10:28am

image credit: crackerjack_777 via Flickr When you have a spreadsheet that's chock full of numbers and statistics that's hard for your audience to interpret, you can have Excel create a chart from your data to better convey the meaning behind the numbers.

But what kind of chart should you choose? Which one will work best with the data you've got?

Drawing the Line (in Word)

Submitted by schwarz on May 14, 2014 - 12:53pm

You can create a dividing line across a page of your Word document with just a few keystrokes:

Type three consecutive hyphens --- and press the Enter key to get a normal line.
Type three underscores ___ and press the Enter key, and you'll get a bold line.
And if you type three equal signs === and press the Enter key, you'll get a double line.

How to Tame That Excel Spreadsheet & Print it on a Single Page

Submitted by schwarz on May 13, 2014 - 12:53pm

Printing from Excel can be frustrating if your spreadsheet is too wide or too tall to fit on a single page. If those last few columns or rows print on a second page, it makes the info harder to digest.

One option is to use the "Fit Sheet on One Page" command from the scaling drop-down menu to shrink the page — but that can make your spreadsheet way too small to read.

Instead, watch this 3-minute video to see Mary Sanseverino demonstrate a different way to print your large-ish spreadsheet on a single page:

How to Compare Spreadsheets Side by Side

Submitted by schwarz on March 28, 2014 - 5:38pm

When you need to compare data on two spreadsheets, here's a handy way to do it:

Open both spreadsheets
Make sure Excel's ribbon is maximized and visible; if it isn't, press the Ctrl and F1 keys to expand it
Click the View tab on the ribbon

Let Hemingway Proofread Your Documents

Submitted by schwarz on March 26, 2014 - 8:55am

Don't have the luxury of having someone proofread what you write? Try Hemingway, a free tool that helps clarify your writing by analyzing the text for the number of ...

sentences that are hard to read
sentences that are very hard to read
adverbs (aim for 2 or fewer)
words or phrases than can be simpler
uses of passive voice (aim for 2 or fewer)

... and totals these up to assign a grade level and overall readability score.

The Ides

Office