Hidden Excel: Spreadsheet Compare

Capture2

This hidden gem,  (available with Office Professional 2013,  2016, and Office 365 ProPlus) makes it easy to compare two workbooks, interactively. You can see how values, formulas, and formatting differ – line by line, and cell by cell, highlighting just the type of differences you specify.

To Use Spreadsheet Compare

  1. Find and launch the app by clicking Start then typing ‘Spreadsheet Compare’.
  2. Click Compare Files. The Compare Files dialog appears.
    Capture
  3. Click the folder icon to select the older and newer files, then click OK.

Cheers

quincy

Related Posts

  1. Hidden Excel: Find Date Differences with DATEDIF
  2. Excel Text Functions 1 of 4: =LEFT() and =RIGHT()
  3. Using Histogram for Data Analysis

Alexa gets a ‘no human review’ option

alexa-eavesdropper

With a recent change to Alexa, you can now opt-out of having your voice recordings reviewed by Amazon’s employees.

Why the change? Is it the reports of Google and Apple employees listening in on personal exchanges recorded by the voice-activated assistants? Or perhaps it’s a response to European courts rulings limiting what companies (like Amazon) can do with the data collected by said voice-activated assistants.

alexa

To Opt-Out of Human Review

  1. Open the Alexa app on your phone or tablet.
  2. Select Settings, Alexa Privacy, then Manage How Your Data Improves Alexa.
  3. Locate the setting “With this setting on, your voice recordings may be used … manually reviewed.” and tap OFF.

Cheers

quincy

Related Posts

 

 

Google records your ENTIRE purchase history.

gpurchases
Your Amazon orders, Square purchases, and Seamless lunches.  Pretty much everything you buy online as well as in-store purchases where you opt to have your receipt emailed; all of this is collated in your Purchases history; saved and mined by Google.

The company says this is done to help you track your purchases, and not to help them to produce those targetted ads you receive. Still, the level of detail being culled will surprise you.

This unheralded (read: sneaky) feature can’t be turned off and there is no method to erase your entire purchase history. You can, however, selectively delete items from it.

51cdjkkdx7l._sy355_

(like that ‘Best of David Hasselhoff ‘ album you thought you had to get)

To see and delete items from your Purchases history

  1. Navigate to your Purchases Page: https://myaccount.google.com/purchases
  2. Click an item to display more Details on that purchase
  3. To delete, click Remove Item

with special thanks to Di, recipient of said album

Cheers!

quincy

Related Posts:

Enable Google Play’s Protect to scan your Android Apps

Recently, a hole in Whatsapp’s security allowed hackers to install malware on unprotected phones. To see if your Android apps are secure, enable Protect on Google Play.

To Review or Enable Play Protect:

On your Android, access Settings googlesettingsgear, Security.

If enabled, you are able to see the time and status of your last scan.

lockscreen

To modify your settings, tap Google Play Protect

20190521_121300

Cheers!

quincy

Related Posts:

Thanos clears half your Google search results with a Snap

snap.gif

For today’s U.S. movie debut, Google drops an Avengers Endgame easter egg.

To snap half your search results out of existence

  1. In Chrome, enter ‘thanos’ in your search window
  2. Click the Gauntlet

5/1 Addendum: To reverse time (and restore your searches) click the Gauntlet again.

InfinityGauntlet-Clench

Gmail adds ‘Scheduled send’

Earlier this year, Google made a few small but value-added updates to Gmail. Now, in addition to Strikethrough, and Undo/Redo Gmail is rolling out Scheduled send.

 

 

First Fun Fakery (April Fools ’19)

To help take some of the edge off tax season, today, the internet unleashes its own bevy of fake (but fun) news. Enjoy this sampling of some of the day’s April foolery

Google

Play Snakes in Google Maps

snake gif

Google Files Screen Cleaner option: “Using haptic vibration, it keeps your device clean inside and out”

 

Google Tulip: “More Water!” Because what better way to know what tulips need than to ask them.

National Geographic

Uncovering a Super Volcano beneath Sidney Australia

Duolingo

With these  push notifications, the elephant… or, owl is in the room.:

Watch this space for more…

And for a look back at previous First of April Fun: