Remember the old days, when only the kids belonged to Facebook, and they used it to plan parties, and post embarrassing photos? Well, now almost everybody has signed up, and the kids have probably moved somewhere else, and they’re hoping that we don’t discover where.
I have a personal account, and also created a page for [...]

Moved to the Excel Twitters archive:
Excel Twitters 20090625

Here’s a favourite message from my mailbox this week:
Subject: help me in excel
Dear sir,
I have a problem in excel i requesting to you solve this. I am sending the data of excel sheet pls look in to that
If you have want any information on that please get back to me
I am waiting for your reply
Regards
Anonymous
Those [...]

“Help!” said the familiar voice, when I picked up the phone at 10 PM.
“I have a list of orders in an Excel sheet. I want to compare it with the list from last week, and delete all the orders that were in the old list.”
It was my daughter, still at the office, trying to get [...]

Moved to the Excel Twitters archive:
Excel Twitters 20090619

Have you ever had trouble trying to count items based on two criteria? Don’t worry – it’s Underdog to the rescue!
Note: There’s a short sound clip in the video, so turn down your speakers if your co-workers are napping.
Underdog Comes to the Rescue in Excel
Use SUMPRODUCT to Count
As Underdog mentioned, [...]

Yes, the weekend is over, but another one is just five days away! To make it easier to keep track of weekends in Excel, you can use conditional formatting to highlight the rows where the date is a Saturday or Sunday.
For example, our Excel file has a list of product sales for the first half [...]

Moved to the Excel Twitters archive:
Excel Twitters 20090612

Well, I should have been working all day, but decided to take a bit of time to relax and catch up on some reading (of RSS feeds). At the Lost in Technology blog, was a link to XtraNormal, where you can write, cast and direct an animated movie. That sounded like more fun than working, [...]

In a pivot table, you might want to see all the orders that were shipped on a specific date. To do that, you’d move the Ship Date field to the Page area, and select a date from the drop down list.

Sometimes though, you'd like to show the orders shipped in a date range, instead [...]