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 readingTag: Excel
Fighting 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 reading
I 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 reading
How 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 readingNC #648 DTNS Live, Excel Replacements, Bluetooth Dropout Fixed, Previous Recipients
Fun with the Cool Blind Tech Podcast guys, My ScreenCasts Online tutorial is up about Parallels Toolbox. I was on DTNS Live and Steve captured some funny moments on video. I walk through all of the options for when you go to High Sierra and Office 2011 won’t work any more, centered around my love […]
Continue reading
There’s No Place Like Excel
I may have mentioned a few hundred times that I love Excel. I serious dislike PowerPoint, and I see no need for Word, but Excel brings me great joy. I simply love taking piles of data and turning it into information, and Excel is how I do that. There isn’t a pivot table I don’t […]
Continue reading