Excel Tips
Print Every Value In Page Field »
September 10, 2002
I have an Excel pivot table set up with 150 different values in the page field. How can I run a macro to print each individual page?
September 3, 2002
How to make sure that duplicate invoice numbers are not entered in a particular Excel column.
August 27, 2002
I have an Excel worksheet that calculates a value. If the cell value is > 100 I need a midi file to be played.
August 20, 2002
Here are some obscure Excel pivot table tricks which will help you get the most out of pivot tables.
Pivot Table Horizontal To Vertical »
August 13, 2002
Excel pivot tables work best when the data is broken down into the most records possible, but this is not always the most intuitive way to load the data into Excel.
Mark Henri's General Guidelines for What to Check When Excel Problems Arise »
August 12, 2002
Here is his general checklist when things go wrong in Excel.
Pivot Table Group Dates By Month »
August 6, 2002
There is a simple method with in a pivot table to have the date field converted to weeks, months, quarters or years.
July 30, 2002
We're trying to compare data across 20 years, so having the same colors for each chart is essential.
Pasting Without Excel Gridlines »
July 23, 2002
When you build a table in Excel with the intent of pasting that table into PowerPoint, it is easy to turn off the gridlines so that the PowerPoint slides look cleaner.