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

Pages

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 [...]

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. [...]

Purging the Bookshelves

Do you have the inner strength to throw out old books?
I love computer books, and bring home way too many of them. Things were bad enough in the old days, when I had to leave my office and drive to a bookstore, in order to buy books. Then the miracle of online shopping occurred, and [...]

Find New Sites With All My Faves

I use Google to do web searches, and am pretty efficient at finding things, in my humble opinion. Last week my son sent me a link to All My Faves, which lets you find things, but in a completely different way than Google.
The Home page has rows of web site logos, grouped in categories such [...]

Back Up Your RSS Feed

Every day, I skim through a long list of blog posts, in Google Reader. I’ve accumulated the items in my list over a few years, and would hate to lose it.
Now I’m sure that the fine people at Google take very good care of my feed, and I don’t have to worry about it. However, [...]

Excel Twitters 20080816

If nothing else, at least these weekly Twitters let you know that you’re not alone in your love/hate relationship with Excel. This week we look at the Good, the Bad, and the downright Ugly.
The Good

I’d be happy if they’d switch to Excel. Anything’s better than ferreting the unanswered questions of out a pile of mangled [...]

Find WiFi While Travelling

When you’re travelling, you probably bring your laptop, so you can do some work and keep up with your email. Some of the ritziest hotels that I’ve stayed in charge for daily access to their wireless network, or you can trudge down to the lobby for free access. At other, mid-priced hotels, the access is [...]

Are You Ready for Metered Internet?

If you had asked me a few days ago, how much I download and upload each day, I’d have had no idea. Apparently some cable companies in the USA are testing metered internet service. I haven’t seen this mentioned for Canadian companies, but if it works in Texas, it will probably arrive here soon enough. [...]

Send Google Search Results to Your Newsreader

If you’re trying to stay on top of the news in Excel or another area of interest, you can create Google Alerts to update you automatically. After you create an Alert, you can add it to your newsreader, and read it with the rest of your feeds every day. I prefer this, instead of getting [...]

Excel Twitters 20080810

If people would stop Twittering about Excel, and just do their work, maybe they could go home earlier. Unless they’re using Twitter to ask for help, which a surprising number of people do. It’s hard to help them in 140 characters though, unless you just post a link to the Microsoft newsgroups.
Anyway, here’s another list [...]