Have you tried Microsoft PowerPivot for Excel 2010 (formerly Gemini)? It’s a powerful data analysis add-in for Excel, and is part of the Office 2010 Beta. If you haven’t downloaded the Beta, you can test PowerPivot in the hands-on Virtual Lab.
That’s where I tested PowerPivot last weekend, and hit a few snags, but was impressed [...]

Last week was Recruit a New VBA Programmer Week, so we pitched in by recording an Excel macro, and running it. I’ve updated that article, by adding a video, so you can see all the gory details, step-by-step.
This week we’ll look at the Excel VBA code that the Macro Recorder created, and make a minor [...]

Yes, Excel can help you have a good TIME. It’s also useful if you’re looking for a DATE, or the perfect MATCH. (Insert your own bad puns here.)
Today we’ll focus on the TIME function, because one of my clients recently wanted some help with that.
What Time Is It?
There are a couple of keyboards shortcuts for [...]

You have an Excel order form with a long list of products to select. After a customer enters quantities for the products they want to order, you want to print an invoice for the selected items.
Select the Products
Here’s the OrderForm sheet, where quantities have been entered for four of the products, in column E.

Formulas [...]

This is Recruit a New VBA Programmer Week, according to Dick Kusleika, so we’d better get moving. I haven’t recruited anyone yet, have you?

If you aren’t a VBA programmer already, keep reading, and you can be my victim, errr, willing recruit. Don’t be afraid – it won’t hurt a bit. Or byte.
If you are a [...]

Well, maybe you don’t scribble. Maybe your handwriting is way better than mine. Anyway, here’s my version of that film classic, Love and Pain and the Whole Damn Thing.
For the past couple of years, I’ve worked with a client that has factories around the world. As part of their safety program, employees fill in [...]

Naming Excel sheets – how hard can it be? Last month, we looked at sheet names, and saw the problems that were caused by using an apostrophe. This week, I found another sheet name problem.
Someone, let’s call him Mr. X, contacted me about one of my sample worksheets — Create New Sheets from Filtered List. [...]

Without family, where would Excel blog ideas come from? My daughter called today, and asked how to sort more than 3 columns in Excel. She uses Excel 2003, and the Sort dialog box only allows three column choices. There’s no box to choose the fourth column – Name.

Obviously, she didn’t check my website, where she [...]

I love advanced filters, but this week they caused me some serious grief.
Advanced filters in Excel are quick and powerful, and I use lots of them. They’re a great way to pull a list of unique items from a table, or send specific data from one sheet to another.
People sometimes have trouble with an advanced [...]

It’s been quite a while since the last one, but I’ve finally posted another list of Excel Twitters. The Twitter spam was making it too tough to collect the interesting tweets, and that’s why I stopped. However, I managed to create a few search settings that helped a bit, and this new list is the [...]