Five Ways to Calculate Frequency Distributions in Excel
Walt captures blood-pressure readings and wants to find how often the readings fall into various ranges of values.
This is a common need for a...
Five Best Practices in Your Excel Reporting Strategies
Most Excel reports, forecasts, and analyses I've seen in my career could serve as excellent examples of what NOT to do in Excel.
These reports...
First Excel Dashboard Report Showing Financial Data for a Public Company
The figure below shows the first Excel dashboard to display data about a public company. Although this report looks quite similar to today's reports,...
Excel Charts, Seasonality, & Analysis: Five Lessons from the WSJ
A 2009 article in the Wall Street Journal offered some great advice for Excel users in business. The article, New Light on the Plight of...
Error Handling in Excel Spreadsheets
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...
Eight Tips to Make Excel Easier to Use
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...
Document Excel Worksheets with Pictures that Include Row and Column Headings
This image is a picture of a section of an Excel worksheet. Be sure to include pictures like this when you create your own...
Display Any Colors in Excel
(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...
Declaring Variables in VBA: Three Keys for Success
A recent post in an Excel forum included some VBA code and asked why the code kept failing. The first few lines of code...
Create Variable-Length, Dynamic Reports Linked to Excel Tables
Excel Tables are a powerful feature introduced in Excel 2007. Not only can you report from them directly, you can use them as a...
Latest Articles
Getting Radical with Excel
It's time to think about Excel in a radical new way—when we use it to work with business or economic data.
It's time, in fact,...
How Fast Is Too Fast?
(Originally published in Inc Magazine.)
What typically tops the list of worries of the chief executive officers of fast growing companies? Financing that growth, according...
How to Smooth Data by Using the TREND Function
Years ago, I read that Prof. William S. Cleveland had suggested that data could be smoothed by calculating a centered trendline through adjacent data—a...
Advertisement