Chrome Doesn't Trust Your Website Anymore, How to Still Get to It

Recently, Google has released a new version of Chrome that no longer trusts certain secure websites in a move to encourage those sites to switch to a different, more secure, security system.  That's all well and good, except that about 80-85% of the World Wide Web still uses the old, but still good, system to secure people's connections to their websites.

When encountering these sites, you may now be presented with screens that look something like this:

Insecure site

Looks scary, right? However, receiving this message doesn't necessarily mean that you shouldn't trust the site. Also, it may not look obvious, but you can still reach the site you're trying to get to by clicking the "Advanced" link in the bottom-left, then clicking "Proceed to <website name>..."

I can't tell you which websites you can and can't trust. Every time you browse the internet there's a little bit of risk involved. Simply use your best judgement.

Remove Addresses from Office 365 Autocomplete

The purpose of this TechBit is to show how to remove a single contact from the Office 365 Autocomplete feature.  This procedure will become very useful when the SCLS-hosted Email Lists are retired and we switch over to a similar service provided by WiscNet. MH900229717

  1. Click New Mail.
  2. Click in the To: field.
  3. Begin typing the first few characters of the contact.  (This could be a person's email address, a person's name or a list email address.)
  4. In the resulting list, use the Up and Down arrow keys to highlight the entry you'd like to remove.
  5. Press the Delete key to remove the highlighted contact.

These instructions also appear on the Office 365 FAQ page.  The HWDSB (Hamilton-Wentworth District School Board) has a decent video that may help as well. Thanks to Kerri of SCLS for the TechBit topic idea.

Procrastination and Gmail

ElvesIf you are like me, you may be procrastinating a bit on updating your email contacts following the switch to Office 365. Remember, we are retiring the email in January and we need to notify our contacts of our new email.

I am a gmail user, so I thought I would share what I am doing to identify emails coming to my email address. 

  • I created a Label called “Old email”
  • I then created a filter that will add the “Old email” label to any email that is sent directly to my old email address.  (See directions below).
  • The emails still go to my In box and are not archived right away. I was worried that if I archived them, I would miss important emails.

