Archive for the ‘Microsoft Excel’ Category

Where’s Waldo? Where’s anything, for that matter? (VOL051)

Friday, March 5th, 2010

We have a special guest joining us this week, Ms. DigITal Entity. She is a computer chip with an extensive memory and a unique ability to communicate. We’ve all encountered situations where we wish we knew what our computers were thinking; well, DigIT, as she is known to her many friends and family, provides that insight.

(more…)

Recovering from the Deep Freeze (VOL049)

Friday, February 19th, 2010

In the summer, frozen treats are a delight. I have to admit, when I hear the ice cream truck coming down the street on a hot day, I still scramble to gather up some money and run outside (usually in bare feet on the scorching pavement, but who has time to look for shoes?) to flag it down so I can enjoy an ice cream cone, some water ice, or maybe even a Drumstick.

(more…)

You might think I'm crazy: How to count cars with Excel (VOL046)

Saturday, January 16th, 2010

There is a wide range of music on my iPod: everything from classical to ’90s alternative. When I put the playlist on shuffle, anything goes. I might hear the soothing strains of Mozart’s “Eine kleine Nachtmusik” or the raucous refrain of Chumbawamba’s “Tubthumping.” Um…everyone else has that on their iPods, right?

The other day, the song “Counting Blue Cars” by Dishwalla came on and I found myself singing along with the lyric: “We count only blue cars…”

Nerd that I am, I couldn’t help but immediately conjure up an Excel formula to help them out:

=COUNTIF(Cars, “blue”)

(more…)

Cookies and Holiday Greetings by the Dozen (VOL042)

Saturday, December 5th, 2009

The holiday season is upon us once again, and with it comes the importance of remembering that which truly matters most: cookies. Lots and lots of cookies.

Chocolate chips, snickerdoodles, and gingerbread men by the dozen. We humans have a tendency to celebrate various occasions with food, and I am by no means opposed to this time-honored tradition.

(more…)

Another Case of Formula Frenzy (VOL041)

Saturday, November 21st, 2009

Welcome back to the podcast! This week’s edition: Another Case of Formula Frenzy.

It was a dry and brisk November evening when I got the call. Sitting at my desk with the blinds cracked just enough to allow the last rays of sunlight from the dying day to creep through, the ringing of the phone shattered the silence like a brick through a pane of glass. The dame was one-half shrill hysteria, two-thirds livid frustration, and just a splash of hopeless desperation. The recipe for a typical batch of Formula Frenzy. Combine and shake well; serve chilled and aggravated.

(more…)

"Out with the Old and in with the New": Using Find and Replacê in Microsoft Office (VOL038)

Monday, October 26th, 2009
Welcome back to the podcast!
This week’s edition…

Welcome back to the podcast!

This week’s edition…

“Out with the Old and in with the New”: Using Find and Replacê in Microsoft Office

I’m a bit of a digital packrat. I keep everything. Not only do I keep stuff, I also have multiple back-ups of the documents I have saved.

I suspect I am not unique, either. Recently, I was talking with a colleague and she admitted that she keeps everything too – but she never goes back to use it again. She said she makes backups so she has “just-in-case” copies, but readily admits that she creates the same documents over and over again from scratch.

(more…)

Taking Shortcuts Through the Widescreen Zone (VOL036)

Thursday, October 8th, 2009

There’s no denying it. Computer monitors are growing to wild proportions. Have you seen the size of these things lately? Pretty soon, we won’t even be able to control them. We’ll eventually build a monitor so big, it will enslave the human race! Then it will find a way to watch Hulu on us. Oh, cruel fate!

(more…)

Finding Your Perfect Match…by Using Excel Functions (VOL034)

Friday, September 25th, 2009

Welcome back to the podcast! This week’s edition: “Finding Your Perfect Match…by Using Excel Functions”

Well, it happened again. I’m almost positive I put both socks into the dryer, but only one came out. Tell me: where do the lost socks of the world go when they disappear? The Island of Misfit Socks? An exclusive club for singles? Maybe they have their own dating website, and they all go online in the hopes that they’ll find their perfect match. (more…)

Inventing the Wheel was a One-Time Deal (VOL033)

Friday, September 18th, 2009

Welcome back to the podcast!

This week’s edition: “Inventing the Wheel was a One-Time Deal”

If you hang around any business office long enough, you’re likely to hear workers uttering the same banal buzzwords or expressions (more…)

Playing Wisper Down the Lane with Excel (Professor Addenhauer)

Wednesday, August 26th, 2009

Gossip

I remember a game one of my early grade school teachers had the entire class play. She had us all line up and then whispered a sentence into the ear of the first in line who in turn whispered it into the ear of the next and so on until the last in line would walk up to the chalk board and write down what they heard. The results were always hilarious and meant to be a lesson in passing along gossip (I think); but oddly enough, I think it is also an apt metaphor for what happens to data in today’s digital world as it gets passed from one program to another, one platform to another, over the World Wide Web, through security and encryption systems, and finally to your desktop, usually into Microsoft Excel, probably the most ubiquitous data cruncher out there today.

(more…)