Conditional Formatting Spreadsheets

Spreadsheets can be used for so many things, and one of my favorite features is conditional formatting. Basically, you can tell the sheet to do something if something else is happening in the sheet. If you like to use spreadsheets but want to take your spreadsheet experience to the next level, try looking into conditional formatting. A search can bring back a lot of helpful results and ways to use it.

Some ways I've used conditional formatting in the past:

  • Cross out an entire row once I've put "yes", "x", "y", etc. in a cell (my favorite!!! great for keeping track of tasks!!)
  • Highlight entire rows with certain words or values
  • Highlight individual cells with certain words or values

Check it out!

Web Browser Terminology

If you've used web browsers for any length of time you've heard the terms cache and cookies. Just what exactly are these and are they the same thing? Well, I'm here to explain these terms for you.

CookiesCookies
No, I'm not talking about Chinese fortune cookies or chocolate chip cookies. I'm talking about the small files that your browser saves on your computer that contain information that the website you're visiting uses to enhance your experience. Every time you visit a website your browser looks for the cookie associated with that website and sends it to the website's server telling it what you did the last time you were there. Cookies will sometimes track information like how frequently you visit, what times of the day you visit, what you've clicked on, and other information that is used to customize your visit. So essentially, cookies are used to store different information about you, the user. Cookies also have an expiration date so they will expire after some time period.

CashCache
This is pronounced just like the word for legal tender. When you visit a website your browser saves on your computer a copy of the HTML pages and images that you view. This is done for your benefit to reduce bandwidth usage, server load, and to make the website load quicker the next time you visit. So essentially, cache is used to store information about the website. Cache does not expire and is only removed if you manually remove it. To remove your cache you can follow these steps:

  1. Open any browser
  2. Press Ctrl+Shift+Del
  3. Select cache
  4. Click the appropriate button at the bottom of the window to delete or clear

Offload apps to quickly free up storage on your Apple device

Apple_logoIf you’re like me, automatic updates to your Apple device are appreciated.  It’s one less thing for me to have to remember or worry about.  However, it has become more of a chore for me because my device storage is always too full.  I then have to choose individual files to delete to make room for the latest upgrade, which is often very time-consuming.  There are more long term solutions such as deleting unused apps and uploading files that take up a large amount of space to a cloud storage service (i.e. photos, videos).  

Offloading your files is an option that I find extremely useful and saves me a lot of time.  It allows you to temporarily disable an app without deleting the settings.  They will remain on your device’s home screen, but you will need to tap to re-download in order to use it.  You can do this by going to your device’s storage list, tap the app you wish you offload, and select Offload App.

2020-01-16_10-14-08

2020-01-16_10-22-19

You can also set up the automatic removal of apps you don't use often. Simply go to Settings > General > Device Storage > Offload Unused Apps and tap Enable.

 

It's not lazy to hit the snooze button (on email)

Snooze
The snooze buttons in O365 and Gmail

Ever use the snooze button in O365 or Gmail? It may seem lazy—it's a SNOOZE button, after all—but it's becoming a helpful habit for me. If you've never snoozed email before, it lets you hide an email from your inbox until a future time that you choose. When it's time, the email reappears in your inbox, nudging Future You to process it in a timely fashion.

I'm definitely no email productivity guru, and what works for me might not work for you. But I've tried using categories (and labels, stars, folders, and color coding) to flag important messages for follow up, and sorting through the backlog later is so overwhelming. Snoozing an email lets me get it out of sight, out of mind, with a built-in reminder to attend to it soon. This is how the snooze button fits into my system:

  1. Delete or archive automated notifications or listserv announcements that don't require attention.
  2. Read anything that looks urgent and respond immediately, or add to the to-do list outside of email.
  3. Read, reply to, and archive anything that can be dealt with quickly.
  4. Snooze messages that aren't urgent, but need more than a sentence or two reply, and set them to reappear soon (like after lunch or tomorrow morning). This lets me focus on the immediate to-do list tasks, rather than getting distracted by time-consuming, but lower priority, issues and projects. (And my rule is to only snooze once!)
  5. Stop looking at email, and concentrate on the to-do list.