(The image above is from

Here is a screen shot of my “In box” this morning.

In box

Here is what I do:

  • Spam. Much of what is currently going to my old email are spam emails (Ringing In Ears, Leading Edge Alzheimer’s). I can just delete those.
  • Vendors. There are emails from vendors (ProQuest, FireEye, Spiceworks). Do I want to stay on their list? I can’t decide yet, so I archive these.
  • People. Most of the people I deal with on a regular basis are already using my new email address, but if someone isn’t, I reply directly and let them know of my new address.
  • Misc. Others I am not sure about. I get the Oprah’s Book Club 2.0 email from way back in the old days when I used to update the LINKcat Best Sellers list. I don’t need this anymore, but do I want it? Is it worth re-subscribing? I can’t decide yet, so I archive it.
  • Email lists.  The one thing this filter does not seem to catch is my subscriptions to email lists. I need to apply the Old email label to these and then I archive them so that I can follow up on them later. I have created a spreadsheet to track which ones I have updated.

Remember to Resolve The Archived Emails

Once you have archived your emails to fix, you can’t just forget about them! Here is a snapshot of my Old Emails folder.

  Old email

I have some work to do. Hmmm. It looks like I have not updated my TechBits subscription. Uh oh.

Creating a Filter

  • Go to Settings/Filters/Create a new filter
  • On the first screen, put your old email address in the To box.


  • Click <Create filter with this search>
  • On the next screen, check the Apply label box and select your “Old email” filter.
  • Click <Create filter>




More library tech blogs

CircuitheartA few years ago, I shared 6 Library Tech Blogs I Love. There are so many good ones, I'd like to share a few more blogs and sites I read regularly:

Wisconsin library system blogs

  1. Library Sparks (Winnefox) - Where The Ides has a tech focus (and a recipe archive!), Library Sparks includes ideas from around the system & around the country, on programming, fundraising, grants, free stuff, and more.
  2. NicBits (NFLS) - All sorts of information from NFLS ranging from programming, notes from library tech conference sessions, news around the system, and more (This recent session summary from ARSL2014 on "Tablet Slinging Librarians" got me thinkin'!)
  3. Digital Lites (WVLS) - WVLS updates, news from libraries in our area, training opportunities, helpful tips and resources, national library news and more. (Check out their "New e-reader 'cheat sheet'!" post)
  4. WPLC (WiLS) - all the news about the Wisconsin Public Library Consortium and Wisconsin's Digital Library (OverDrive)!

Other library tech blogs

  1. David Lee King - social web, emerging trends, and libraries
  2. Digital Shift (Library Journal and School Library Journal) - all sorts of info, but my favorite section is for Library Journal Technology articles 
  3. LibraryTechTalk - A blog from librarians at Towson University which focuses on practical applications of technology in many different library areas and settings
  4. Makerspaces + Libraries - a (remember my post about topic all about library makerspaces

And finally... 

The Division for Libraries and Technology has introduced the Wisconsin Libraries Blog to replace Channel Weekly for communicating news pertaining to Wisconsin's libraries. You can sign up for email updates, or follow it using your favorite RSS reader.

Who did I miss? What should I be reading? Do you have a recommendation for a good library tech site? Please share it in the comments!

Build With Chrome

How often at your library do you see a pile of LEGO blocks poured out onto a play surface and think about what a chore it will be if you have to do clean up, or if you are the one who has to replace lost parts. Those days could be a thing of the past!

While doing some LEGO “research” I came across a site called Build with Chrome. This is a site where LEGO and Google Chrome teamed up to bring you an online environment where you can build with virtual LEGO blocks.

You don’t have to sign up for an account, but if you do you can pick out a chunk of land on Google Maps and build your own piece of paradise and have it published for the whole world to see.


Is this going to your old address?

Quick check! Was this post sent to your old email address?  (if so, you should update your TechBits subscription)

In January when the old email addresses are retired, we don't want this to be you!

Excel: Selecting or Jumping Through All or Some Data in a Column

Let’s say that you have an Excel spreadsheet with 3,349 rows, Xcel

  • do you know how to easily select data, from any point within an Excel column, to the bottom of the data in that column?
  • do you know how to jump from any point within an Excel column to the bottom of the data in that column?

Shift, End and arrow down might become your friends.

In these examples, we’ll focus on manipulating data from column ‘C’.


What if you’re interested in selecting data from C 2,000 all the way to the bottom of the data in that column, C 3,349?

  • Click on cell C 2,000
  • Hold down the Shift key
  • With the Shift key depressed, press and release the End key and then press and release the arrow down key. Voila! (This is an easy way to copy paste lots of data quickly.)

Select in Excel



What if you want to jump from the top of the column, C1, to the bottom of data in the column, C3,349?

  • Click on C1
  • Press and release End.
  • Press and release the down arrow. Voila!

Note: These examples focus on selecting data ‘down’ the column. Data can similarly be selected ‘up’ the column by using the up arrow.

Caution: These ‘tricks’ only work with contiguous data. If a cell is empty of data within a column, the final down arrow will take you to the first empty cell.

Good luck selecting and jumping!

Constantly changing Office 365

SendEmailOffice 365, the web-based email and calendar solution provided by SCLS, is frequently updated by Microsoft. On one hand, that's great. We're the lucky recipients of new features, bug fixes, and improvements with little to no work on our part. On the other hand, things are constantly changing and it's hard to keep up sometimes!

Office 365's recent upgrade brought with it new ways to manage your mailbox and shuffled some settings around. For example, when you click on the Settings gear in the upper right, the whole menu looks different, and when you go into the Options, the whole layout is rearranged! 

Here is an overview of the changes and new features and details about the new "Clutter" feature, which is designed to move low priority messages out of your Inbox and into their own folder. SCLS staff will be updating any out-of-date Office 365 documentation on our website as time permits.

The next version of Windows will bring back the start menu

I want to share some good news with everyone! The next version of Windows will bring back the start menu!  Microsoft listened to their customers and decided to bring it back.  Here is a screenshot of the preview version of Windows 10


Help patrons avoid account lockouts

Photo of some locks that are not digital

It's rough to get locked out of a Google, Yahoo, or other web mail account. Help your patrons avoid the hassle by encouraging them to set account recovery options for any web mail accounts they create and keep them up to date.

While logged into email, look under account settings for options like contact information, password-reset information, or security information. Once you find the right settings, there may be options to add mobile phone numbers and alternate email addresses (to receive a text/email message with a password reset code) or security questions (to answer if all else fails).

Remind patrons to check up on these settings from time to time. People change phone numbers, email addresses, and sometimes even security question answers.

Two-step verification is an additional login security option that Google, Microsoft, and Yahoo recommend. Turning it on for an account does strengthen security, but it can also cause difficulties if the patron does not have consistent access to a mobile phone or alternate email address. Be extra careful to add backup options for two-step verification and keep them up to date too.

Public service staff: how do you help patrons recover from account lockouts at your library?

Thanks to staff at Oregon Public Library for suggesting this topic!