Removing Duplicate Entries in Excel

Say, for example, you had a program sign up and now have a spreadsheet with a list of people to subscribe to an email list but first you want to make sure you're not trying to subscribe the same address more than once.  Sure, you could sort the list by email address then manually pick out and delete the duplicates.  You could even use Conditional Formatting to highlight the duplicate entries to make them easy to find first.  Or you can use the Remove Duplicates function and get rid of them in just a few clicks.

Before you do this, a word of caution.  Removing the duplicates will change how many rows display.  It will either shorten the column you selected making it not line up with other columns in the spreadsheet or it can delete the entire row if you have all columns selected.  Depending on what you need, you may want to copy the data you want de-duplicated to another worksheet.

  1. Select the column where you'd like to remove the duplicates.
  2. Click on the Data tab
  3. Click on the Remove Duplicates column.
  4. If you have other information in the spreadsheet that's not selected, you will get a "Remove Duplicates Warning" pop-up box asking if you want to expand the selection or continue with the current selection.
    1. If you only want to remove data in the selected column, choose "Continue with the current selection and click on "Remove Duplicates".
    2. If you want to remove data from all columns, choose "Expand the selection" and click on "Remove Duplicates".
  5. The "Remove Duplicates" window will open.  There will be a list of the columns and a checkbox in front indicating which columns you'd like to use to compare for duplicate entries.
    1. If you've selected a single column, there should be a checkmark in the box in front of your column (or column name if your data has headers) and you can just hit "OK".
    2. If you've selected multiple columns, choose which columns need to be duplicated for the entry to be removed and click "OK".  For example, if you had a spreadsheet with the first name, last name and email address in separate columns and wanted to remove any entries for the same person, you'd need to have a checkmark in front of all three columns.  That way only an entry with all three the same would be removed.  If you just used the last name and email columns, you could delete other family members using that email address. 
  6. Another pop-up window will appear telling you how many duplicates were found and how many items remain.  Click "OK" and you'll be at your now cleaned up spreadsheet.

 

Format Painter tips

You probably already know that you can use Microsoft's Format Painter to quickly copy formatting from one bit of text in a document to another. But did you know..

  • you can double-click the Format Painter button if you want to change the format of multiple selections in your document or worksheet? (to stop formatting, press ESC)

    video(1:55)


  • you can use Format Painter to copy formats and apply them to drawing objects and pictures?

    video (selection is < 1min)

"Modules Unraveled" Drupal training videos now free


flickr photo shared by cogdogblog under a Creative Commons ( BY ) license

When librarians ask about advanced Drupal training resources, from now on I'll mention the training videos from Modules Unraveled. Modules Unraveled recently changed to an ad-sponsored model, making its high-quality tutorial videos on Drupal modules free. (In the past the site was subscription-based, and that's a big barrier for many. Not anymore!)

Modules Unraveled provides intermediate to advanced coverage of select Drupal modules. You may already be using some of these modules on your library's website. For example:

  • "Calendar" powers many sites' calendars.
  • "Views" powers Calendar and almost any display that combines text and images from multiple nodes (Articles, Basic Pages, Events, etc.) into one page or block.
  • "Views Slideshow" powers image slideshows (aka carousels).
  • "Quicktabs" produces tabbed blocks for combined Search LINKcat/Search this website.

Beginner documentation for SCLS's version of these features shows how to use some of them, but falls far short of explaining how to tweak or significantly alter how they work. For the site maintainer who wants to do just that*, Modules Unraveled explains settings and configuration options for Calendar, Views, Views Slideshow, Quicktabs, and more—premium videos that are now available for free (in exchange for watching a 15-second ad).

* Contact me if you need extra permission to tinker with your SCLS-hosted Drupal site.

3 min of Google searching goodness

Have 3 minutes for a little Google searching goodness? Learn how to use Google's site: operator to find pages on hard-to-search sites, and how to narrow your searches to a specific period of time.

Maker Camp!

I just attended ALA annual and the exhibits had an entire section devoted to all things "maker ". It was quite a different to see gizmos and gadgets all designed to provide an interactive experience for library patrons.

One thing that caught my eye in particular, was Maker Camp--makercamp.com.

Maker Camp is a "free summer camp for building, tinkering, and exploring. Online and in your neighborhood."  Kids can sign up for free and participate online or--if there is a physical camp in their area--in person. Several Wisconsin libraries are participating. Organizations can sign up to be a site, but they would need to hurry as camp begins on July 6.