With luck, by the time a snoozed message reappears in my inbox, I'm ready to focus on it. I'm more likely to stick to the priorities in my to-do list, and get more done overall. Good thing too, because the emails just keep coming. Happy snoozing!

Digital Bytes: Free Stock Photos, Print Friendly

Jamie and Anne at the Wisconsin Valley Library Service have a couple of new videos! They're short and they highlight some services I hadn't run across before and which I will be adding to my collection of helpful tools. Negative-space-summer-dandelion-macro

Free Stock Photos
Time: 5:32
Jamie talks about three tools to find quality, and free stock photos for your library marketing. 
Watch

 

Print Friendly
Time: 2:55
Tired of printing articles on websites with ads, sidebars, and things you don’t want or need? In this Digital Byte, Anne talks about a great tool called “Print Friendly.
Watch

Firefox Monitor

Firefox Monitor is a free and easy way to find out if your email address has been exposed to an online data breach since 2007.  You can search for your email address from the web site at any time, or configure Firefox Monitor to send you alerts when your email is discovered to be part of a data breach.  You will need a Firefox account to set up alerts.

According to the FAQs, Firefox uses Have I Been Pwned as the source database provider for their service.  Their database is not totally comprehensive as it takes some time for some breaches to be discovered and they are not always given all the details of some breaches.  If you don't want your email address to be searchable on Have I Been Pwned, they do provide an opt-out link.

Microsoft Photos for Editing

High waterI wanted to make a quick edit to a photo recently and found that Microsoft Photos has upped their game. Maybe it’s been like this for a while and I just didn’t notice, but I'm pretty happy with the options they offer now.


If you open a photo in Microsoft Photos, it’s the default photo viewer on my Windows 10 PC, and click the “Edit & Create” tab you are given several options including cropping, straightening (for some reason my photos are always a little crooked), flipping and rotating. You can add filters and make some basic adjustments to the color, light, clarity (sharpening), and it has some other features like Red Eye Removal and Spot Fixing.


You can also go a little farther and add 3D effects or animated text to your images.


The photo in this post was cropped and slightly straightened using Microsoft Photos editing tools. I applied the “Sunscreen” filter to it too because it was cloudy when I wrote this and I thought what the heck, why not.


I still plan on using my go-to photo editor for as long as I can, but the new features (new to me anyway) in Microsoft Photos will definitely get more use from me for fast fixes that I want to do rather than going through my normal routine.

Repeating Events in Google Calendar

If you have events that happen regularly, you can schedule them as a repeating event on your Google Calendar instead of making separate events for each. For example, the Collection Maintenance Subcommittee meets every other month on the second Wednesday, so this is the set up for that:

Calendar

There are various options for repeating an event including making a custom one like above. Here are the others:

Calendar2

I have repeating events set up for a lot of tasks so that I don't forget to do them. This is especially good for things that only happen a handful of times a year, since I tend to forget those more easily.

I also have reminders to pay my student loans every month. (。╯︵╰。)

Have fun putting together repeating events! \(^▽^)/

How to search within multiple PDF files at once

We all know that we can search within a PDF file for any text that we want to find. But did you know that you can search within multiple PDF files at once? Well, I'm here to tell you that you can and here's how you do it.

1. Open Adobe Acrobat Reader DC

2. Click on the Edit menu at the top and select the "Advanced Search" option

Multi_PDF_1

3. Click the radio button in front of "All PDF Documents in"

Multi_PDF_2b

4. Click on the dropdown menu to open it

5. Click on the "Browse for Location..." option

Multi_PDF_3

6. Navigate to the folder where your PDF files live

7. Fill in the text box with what you want to search for

8. Click the Search button

9. If you get a Security Warning message click the "Allow" button

Multi_PDF_3b

10. You will then get a search window that tells you how many PDF files contain your search term and how many instances of it were found
Multi_PDF_4

Digital Bytes: MailChimp, scheduling Facebook posts

Ever wonder about using MailChimp for newsletters?  This recent Digital Byte video from Wisconsin Valley Library Service is all about MailChimp and how your library can use it for marketing efforts.

 

Jamie also posted a quick video about how to schedule posts for your library's Facebook page from your mobile device:

You can find all the WVLS Digital Bytes here: https://wvls.org/digital-bytes/