Sunday, October 25, 2020
Excel's Linked Picture feature (Camera tool) allows us to position a table in reports while ignoring the row and column settings in the report worksheet.

Ideas about Using Excel’s Linked-Picture (Camera) Tool

Of all the Excel features that users don’t use very often, Excel's Linked Picture tool probably is the most powerful. This tool, known in...

The First Excel Dashboard Report

The Excel dashboard below is from the first-ever package of dashboard reports, which I created to show Excel's power to a client...
When your Excel formulas get their data from an Excel data worksheet, it's easy to set up weekly dashboard or other reports in Excel.

Weekly Dashboard Reporting with Excel

"I work for a small (private) company whose owners have requested WEEKLY dashboards on various aspects of the business. Do you have a sample...
These example dashboards—prepared by an Excel-using employee—use charts and tables to show top-ten results for a medical device company.

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...
Here's how to add sources and uses of funds to your company's Balance Sheet in Excel to get a clearer picture of how the changes affect your cash flow.

Use this Excel ‘Cash Flow Balance Sheet’ to See Sources & Uses of Funds...

For most businesses, cash flow is more important than profits and losses. The reason is clear. A profitable company with negative cash flows may not...
To improve forecasting, you can use Excel charts to track how quickly new products, stores, sales people, and so on ramp up their performance compared with similar launches in the past.

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...
Excel offers several ways to summarize data quickly and easily. Here are the most powerful and flexible approaches, which include using Excel array formulas.

The Most Powerful Ways to Summarize Excel Data for Reporting and Analysis

(Note: I wrote this before Microsoft introduced Excel Tables or SUMIFS. This post is scheduled for an update.) Excel users often need to summarize data...
Spreadsheet users in businesses have distributed management dashboard reports for more than 30 years. Here's an example from the early days of spreadsheets.

The First Spreadsheet Dashboard: Mini-Graph Reports in Lotus 1-2-3

This is the first dashboard report ever created with spreadsheets. I worked on this reporting technique in the early 1980s, then included this report...
Using the right Excel charts to display year-to-date variances can clarify budgets and spending problems. But using the wrong charts is a waste of time.

Show Useful Year-to-Date Variance Charts in Your Excel Dashboards

Many companies have a difficult time creating charts of spending variances. In fact, many companies rely on charts that are nearly useless for that...

Show Key Stats Automatically in Periodic Excel Reports

Each issue of Business Week magazine used to include several figures titled "The Stat". These figures emphasized key data related to the article on...

Latest Articles

Here's how to boost your Excel output, slash your Excel errors, and improve your Excel reports and analyses—whether you work for a large or small company.

How to Be Significantly More Productive in Excel

The Excel charts below are professional-quality. But that's not what makes them so unusual. Instead... ● You can update them in a few seconds, with...
Use this Excel dashboard to track 27 economic indicators of the United States' recovery from the Covid-19 recession.

Learn How to Use Excel to Track the US Recovery from the Covid Recession

The Covid recession is the worst recession the world has experienced since the Great Depression. And the Recovery Tracker workbook and Excel training can...
This Excel dashboard report lets you follow key economic trends while showing you how to gain a HUGE increase in your Excel productivity at work.

Track Key Economic Indicators Every Weekday with this Excel Dashboard

You can update this Excel dashboard report every weekday—with one command—if you have Excel 2016 or above. This report of current economic data introduces you...
Advertisement
Advertisement