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

Learn how to create Excel dashboards.

Excel Twitters, Takeaways and Trials

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

Tiny Workouts at Your Desk

If you spend long hours working at your computer, with only an occasional jaunt to the lunch room, you might benefit from Twittercize. Ron Doyle is a Denver-based freelance writer who posts short exercises in Twitter, and they’re designed for you to do in a minute or so at your desk.
During the workday, he posts [...]

Weekend Backups

Over the weekend I did a backup of my RSS feeds, and created backup files for my Wordpress blog.
How often do I do this? Not often enough. So, I’ve added both items to my monthly task list, and that might help me remember to keep the backup files up to date.
I also have a Maxtor [...]

Automatic Backup for Access Files

Do you have Access databases open throughout the workday, with people entering and editing data? In Access, data is saved automatically as you work, but it’s a good precaution to have a backup of the entire file, so you can recover if something goes wrong.
To make backups easy to manage, Jan Karel Pieterse has [...]

What's Your Backup Plan?

Last Thursday I asked if you use checklists, and if someone could cover for you if you were away. It looks like we could use some improvement in that area.
In the same vein, what about backups? What happens if you show up for work, but your key files don't?
When I'm writing, or working on a [...]

Learn Languages Online from the BBC

If you'll be travelling soon, you might want to learn a few key phrases of another language before you go. Free language lessons are available online, at the BBC website. It's good to see Nick's tax dollars hard at work.

It's too late to learn much Mandarin before the Olympics are over, but you can study [...]

Contact a Human in Customer Service

When you have to contact customer service at a large company, you might end up in an endless voice mail loop. To contact a human, you can check the database at the GetHuman web site, and follow the instructions listed there. For example, I typed AT&T as the company name, and a list of phone [...]

Compare Shipping Costs

Don't waste time comparing shipping rates at individual carrier sites. Enter your starting point and destination, and let ShipGooder calculate the rates for you. This free service compares major courier and postal services, and local carriers. You can also find US or Canadian postal codes, by address or city.
For example, if I want to ship [...]

Find Deals at Amazon

If you're looking for an item to buy online, check the Jungle Crazy site to find the best deals listed on Amazon. For example, enter Cables as a search term, and see all the discounted cables:
 http://www.junglecrazy.com/search.php?query=cables