Removing duplicates in Excel, again

We've covered a couple of ways to remove duplicates from Excel before, but those methods destroyed the original data.  If you wanted to keep the original data, you needed to save a copy of it somewhere first.  There's a way to filter out the duplicates which leaves the original data in place and has you save the de-duplicated information in another location instead. 

  1. Open the file in Excel and elect the information you'd like de-duplicated.  Note: If you don't have a header on your column, Excel will complain about the missing column header.
    Selectaddresses

  2. Click on the Data tab (1) at the top of page and, in the Sort and Filter section, click on Advanced (2).
    Datafilter

  3. An Advanced Filter window will appear.  Since we're wanting to keep the original list, click on "Copy to another location" and click on the button at the right hand side of the "Copy to:" field.
    Filterwithcopy

  4. This brings up a small "Advanced Filter - Copy..." window.  Chose the column you wish to have the new list copied to and then click on the icon at the end of the field. 
    Filterlocation

  5. You'll be back at the "Advanced Filter" window.  Check the "Unique records only" box and click on OK.
    Filterwithcopy2
  6. You now have a new list with the duplicates removed but your original list is still intact.    
    Nodups

Libby App from OverDrive

LibbyOverDrive recently announced the launch of their new app for readers, Libby. If you're subscribed to the WPLC Announcements email list, you've already seen this message from Andi Coffin at WiLS:

Phase 1 will encourage brand new users to download Libby instead of the OverDrive app. While OverDrive users in other states will see this change in June, the WPLC has opted to push this back to August in order to give us time to prepare to properly support the new app. Phase 2, which will happen later in the fall, will begin to encourage existing users to switch to Libby. It is unknown at this time if or when support for the existing app will end.
 
If you are not using Libby, we encourage you or your library's OverDrive support providers to become acquainted with it. Even though the app won't be pushed to new users until later this year, it is already available for public download and there will likely be support requests for it soon. You can download Libby from the App Store or Google Play.
 
OverDrive is providing three webinars on Libby on May 31 and June 1. You can find information about those Staff Training opportunities as well as general information here: https://resources.overdrive.com/meet-libby/.
 
I downloaded Libby last week and it is pretty easy to use. As I learn more, I'll pass the information along to you. Happy reading!

Sorting lists randomly in Excel

Recently, I needed to sort a list of names in random order. Rather than manually figure out a random sort, I decided to see if Excel could do the sort for me. Guess what - it can! It's a little clunky, but it works.

  • Enter the list of names in an Excel column.
  • Select the column, right-click and choose Insert to insert a new column next to the list of names.

Tb052617-1

  • Enter the formula =RAND() into the first cell of the new column.
    • (The RAND function will generate a random number in the cell.)

Tb052617-2

  • Copy the =RAND() formula from the first cell to the rest of the cells, until you get to the end of the list of names.
    • (Click on the lower right-hand corner of the cell, and then drag the mouse down to the end of the list.)
  • You will now have a column with random numbers.

