Business & Economics Archives

Excel's STOCKHISTORY function can return decades of history about the prices of stocks for thousands of public companies from many countries. Here's an introduction to that function.

Introducing Excel’s STOCKHISTORY Function

Business & Economics Charley Kyd - June 29, 2021

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...

A Lesson in Excel Analysis Learned from Rising US Inflation

Business & Economics Charley Kyd - May 13, 2021

Looking at the trends in the annual rate of change (ROC) of business and economic measures is an excellent way to reveal hidden information...

Berkshire Hathaway is raising prices, and their costs are increasing. Inflation is on the rise. These Excel charts illustrate the the problem.

Warren Buffett, Inflation, and Excel

Business & Economics Charley Kyd - May 5, 2021

On May 3, 2021, CNBC quoted Warren Buffett saying, “We are seeing very substantial inflation. We are raising prices. People are raising prices to...

Using Excel's LET, SORTBY, and SEQUENCE functions, and dynamic arrays, you easily can list any number of top and bottom results from a Table.

How to Report Top and Bottom Results Using Dynamic Arrays in Excel

Array Formulas Charley Kyd - April 5, 2021

In How to Use Excel’s LET Function, I showed several examples of a powerful function that Microsoft added to Excel 365 in the summer...

You can ratchet down errors in your Excel reports by using an Error Summary Table that uses conditional formatting to alert you to errors.

How to Set Up an Automatic Error-Checking System in Excel Reports

Accounting & Finance Charley Kyd - February 9, 2021

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...

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

Array Formulas Charley Kyd - January 24, 2021

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

Accounting & Finance Charley Kyd - January 17, 2021

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...

In Excel, you can report named groups of GL account numbers, product codes, and so on—just as you report one such number. Here’s how.

How to Use Array Formulas to Report Groups of Accounts

Accounting & Finance Charley Kyd - December 29, 2020

Often, in accounting, marketing, and other departments, we'd like to report and analyze groups of items rather than one item at a time. In Part...

If you want all your Excel reports, analyses, forecasts, and other Excel work to be highly productive, this is the only strategy that will work for you.

An Introduction to Excel Data Plumbing

Business & Economics Charley Kyd - October 26, 2020

Would you like to: Create your new reports, analyses, forecasts, and other Excel work quickly? Update your Excel work with one command, without using...

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

Excel's Graphic Tools Charley Kyd - July 22, 2020

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...

Introducing Excel’s STOCKHISTORY Function