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.

Focus on the Business Basics

At The Business Brickyard site, you can download a free copy of president Howard Mann's book, Your Business Brickyard (download link is at the bottom of the page).
The book is short, and to the point, with no fluffy filler. It covers twelve points that will help you focus your business on the basics, rather than [...]

Analyze Networks with Excel Add-In NetMap

It's interesting that Microsoft is using an Excel Add-In, NetMap, to analyze newsgroup structures. The researchers found at least three types of participants: Answer People, Reply Magnets and Discussion People. Hey, I know a few of those "Answer People." No mention of trolls though -- maybe they're in the Discussion People group.

Somewhat related, but [...]

Simplify Data Entry With AutoCorrect

Instead of typing long phrases in Word or Excel, you can create AutoCorrect entries for those items. For example, if you type your name or company name several times a day, create an AutoCorrect entry in which you type your initials, and your name is automatically entered.
Don't create too many entries, or you'll have a [...]

Daily Discounts on Computer Software

The Bits du Jour web site offers one discounted item per day (2 on Tuesdays and Thursdays) -- either Windows software or a web service. You can see the upcoming deals, and download a trial version, to see if it's worth buying when the discount day arrives. You can also read comments from other users, [...]

Excel Twitters 20080726

Moved to the Excel Twitters archive:
Excel Twitters 20080726

Customize Windows Open and Save

Many programs use the Windows Common dialogs which you'll see when you Open or Save files in those programs. For example, in Notepad, if I select File►Open this dialog appears. The bar at the left is the Places Bar, and it contains 5 standard icons.

Not once, in my entire computing life, have I used that [...]

Assign Ball Players Per Inning

One of the most popular downloads on my web site is an Excel file that uses Data Validation to assign players to a position each inning in a ball game. After a player's name has been selected for an inning, that name disappears from the inning's drop down lists. For example, in the screen shot [...]

Speed Up the Start Up

I don't reboot my desktop computer too often, but when I do, it takes extra time because of all the programs that have elbowed their way into my Startup folder. The system tray fills with the icons for these programs, and I manually disable them, which takes even more time.
After every reboot, I promise myself [...]

Controlly Tricks in Excel

Last week I listed a few tricks with the Shift key in Excel, and in the comments, Jon Peltier mentioned a trick he'd discovered with the Ctrl key. Here are a few more things you can do with the Ctrl key in Excel.
There are many other Ctrl tricks, so if you have favourites, please [...]

Show Your Style in Word

If you use Styles in Word (and you should), did you know that there's a Style Area at the left of the screen, where you can see the Style names? This can give you a quick overview when you're formatting a document, and will help you apply the Styles consistently.
If you don't use Styles, you [...]