Tb052617-3

  • Select the column of random numbers.
    • (Go back to the top of the column and click on the column's letter to select the column.)
  • Go to Sort & Filter and choose Sort Smallest to Largest.

Tb052617-4

  • You will get a pop-up. Choose Expand the Selection, and click the Sort button.

Tb052617-5

  • The list of names will sort in a random order, based on the numbers that were generated by the RAND function.
    • (Note that you can repeat the Sort & Filter process to generate a new random sort.)

Tb052617-6

  • You can delete the column of numbers after you are satisfied with the name sorting. 

Change the default search engine in Microsoft Edge (Windows 10 users)

Those of you that have received a new PC within the last several months have seen that we are deploying Windows 10 PCs. With that Microsoft Edge has taken over Internet Explorer as the stock browser.  Edge uses Bing as the default search engine. Some users may not care for Bing. Users can change this default search engine to any they would like but the process is a bit different than other browsers like Chrome or Firefox. The following will explain how to change the default search engine for Microsoft Edge:

  • In Microsoft Edge, go to the website of the new, preferred search engine (exa. Google.com)
  • Select More actions > Settings, scroll down and click View advanced settings, scroll again and click Change search engine
  • Select the new search engine’s website within the list, then select Set as default
  • *Note* You must have visited the site prior to be able to see the website in the list

Why Jing?

2017-05-19_1000

Jing is a productivity tools that I have relied on for years. This free, easy to use, and powerful screencast program is useful when answering reference questions (even on chat), creating quick training videos, and developing step-by-step procedures. 

Here are my 5 favorite Jing features along with resources to get you started.

 

Favorite Jing Features:

2017-05-19_1012

1. Annotate Images: After using Jing’s Capture feature to grab an image, you can add arrows, text, frames, and highlight features.

2. Narrate Videos: With Jing’s Capture, you can create a short video (less than 5 minutes) with or without narration. If you choose to add audio, you are prompted to connect to a microphone. Pause and restart buttons make it easy to record, and re-record the video.


2017-05-19_1013

3. Retrieve and Update Content: Jing’s History feature lets you locate, select, and reuse previous Jing content.

 


2017-05-19_1013_0014. Capture HotKey: Jing provides More features for defining preferences such as customized hotkeys. The Capture HotKey can be useful for capturing pull-down menus. 

 

5.  Web Hosting: If you setup a screencast.com account, you can upload your Jing videos and/or screenshots to the web.  A url and embed code is then available for sharing the Jing content.  (Limitations = Jing users have 2 GB of storage, and 2 GB of bandwidth per month.)

 

Resources:

Free Jing Download:  https://www.techsmith.com/jing.html

Jing Training Materials: https://www.techsmith.com/tutorial-jing.html

ScreenCast Account FAQ: https://www.techsmith.com/tutorial-jing-what-is-screencastcom.html

Disable Video Autoplay

How often have you been peacefully reading online content on your PC and some garish video unexpectedly takes over? Boom! Peace gone. You can configure your browsers to disable video autoplay. Here’s how.

Disable autoplay

Before we get started, please note that not all browser versions may have some of the click-through options mentioned below. That could be interpreted in a variety of ways. It could be that the video autoplay was not enabled to begin with or your version of browser has a different set of steps to disable this feature. Consider the steps below as guidelines.

 

Firefox

- Type “about:config” in the address bar.
- Accept the warning.
- Do a search for “media.autoplay.enabled”
- Double-click it. This will set the ‘value’ to ‘false’ and will turn off HTML elements

 

 

 


Ie
- Go to “Tools” and select “Manage-add-ons”
- Select “Tool bars and exensions” in the left pane.
- Locate and double-click “Shockwave Flash Object” on the right.
- Select the “Disable” button and then click the “Close” button.

 

 

Chrome

- Go to the Chrome Web Store
- Search for “disable HTML5 autoplay”
- Click the “Add to Chrome” button
- Click the “Add extension” button in the pop-up

 

 

Each of these ‘disable’ steps are reversible. The effectiveness of the disable may vary from browser to browser but hopefully videos barging in on your reading will at least be diminished.  Peace out!

 

What do you know about BadgerLink?

BadgerLink is a service provided by the Department of Public Instruction which provides Wisconsin residents with licensed content not available through regular search engines.
BadgerLink
Some of the resources BadgerLink provides include LearningExpress Library (practice tests and tutorials for students and adult learners), EBSCO databases (everything from auto repair to articles on business, health, and general topics), HeritageQuest Online (genealogy resources), to name just a few. We link to some of the BadgerLink resources from the SCLS System-Wide Resources webpage for easy access for SCLS residents, and the full collection resources is available from the BadgerLink website.

Here are some more interesting tidbits about BadgerLink.

Did you know...

Although I use BadgerLink resources all the time, I had never known exactly how BadgerLink is funded, who is behind the scenes, and how BadgerLink came to be until I read "Behind the Scenes at BadgerLink." It's worth a look!

Updated PC order form

The SCLS order form has been updated to include the current Dell PC and laptop models.

The form now includes two PC (Optiplex) and two laptop (Latitude) models. Both systems offer a lower end 3000 series and a higher end 5000 series device. The 3000 series PCs and laptops are configured more for patron and the low level staff stations that don’t have a lot of devices connected to them. The 5000 series PCs and laptops are configured more for staff stations that have several devices connected to them, like RFID tagging stations, Label printers and receipt printers. Both of the 5000 series models can accommodate higher end processors like the Intel core i7 and more RAM, up to 16GB.

The biggest differences between the new 3000 series models and the 5000 series model PCs is the number of ports available. The 3000 series has 8 USB ports, 4 in the front and 4 in the back. It also has one display port so you can control two monitors from the same PC. The 5000 series has 10 USB ports, 4 in the front and 6 in the back. It has two display ports to control up to 3 monitors. It also has legacy serial, keyboard and mouse ports, which I know you will not need, but they are there, just in case.

Both laptop models have a 15.6 inch screen; they also include the number pad on the keyboard. The 3000 series laptop has 3 USB ports whereas the 5000 series laptop has 2 USB ports and a USB C port for connecting to a dock.

Undo Send for Outlook on the Web

Microsoft added an Undo Send feature to Outlook on the Web back in January.  Those of you who use the SCLS-supported Office 365 mail can enable the Undo Send feature for up to 30 seconds by following these simple steps.

  1. Log into your Office 365 mail.
  2. Click the Settings gear button at the upper-right.
    Gear
  3. Click Mail at the bottom.
  4. Beneath the Automatic processing menu, click Undo send.
    Menu
  5. Select Let me cancel messages I've sent for and select a time period from the dropdown.
    Time
  6. Click Save.
  7. Click the back arrow to go back to your mailboxes.
    Options Arrow

You have now turned on the Undo Send feature.  How do you actually use it?

  1. After you have sent your email, click the Drafts folder.  All mail that you send will hang out in the Drafts folder for the amount of time you specified earlier.
  2. In the Drafts folder, select the email you want to stop from sending.  It is probably the top message.
  3. In the upper-right of the email, you will see a progress bar.  Click Undo.
    Undo Progress bar
  4. At this point, you can either edit your message and Send it again, or simply get rid of it by clicking Discard.
    Discard

Have a good weekend everyone!

Parents - Stop Hovering and Start Monitoring in Google Chrome

Kids-Online

As a parent to a preteen, I have struggled with giving my daughter unsupervised access to the internet.  Even though schools provide a lot of information to children about internet safety and we’ve had many discussions about household internet rules, I still wanted a way to monitor her activities without “hovering.”

Google Chrome has an easy solution I find useful.  Chrome allows you to set up a separate profile for your child, which parents can monitor and control.

You will first need to create a new profile by going to Settings > People > Add person. Make sure to click the box next to "Control and view the websites this person visits from [your log-on account] and click Add. These supervised profiles will not be set up with their own Google identity/log-on account.  (This means they are not supposed to be tracked or targeted by Google's ad business.)

Within 15 minutes, you should receive an email link to access the supervised user's page. There you will have the ability to block certain sites, keep SafeSearch on lock, and view that user's Web activities. You can then log your kid into Chrome under their own profile by clicking the identity tag up in the top-right corner of the browser window. You also have the ability to set up and customize multiple profiles for multiple children.

This has been an easy way for me to have some peace of mind and also prompts communication between me and my daughter about what she is viewing online.   Of course these discussions aren't always easy, but are sometimes necessary given our increased use of the internet in every day life.