Corporate VBA Standards for Excel Users Who Program
(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...
How to Delete Blank or Unneeded Rows, Method 2
Data copied from a web site or imported from a variety of sources often include irrelevant rows of data.
For example, the only way to...
Use Common-Age Excel Charts to Compare and Forecast Performance for the Same Number of...
In the early lives of new products or new stores, managers often are anxious to track and improve sales performance. To do so, it's...
Use Excel’s Drawing Tools to Create Your Own Cartoons
More than ten years ago, I went on a family trip. I didn't take my laptop, because my wife told me to leave the...
How to Create and Use Dynamic Range Names in Excel
(Download the example workbooks.)
We Excel users often refer to ranges that need to move or expand in future versions of our reports. For example:
...
How to Read and Update Excel Tables Using SUMIFS and INDEX-MATCH
A growing number of Excel users in business are linking their reports and analyses to Excel tables. By doing so, they can update them...
Track Dynamic Data with VBA or with Iterative Calculations
"My A1 cell changes value every minute because it imports data from a DDE server. To keep historical data, I would like to list...
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...
Should You Raise Prices? Should You Lower Them? These Excel Charts Can Help You...
In the early 1980s I was the CFO of a company owned by a man whose first instinct was to cut prices.
When business was...
Weekly & Monthly Top-Ten Activity Reports
When one of my readers, Chris Helfrecht, sent the two sample Excel dashboards below, he wrote that he tried to follow my methods for...