Wednesday, January 27, 2021
To use Account Groups in Excel formulas, you first must define the groups. Here’s how to do it using either simple lists or Dynamic Arrays.

How to Define General Ledger Account Groups in Excel

In Part 1 of this series, How to Report GL Account Groups in Excel, we explored the strategy for creating financial reports that use...
How to aggregate named groups of GL accounts.

How to Report GL Account Groups in Excel

Believe it or not, this income statement is quite sophisticated. It's not nearly as simple-minded as it looks. In fact, this income statement illustrates a...
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...

Latest Articles

To use Account Groups in Excel formulas, you first must define the groups. Here’s how to do it using either simple lists or Dynamic Arrays.

How to Define General Ledger Account Groups in Excel

In Part 1 of this series, How to Report GL Account Groups in Excel, we explored the strategy for creating financial reports that use...
We compare Excel's five columnar lookup functions.

XLOOKUP vs VLOOKUP vs INDEX-MATCH vs SUMIFS

SUMIFS? Really? Why is SUMIFS included among those lookup methods? I'll explain in a few minutes. But first, let's look at the lookup methods shown in...
How to aggregate named groups of GL accounts.

How to Report GL Account Groups in Excel

Believe it or not, this income statement is quite sophisticated. It's not nearly as simple-minded as it looks. In fact, this income statement illustrates a...
Advertisement
Advertisement