Excel Tips – How to Clear Formats of a Cell

Excel Clear formats

How to clear the formatting of a cell

Published in: on September 29, 2016 at 1:25 pm  Leave a Comment  

How to Fix Netflix if it fails to broadcast to Chromecast

NetflixThis article gives you the step-by-step guide on how to resolve the issue where Netflix fails to broadcast to Chromecast.

Our Set-up

The Problem

  • From time to time, we’ve noticed that the Chromecast will fail to receive the “casting” from our Samsung Galaxy S4, especially when we switch from one Netflix profile to another.
  • Casting any shows from the Samsung Galaxy S4 to Chromecast will just show an idled “Ready to cast” screen.

The Solution

  1. On the Samsung Galaxy S4, bring up the Settings screen by touching the phone from the top edge and pressing downward.
    Bring up the Settings
  2. On the Settings screen, press “MORE” and then “Application manager”.
    Application manager
  3. Scroll down and look for “Netflix”.
    Look for Netflix
  4. Now, press the CLEAR DATA button to remove any conflicting data that might have persisted.
    Clear Data
  5. Return to the home page and launch the Netflix app.  You will need to sign in again (since we’ve clear the app data).
  6. Now you should be able to cast your show on the big TV screen again.
Published in: on September 18, 2016 at 2:05 pm  Leave a Comment  

What Google Algorithm Updates Mean for SEO

google-update-seo

Published in: on September 14, 2016 at 6:35 am  Leave a Comment  

TFSA vs RRSP

tfsa-vs-rrsp

Published in: on September 14, 2016 at 6:32 am  Leave a Comment  

How to Structure a Perfect LinkedIn Profile

how-to-structure-the-perfect-linkedin-profile

Published in: on September 14, 2016 at 6:28 am  Leave a Comment  

Airport Runway Numbers Explained

Published in: on August 28, 2016 at 3:38 pm  Leave a Comment  

How Logo Colors Make Customers Feel

how-logo-colors-make-customers-feel

Published in: on August 26, 2016 at 11:54 am  Leave a Comment  

Magic Bullet Beauty Tips

Nutrient Face Mask

Hair Repairing Conditioner

Daily Facial Firming Toner

Published in: on August 26, 2016 at 7:28 am  Leave a Comment  

Magic Bullet Cooking Tips

Chopped Onion

Pancakes

Salsa

Smoothie

Chicken Salad

Published in: on August 26, 2016 at 7:05 am  Leave a Comment  

Excel – How to Transcribe Column Name to Text

ExcelHere is a quick tip on how to transcribe the Excel column label name (e.g. A, B, C, etc.) to text in your worksheet cell.

=SUBSTITUTE(ADDRESS(1,COLUMN(),4),"1","")

Published in: on August 26, 2016 at 6:39 am  Leave a Comment