How to Find and Use Excel’s Best Hidden Features
Excel has many outstanding hidden features. Here are a few that I use frequently…
In Excel 2013 and above, when you close Excel's last...
Calculate Mortgage Payments and Your ROA with an Excel CalcPlot Chart
An Excel CalcPlot Chart allows you to plot values in three dimensions, not merely two. Here are two examples.
Mortgage Paments
Mortgage interest rates are at...
Add Some Style to Your Tables in Excel Reports
Excel tables in reports have always been difficult for me to format professionally. So every once in a while, I experiment with them.
The two...
Compare Metrics by Category Using Excel Dot Plot Charts
Management reports often must compare measures of performance by some type of category.
For example, reports could compare sales by product, variance by department, sales...
Find Leading Indicators Using Automated Cross Correlations in Excel, Part 1
It all seems so simple...
To improve your forecasts of sales or other measures, you simply need to find leading indicators...measures that are highly correlated...
How to Set Up an Automatic Error-Checking System in Excel Reports
Decades ago, I worked as a cost accountant for a large company. But because our department received terrible reports, I wrote my own reports...using...
You Usually Don’t Need to Select an Object in Excel VBA
An Excel VBA user asked in a forum recently how to select a sheet in VBA when the sheet name is stored as a...
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...
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...
Use MS Query to Treat Excel as a Relational Data Source
Charley's Note: Because MS Query hasn't changed much since Marty Ryerson wrote this article years ago, his instructions are still quite accurate. I have,...