Beginning PivotTables in Excel 2007 will introduce you to the exciting new pivot table features in Excel 2007. Create quick summaries and pivot charts, add impact with traffic light icons, design calculated fields, group dates and numbers.

Categories

Archives

What Is a Waterfall Chart and Why Would I Need One

Last month your revenue was $40,000 and this month it’s only $30,000? What happened?
In Excel, you could print a nice report that shows each revenue stream for last month and this month, so you can compare the amounts.

You could even create a bar chart to compare the different revenue streams.

The bar chart lets you see [...]

14 Basic Skills For Excel Users

Last week, John Walkenbach posted a list of basic skills for men, then basic skills for women, and finally, basic skills for dogs. That got me thinking – what’s on the list of basic skills for Excel users? If you use Excel at work, or list it on your résumé, what tasks should you be [...]

Create Multiple Home Pages in Firefox

Do you have two or more web pages that you use frequently? I like Google as a home page, and use it many times during the day. I also refer to my own website several times, to make sure everything is working okay, or look up one of the Excel tips that are stored there.
I [...]

Change Google RSS Folders

In the Google Reader, you can see a list of your RSS feeds, and group them into folders. Usually I assign a feed to a folder as soon as I subscribe to it. If I forget, then I can assign it later.
One way is to click the Manage Subscriptions link, at the bottom of [...]

Create Bingo Cards in Excel

It’s Friday, and things are slow at the office. To liven things up, you could create bingo cards in Excel, and organize a game during the lunch hour.
In this example, there are three cards, each with a set of random numbers. You’ll need one of those numbered ball popper machines though, or create a number [...]

Clear Dead Links From Your Bookmarks

I’m setting up my new laptop, and plan to copy my bookmarks from the old laptop. Before I copy them, I’ll clear out the dead links, to tidy things up a bit. There’s no point in copying useless data to the new machine.
If you’d like to do this on your machine, you can use [...]

Compare Annual Data With an Excel Clustered Stacked Chart

How can you create a chart from annual or monthly data, and make the results easy to understand? For example, this table shows meat production in the UK, per season, over 2 years, in thousands of tonnes.

I need a chart that shows the fluctuations in production for each meat type. Did production change much from [...]

Open a New Tab in Firefox

Well, it’s Christmas Eve, and you’re probably too busy to read a long blog post today. So, here’s a quick tip that I discovered this week.
I use Firefox as my browser, and when I need a new tab, I right-click in the tab area, then click on New Tab.

Now, I realize that isn’t a terrible [...]

Defensive Design

Recently I’ve been skimming through Defensive Design for the Web by 37signals and have found a few good tips for creating web forms, help and error messages. It’s not the best book that I’ve seen on web design, but it’s easy to read, and illustrates its common sense guidelines with good and bad examples from [...]

Where’s My Internet?

Last Friday I arrived in my office about 8:30 AM, ready to tackle several small projects, and get them sent off to clients. Full of motivation and caffeine, nothing could stop me. Nothing, that is, except a dead Internet connection. The first clue was MailWasher, lying on its back with its paws in the air. [...]