Tag: video

SKYPE new feature: Blur my background

 

  •  

    Animated image of a background being blurred in Skype.

    Ah, the foibles of working from home.

    That Skype call is about to start and you’ve got wet laundry and dirty dishes all over the place.

    Worried about what your VC attendees are going to see? Worry no more:

    Skype now offers a BLUR MY BACKGROUND. This option, similar to one present in MS Teams, uses heuristics (aka, technomagic) to discern foreground from background then applies a flattering blur similar to the one that Cybil Shepherd’s Maddie Hayes character was often filmed with.

    Next up on the R&D drawing boards:

    • Add Pants Filter (for those moments when you prematurely stand up)
    • Hide my wife and kids, for this guy

    Cheers!

    quincy

    Additional reading:

Data Consolidation

Using Consolidate you can summarize data from separate worksheets onto one master sheet.  Data Consolidation performs a statistical function (e.g. Sum, Average) on a series of ranges (lists). And the best part:  the lists need not have identical content.

Watch this 2+ min. video to learn all you need to know.

Performing the Data Consolidation

Logo_Microsoft_Excel_2013 Click  here to open Toy List Consolidation.xlsx sample spreadsheet

Prep: Sort each list by the first column and remove all blank rows and columns within the lists.

Tip: Use Define Name to set name each list.

  1. On the summary sheet, select the upper-left cell where the consolidation is to appear.
  2. On the Data tab, in the Data Tools group, click Consolidate.
  3. In the Function box, select function (i.e., Sum).
  4. In the Reference field, type the name or cell references of first list (including column and row headings), then click Add. Repeat this step for each list to be summarized.
  5. Check Use labels in Top row and Use labels in Left column.
  6. Click OK.

Cheers!

hɔuᴉnb

Related reading:

Comments and questions are always welcome!

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

PivotTables & Slicers

Want a quick introduction to PivotTables? Watch this 10 minute video. I demonstrate the basic features of PivotTables and feature Slicers, new to Excel 2010. And for more, view the earlier post: PivotTable Intro, Step by Step.

%d bloggers like this: