Archive for the ‘Microsoft Excel’ Category
Friday, March 5th, 2010
Podcast: Play in new window
| Download
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…)
Posted in BlackBerry, DigIT, Listener Tips, Lotus Notes, Microsoft Excel, Microsoft Excel 2007, Microsoft Outlook, Microsoft Outlook 2007, Microsoft PowerPoint, Microsoft PowerPoint 2007, Microsoft Windows, Microsoft Word, Microsoft Word 2007, Mobile Devices, Office 2007, Podcast, Productivity Tools, Windows Mobile | No Comments »
Friday, February 19th, 2010
Podcast: Play in new window
| Download
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…)
Posted in BlackBerry, Listener Tips, Microsoft Excel, Microsoft Excel 2007, Microsoft PowerPoint, Microsoft PowerPoint 2007, Microsoft Publisher, Microsoft Publisher 2007, Microsoft Visio, Microsoft Windows, Microsoft Word, Microsoft Word 2007, Office 2007, Podcast, Productivity Tools, Windows Mobile | No Comments »
Saturday, January 16th, 2010
Podcast: Play in new window
| Download
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…)
Posted in Data Analysis, Microsoft Excel, Microsoft Excel 2007, Office 2007, Podcast | No Comments »
Saturday, December 5th, 2009
Podcast: Play in new window
| Download
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…)
Posted in Business Communication, Microsoft Excel, Microsoft Excel 2007, Microsoft Publisher, Microsoft Publisher 2007, Microsoft Word, Microsoft Word 2007, Office 2007, Podcast | No Comments »
Saturday, November 21st, 2009
Podcast: Play in new window
| Download
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…)
Posted in Data Analysis, Microsoft Excel, Microsoft Excel 2007, Office 2007, Podcast | No Comments »
Monday, October 26th, 2009
Podcast: Play in new window
| Download
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…)
Posted in Microsoft Access 2007, Microsoft Excel, Microsoft Excel 2007, Microsoft PowerPoint, Microsoft PowerPoint 2007, Microsoft Word, Microsoft Word 2007, Podcast, Productivity Tools, Uncategorized | No Comments »
Thursday, October 8th, 2009
Podcast: Play in new window
| Download
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…)
Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft PowerPoint, Microsoft PowerPoint 2007, Microsoft Word, Microsoft Word 2007, Office 2007, Podcast, Productivity Tools, Uncategorized | No Comments »
Friday, September 25th, 2009
Podcast: Play in new window
| Download
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…)
Posted in Data Analysis, Microsoft Excel, Microsoft Excel 2007, Office 2007, Podcast, Uncategorized | No Comments »
Friday, September 18th, 2009
Podcast: Play in new window
| Download
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…)
Posted in Microsoft Excel, Microsoft Excel 2007, Microsoft Outlook, Microsoft Outlook 2007, Microsoft PowerPoint, Microsoft PowerPoint 2007, Microsoft Word, Microsoft Word 2007, Office 2007, Organization and Time Management, Podcast, Uncategorized | No Comments »
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…)
Posted in Microsoft Excel, Professor Addenhauer | No Comments »