Hi, this is Allison Sheridan of the NosillaCast Apple Podcast, hosted at Podfeet.com, a technology geek podcast with an EVER so slight Apple bias. Today is Sunday, October 17, 2021, and this is show number 858. mp3 download Tomorrow is yet another big announcement from Apple, and all fingers and toes at Casa Sheridan are […]
Continue readingTag: Excel
How to Add Elapsed Time in Excel
For literally decades I’ve been trying to figure out a way to add elapsed time in Excel, and this week, with the help of my friend Mike, we figured out how to do it. I feel like I have made fire. The problem with Excel (and all spreadsheet applications) is that by default, they treat […]
Continue readingPivot Tables Come to Apple Numbers!
On Tuesday I was delighted to hear from many Internet and real-life friends that Apple has added pivot tables to their Numbers app. It’s a well-known fact that I am wild about pivot tables. I realize, though, that this opening statement absolutely requires an immediate pause to explain first the problem to be solved, then […]
Continue readingNC #767 MasterClass, Aquark Miniaturized Quantum Tech, Microsoft Support Rocks, GaN Charger Tech, GaN Chargers, Sense Electricity Monitor, GENNY Water Generation
Hi, this is Allison Sheridan of the NosillaCast Apple Podcast, hosted at Podfeet.com, a technology geek podcast with an EVER so slight Apple bias. Today is Sunday, January 19, 2020, and this is show number 767. As we start this fun-filled, but not mammoth-sized episode, I have to wonder how many of you stayed till […]
Continue readingMicrosoft Office 365 Support Rocks
You know I’ve been a big fan of Excel for ages, but I often disparage Office 365’s version of Excel. On my previous Mac, every single time I opened a spreadsheet (even an empty one), after 2 or 3 minutes I would get a spinning pizza wheel for 10 seconds. I don’t think it happens […]
Continue readingNC #692 MacAlly MacBook Pro Charger, Excel and Numbers and Elapsed Time, Code-Free Automation Video, Security Bits
After last week’s brain-bending segment on battery calculations, I’ll give you three easy steps to follow that literally summarizes the entire segment. Then I’ll explain why I tried to use Numbers when I wanted to use Excel and how I continue to be disappointed by Numbers. My CMD-D video is finally up from last year […]
Continue readingFighting with Excel and Numbers and Elapsed Time
You all know that I’m a huge fan of Excel. Nothing is as fun as getting a pivot table to turn a giant pile of data into actionable information or creating a graph that tells a story about your data. Heck, just this week, Michael Woerner was stuck on a tricky Excel problem and came […]
Continue readingI Finally Understand Databases Because of the Free Airtable App
You 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 […]
Continue readingNC #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 […]
Continue readingHow to Find the Cell Reference for a Searched Value in an Array in Excel
John 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 […]
Continue reading