Open post
tiny tip logo

Tiny Tip – How to Get the App Switcher Back to the Correct Display on macOS

Displays preferences arrangementThis might be the tiniest tip ever posted on

If you have external monitors hooked up to your Mac, it’s really awesome. Most of the time. Sometimes it gets confused.

You probably know that in System Preferences, you can identify which display is the main monitor, meaning that’s where apps first open and such. It’s an odd little trick. Open System Preferences → Displays → Arrangement. On that screen, you’ll see all of your monitors portrayed.

Continue reading “Tiny Tip – How to Get the App Switcher Back to the Correct Display on macOS”

Open post
Braille Alphabet

CCATP #548 – Lupita Salazar on Braille Literacy and Tech

Lupita Salazar talks to us about how she learned to read at 6 years old (just like everyone else) through Braille. She was highly influenced by my awesome friend Lore Schindler, who taught Tech and Braille to her and the other students in the Los Angeles Unified School District. He explains why Braille is so important to literacy when many believe audio is a substitute for being able to read. Lupita is a hard core tech head who just loves to experiment and learn new tech (she even used Android for a year just to understand it!) She’s funny and passionate and has a great perspective that I really enjoyed. You can find Lupita @queeenofthesea31 or email her at

mp3 download

Open post
NosillaCast Logo

NC #680 Keep It, Backblaze B2, Airtable, Security Bits

There won’t be a live show next week, and the NosillaCast will be out on Tuesday instead of Sunday (sorry guys). Check out the tutorial I did on Keep It for ScreenCasts Online at We’ve got another of Steve’s videos from NAB, this time from Backblaze about their B2 cloud storage. Then I’ll tell you how using Airtable from might help me finally wrap my brain around databases as I attempt to manage my bathroom remodel with it. Bart Busschots is with us for another fine edition of Security Bits about Efail, protection of the 4th Amendment, Glitch & ThrowHammer as well as Black Dot & Text-Bomb.

mp3 download

Continue reading “NC #680 Keep It, Backblaze B2, Airtable, Security Bits”

Open post
Programming By Stealth Logo

CCATP #537 – Bart Busschots on PBS 54 – More Bootstrap Utilities

In this week’s episode of Programming By Stealth, Bart Busschots takes us through the last bit of the Utilities for Bootstrap 4. We’l refer to the WABAC Machine (kids, ask your parents about Sherman and Mr. Peabody) to installments 8 and 9 comparing positioning with CSS vs. Bootstrap. Thenwe’ll learn about sizes and float utilities, Flexbox utilities, and Screen Reader utilities. It’s great fun and of course Bart has his excellent companion tutorial at… and you can find Dorothy’s awesome index of all things Programming By Stealth at

mp3 download

Open post

I Finally Understand Databases Because of the Free Airtable App

Airtable logoYou know I’m a huge fan of Excel and all things spreadsheets. Pivot tables, complex equations, they all make my heart go pitter-pat. But I’ve never really understood databases. I can explain what they are and why they’re not like spreadsheets, but only at a very surface level. I haven’t ever grokked them because I never had access to a database program or found a problem they might solve.

On ScreenCasts Online episodes 546 and 548, Don McAllister introduced a database application for the Mac, iOS, Windows, and Android called Airtable from….

Continue reading “I Finally Understand Databases Because of the Free Airtable App”

Open post
NosillaCast Logo

NC #679 NosillaCast Turns 13, Doorbell Tells on UPS, mimoLive, Airplane Noise Solved with Audio Hijack, Array Reference in Excel, Snapthread

We celebrate 13 years of podcasting (on the 13th), I tell the story of how my doorbell informed us that our UPS had died. We hear the interview with Boinx from NAB, and I’ll explain how Rogue Amoeba’s Audio Hijack solved two problems on an airplane. I get my Excel geek on when I solve a dumb question for John, and in a more practical tip, I’ll teach you about Snapthread for making videos out of Live Photos.

mp3 download

Continue reading “NC #679 NosillaCast Turns 13, Doorbell Tells on UPS, mimoLive, Airplane Noise Solved with Audio Hijack, Array Reference in Excel, Snapthread”

Open post

Create Real Videos from Your Live Photos with Snapthread

Snapthread logoOne of the more interesting advancements in iPhone photography in the last few years has been Live Photos. If you haven’t played around with them before, the sensor actually captures a few seconds of video on either side of the photo. Up until recently, the fun party trick was to hold your finger down on the photo and you could see the tiny video. While enjoyable, you couldn’t do anything else with Live Photos.

Back then the photo was a single hi-resolution JPG with a video sidecar file. But with the new High Efficiency Image Format (HEIF/HEIC) things are getting a lot more interesting.

Continue reading “Create Real Videos from Your Live Photos with Snapthread”

Open post
Chit Chat Across the Pond Lite logo

CCATP #536 – David Sparks on Video Field Guide Books

Iphone field guideThis week’s guest is David Sparks from David is the co-host of Mac Power Users with Katie Floyd and The Free Agents with Jason Snell. According to David, he’s also a bad musician (he traded his saxophones for children) and a non-full-time lawyer. But he’s also an author of the MacSparky Field Guides, which are published as iBooks. His latest book, the iPhone Field Guide was just released with over 50 screencasts, 450 pages, 44 chapters and over 65000 words.

I had him on the show to talk about how he creates his books, especially focusing on iBooks Author. Spoiler though, he explains how and why he’s switching to Pages for the creation of his next book. We had a blast talking all of this, including his concept of Cooking Ideas.

mp3 download

Open post
Dumb Question Corner Logo

How to Find the Cell Reference for a Searched Value in an Array in Excel

excel logoJohn Ormsby (aka NASANUT) sent in what he playfully called a Dumb Question:

I have a spreadsheet that contains a 10 by 10 matrix of values. Each value is different. There are column headings at the top, ranging from 0 to 9 and there are row headings on the left, also ranging from 0 to 9.

What I want to do is this. I want to search for a value within the matrix, and if found, want Excel to tell me the row and column that it is in. In other words, if I search the matrix for ‘150’ and it is found at cell F7, then Excel can either tell me ‘F7’ or the row and column headings (I can work with either).

The problem I have is that all of my searching only results in information on how to go the other way (i.e. provide the column and row and ‘find’ the value).

The beautiful thing about this question is that a) it’s not at all dumb, it’s a surprisingly hard problem, and b) I had a lot of other things on my to do list (some of them fairly urgent) but of course I dropped everything to try to figure this out!

Continue reading “How to Find the Cell Reference for a Searched Value in an Array in Excel”

Posts navigation

1 2 3 4 148 149 150
Scroll to top