Advanced SUMIFS Calculations with Criteria Lists
In Part 1 of this series, you learned how to use criteria lists for marketing data. In Part 2, we looked at financial data.
And now, in Part...
Read a Text File with VBA in Excel, and Write the Text to a...
"I need to write a text file into one row of my Excel spreadsheet, cell by cell, 20 characters at a time. It's urgent....
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...
Introducing Excel’s STOCKHISTORY Function
The STOCKHISTORY function recently showed up in my non-beta version of Excel 365.
Its appearance was a surprise because it wasn't announced as a What's...
Three Charts Showing Covid-19’s Economic Damage
The following Excel figure shows three indicators of the US economy.Chart 1 measures the number of new unemployment claims during the past week as...
Inflation Tracker Excel Dashboard with Consumer Prices
U.S. President John F. Kennedy once said of a growing economy, "A rising tide lifts all boats."
However, a rising inflationary tide does not lift...
How to Set Up a Pivot Table as an Excel-Friendly Database
You can use a Pivot Table as a database in the same way that you can use Excel Tables and other Excel-Friendly Databases (EFDs).
In...
Here’s How Inflation Could Affect the Value of Your Home
November 5, 2021
Inflation is rising in the U.S. And that made me wonder how a higher rate of inflation could affect the price of...
An Introduction to Excel Data Plumbing
Would you like to:
Create your new reports, analyses, forecasts, and other Excel work quickly?
Update your Excel work with one command, without using...
Beveridge-Chart Trend Analysis with Excel
Here's a great way to discover new insights in your company's data:
Always watch for new methods of looking at data...even if you care nothing...