Friday, July 30, 2021

Recent Content

Excel users made such a mess of nested IF functions that Microsoft created the IFS function to help. Here's how to tame both functions.
Formulas & Functions

How to Tame Nested IF Functions in Excel

Charley Kyd -
0
When I review my Excel formulas from many years ago, one of the types of formulas that I'm most embarrassed about today is the...
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

A Lesson in Excel Analysis Learned from Rising US Inflation

Here's how you can split delimited text into an array with a short Excel formula, and then wrap the formula with the INDEX function to return any value from the array.

How to Split and Index Delimited Text with Excel Formulas

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

Featured Articles

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 -
0
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...
How to aggregate named groups of GL accounts.

How to Report GL Account Groups in Excel

Accounting & Finance Charley Kyd -
0
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 -
0
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...
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

Training & Solutions Charley Kyd -
0
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

Training & Solutions Charley Kyd -
0
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...

Blog

Analytical Methods

A Lesson in Excel Analysis Learned from Rising US Inflation

Charley Kyd -
0
Looking at the trends in the annual rate of change (ROC) of business and economic measures is an excellent way to reveal hidden information...
Here's how you can split delimited text into an array with a short Excel formula, and then wrap the formula with the INDEX function to return any value from the array.

How to Split and Index Delimited Text with Excel Formulas

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

Add Low-Overwhelm Context to Your Line Charts

When you're refinancing, this chart allows you to use the tip of your finger trade off your monthly payments and your total payments as you consider the term of your loan.

Calculate Mortgage Payments and Your ROA with an Excel CalcPlot Chart

Business & Economics

Mortgage lenders give you many options for your interest rate and amortization period. This workbook helps you to choose from among them.
Downloads

Compare Loan Payment Options in Excel

Charley Kyd -
0
When you’re comparing your payment options for mortgage loans, your choices can be overwhelming... When in St. Ives, I found a home, Then looked at seven...
Your Return On Equity ratio is a key indicator of financial health. This report lets you show the components of that ratio in a unique Excel display.

Map Your Financial Health With an Excel DuPont Dashboard

If you're charting only your raw business data, you're missing many opportunities to give your readers useful business insight. Here are three simple tricks that will help you to turn your ordinary charts into analytical ones with much greater insight.

Three Simple Tricks to Improve Analytical Charting in Excel

I've seen many horrible monthly Board Reports and CEO Reports over the years. Here's how Excel users can correct many of those problems.

Fourteen Ways to Improve Your Monthly Board Reports with the Help...

Here's how to use a formula that returns TRUE or FALSE in Excel's conditional formatting feature to highlight rows that contain specific numbers or text.

How to Use Conditional-Format Formulas to Change Background Colors

Formulas & Functions

This Excel chart of High-Low-Open-Close stock data shows key methods you can use in charts...even those that have nothing to do with the stock market.
Business & Economics

Using Excel XY (Scatter) Charts for Stock Analysis with HLOC Plots

Charley Kyd -
0
One way to improve your abilities in Excel is to improve your understanding of the kinds of solutions Excel can generate when you use—or...
Your managers, clients, and other VIPs will pay more attention to charts that look professionally designed. Here are the basics of how to produce them.

The Basics of Professional Excel Charting

Summary tables in Excel reports have always been difficult to format so they don't LOOK like Excel tables. Here's one extreme method you might want to try.

Add Some Style to Your Tables in Excel Reports

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

Excel ranges can work like relational tables. You can join them by common fields. Query them with SQL. And use queries in PivotTables. Here's how.

Use MS Query to Treat Excel as a Relational Data Source

Excel Methods

Excel's SUMIFS and SUMPRODUCT functions both can return the sum of a column of data under specified conditions. But which calculates more quickly?
Aggregation Functions

Excel’s SUMIFS or SUMPRODUCT…Which is faster?

Charley Kyd -
0
Today, I learned about an Excel reporting need that looks something like this: There’ll be about 150,000 rows of data maintained in an Excel database. ...
This table summarizes the performance of Excel's worksheet functions primarily designed to work with dates

Overview of Excel’s Date Functions

Excel users made such a mess of nested IF functions that Microsoft created the IFS function to help. Here's how to tame both functions.

How to Tame Nested IF Functions in Excel

Excel's SUMPRODUCT Function offers more power and flexibility than its help files describe. Here's a new way to use one of Excels' most-powerful functions.

The SUMPRODUCT Function’s Undocumented Method

Should You Raise Prices? Should You Lower Them? These Excel Charts Can Help You Answer Those Questions

Should You Raise Prices? Should You Lower Them? These Excel Charts...

All Categories

Popular

When you bring data from another source into an Excel worksheet, the data often includes rows that you’ll want to delete. Here's the first of two methods.

How to Delete Blank or Unneeded Rows, Method 1

Worksheet Interaction Charley Kyd -
0
When you bring data from another source into an Excel worksheet, the data often includes rows that you’ll want to delete. Often, you’ll want...
When you want to look up data in Excel, you should never use a worksheet function with "lookup" in its name. Here's why...

Why INDEX-MATCH Is Far Better Than VLOOKUP or HLOOKUP in Excel

Downloads Charley Kyd -
0
(Download the workbook.) Excel’s VLOOKUP function is more popular than the INDEX-MATCH function combination, probably because when Excel users need to look up data then a "lookup" function...
Excel provides several worksheet functions for working with normal distributions or 'bell-shaped curves.' This introduction to Excel's Normal Distribution functions offers help for the statistically challenged.

An Introduction to Excel’s Normal Distribution Functions

Business Statistics Charley Kyd -
0
(Download the workbook.) When a visitor asked me how to generate a random number from a Normal distribution she set me to thinking about doing statistics...
© ExcelUser, Inc. Copyright © 2004 - 2020 by Charles W. Kyd, all rights reserved.