If the formulas in your Excel reports and analyses display errors like #DIV/0! or #VALUE!, here are some simple ways to trap them.

Error Handling in Excel Spreadsheets

Error Reduction Charley Kyd - 0
It’s virtually guaranteed. If you have a bunch of formulas like this… M43:   =C43/D43 …then the divisor, D43 in this instance, will have a value of...
Here are eight simple tips that will make Excel quicker and easier to use and less cluttered. It also will make your reports more accurate.

Eight Tips to Make Excel Easier to Use

Excel Methods Charley Kyd - 0
I've been using Excel since 1985. During that time, I've discovered some useful ways to make Excel easier to use. Here are eight tips...
Using gauges in your management dashboard reports is a big mistake. Gauges hide information that managers need and waste space in management reports.

Down With Gauges!

Data Visualization Charley Kyd - 0
It's possible to carry an analogy too far. Dashboards for managers are logically similar to dashboards for cars. Both types of dashboards provide key information...
When you document your Excel worksheets, give your readers complete information by including row and column headings in your figures.

Document Excel Worksheets with Pictures that Include Row and Column Headings

Printing Charley Kyd - 0
This image is a picture of a section of an Excel worksheet. Be sure to include pictures like this when you create your own...
In your Excel reports and analyses, there's a huge difference between documenting performance and communicating it. Do you know that difference?

Do Your Excel Reports Document Performance? Or Communicate It?

Data Visualization Charley Kyd - 0
When you report or analyze performance in Excel, you need to ask yourself a key question... Am I documenting results, or communicating them? There’s a huge...
Excel 2003 offers only 56 colors in its standard palette. Even so, you can create Excel reports that use any colors you want. Here's how...

Display Any Colors in Excel

Excel Methods Charley Kyd - 0
(Note: I wrote this article in about 2004, and I rediscovered it only recently. Because there's a lot to say about using colors in...
In VBA, you'll save time and frustration by always declaring your variables and by also using Hungarian notation. Here's why and how to do that.

Declaring Variables in VBA: Three Keys for Success

Excel Methods Charley Kyd - 0
A recent post in an Excel forum included some VBA code and asked why the code kept failing. The first few lines of code...
Here's how to use formulas and conditional formatting to expand or contract your Excel report automatically, without macros, when you change a cell value.

Create Variable-Length, Dynamic Reports Linked to Excel Tables

Conditional Formatting Charley Kyd - 0
Excel Tables are a powerful feature introduced in Excel 2007. Not only can you report from them directly, you can use them as a...
It makes sense to document your VBA programs. Here are four easy ways to help yourself and others know what your VBA programs are trying to do, and why.

Corporate VBA Standards for Excel Users Who Program

VBA Charley Kyd - 0
(Update: To see an illustration of the points I discussed here, see Read a Text File with VBA, And Write the Text to Excel.) In most...
When you see changes in trends of business performance, it's natural to ask what caused the changes. Here's one way to do it with Excel charts.

Compare Performance to Yes-No Conditions in Excel Charts

Charting Methods Charley Kyd - 0
When you see changes in trends of business performance, it's natural to ask what caused them. Excel charts can answer many of those questions by...
1...151617...22Page 16 of 22