Excel Tips
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.
Using Calculated Range as Input to Standard Excel Function »
July 21, 2002
Lucas in London posed this question. He has a series of raw data in column A of his worksheet. He would like a function that would (a) calculate the percentage difference between each data point, then (b) calculate the standard deviation of those differences.
July 16, 2002
If you have been working with spreadsheets since the days of Lotus 1-2-3, then you know how to Range Value cells with formulas in order to change the entries from formulas to values.