And don't forget, SCLS has an inventory of Mobile Maker Kits that libraries can use for programming, which can be reserved online here.

Ignore Feature in Office 365

Have you ever received an email with subject matter that doesn't pertain to your job?  You can simply delete it if you don't want it cluttering your inbox.  What do you do if several people reply to the original email and it quickly turns into a long email conversation?  You can delete all the replies, or you can use the Office 365 Ignore feature.

To ignore an email conversation, just right-click the email in your inbox and select Ignore.  The message below will appear.  Check the box and click OK.

Ignore
All existing and subsequent responses to the conversation, will go directly to the trash.

You can "undo" the ignore if the conversation is still in the Deleted Items folder.  Open the Deleted Items folder, locate the email conversation, right-click it and select Stop Ignoring.

Osmo in a library setting

Guest post by Andy Barnett, director of the McMillan Memorial Library in Wisconsin Rapids.
--------------------------

We saw Osmo software on an iPad and were impressed with it. It is hard to top as an example of the gamification of education and some elements are amazing. We are promoting it as we transition to a more interactive Youth Services space.

The software kit ($80) includes a stand and mirror, as well as pieces for four different games. This is a great price if you have an underused iPad around and even if you don’t. The iPad uses the mirror to recognize what is happening in front of it.

  • Newton involves redirecting balls dropping from the top of the screen to hit and destroy targets. You can use your hand, a pencil or a line on a sheet of paper to redirect the balls.
  • Masterpiece. Select an image or convert a photograph into a line drawing. Put a piece of paper in front of the Osmo and paper with the image superimposed appears on the screen. You can then trace the image on the paper, building eye/hand coordination.
  • Word consists of several games, all involving finding the right letters to describe the image displayed. At easy levels, it is just the first letter of a word. At higher levels, it’s the whole word. Can be played solo or against another person.
  • Tangrams uses the traditional shapes, but recognizes when you have a piece in the right place. Easy levels show the colors and outlines of the pieces, but higher levels don’t provide clues.

McMillan Library's OSMO stationMcMillan has them out for public use, secured by a cable and with most apps restricted. The tangrams and letter sets must be checked out, but kids are free to sit down and start playing.

--------------------------
Additional resources:
Review of OSMO by a blogger who borrowed it from the library - http://readingbyexample.com/2015/05/09/beyond-the-screen-osmo-for-the-ipad/

Tablets & Weeding

Kitchen-garden-788629_1280I recently spent a couple days helping Cambridge Community Library weed their adult fiction collection in anticipation of the move to their new building - woo hoo! Weeding is not an easy job but it is a necessary one - especially if we want our collections to look like this nicely weeded and arranged garden.

Here are a few tools to help you with your next weeding project.

First, if you haven't heard of the Awful Library Books blog, I highly recommend it. In addition to highlighting books that should be weeded from collections and why, Holly and Mary write articles about the weeding process. I think many of you will agree with the concepts in this May 9 article, "Weeding: It Ain't Easy."

Second, take advantage of the reports and data (password required) from Koha (or your Integrated Library System). And, don't forget the collection development items in the SCLS Professional Collection. Titles like Fiction Core Collection, Public Library Core Collection, Best Books for Children (series), and others that will help with both selection and weeding.

Scanner2And, last, but not least - use the technology available to you to make this process easier. With the web-based nature of Koha, it was easy to take my iPad along with me in the stacks. Set it up on the cart, log into Koha, and weed away. There's also this pretty cool scanner that Craig wrote about in January of 2014. I tested the bluetooth scanner with Koha on my iPad, the Kindle Fire, and the Samsung Galaxy and it worked great for searching the catalog. Want to use it? Use the new Help Desk Portal and request to schedule the Mobile Circ Kit. If possible, please include the dates that you'd like to use the kit. While I couldn't test the scanner with all our member library catalogs, all SCLS libraries are welcome to use the kit.

P.S. I'm working on scheduling Holly and Mary from the Awful Library Books blog for a webinar later this fall.

Unsend with Gmail

Gmail now offers an 'unsend' option but you have to perform a tweak first.

UndoSend

Library Freedom Project Holding Privacy Workshop after ALA

Library-freedom-project11

If you're attending ALA and are still in town the following Monday and Tuesday you may consider attending Library Freedom Project's Digital Rights in Libraries workshop being held at Noisebridge. The workshop will provide tools and training to assist privacy-minded individuals (staff and patrons) with their digital presence.