Saturday, January 23, 2021

Recent Content

We compare Excel's five columnar lookup functions.
Downloads

XLOOKUP vs VLOOKUP vs INDEX-MATCH vs SUMIFS

Charley Kyd -
0
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

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

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

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

Featured Articles

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...
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 & Services 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 & Services 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...
Excel databases can be Tables of data, Pivot Tables, or even lists that your reports and analyses can use easily. This introduction will get you started.

What the Heck is an Excel Database?

Business & Economics Charley Kyd -
0
You can raise your Excel productivity significantly and slash your Excel errors—if you keep your data in an Excel database. Microsoft, Oracle, IBM, and others...

Find Leading Indicators Using Automated Cross Correlations in Excel, Part 1

Analytical Charting Charley Kyd -
0
It all seems so simple... To improve your forecasts of sales or other measures, you simply need to find leading indicators...measures that are highly correlated...

Blog

Blog

Add Low-Overwhelm Context to Your Line Charts

Charley Kyd -
0
The data you display in charts often takes on new meaning when you display it in the context of other data. One way to add...
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

Each fat line in this chart indicates when a recession has occured for the specified country. You can use the same method to show other Boolean conditions.

Chart Recessions and Other Boolean Conditions in Excel

This Excel table shows the top and bottom five results, with charts that show the most recent three month trends. And it updates automatically.

Show Top and Bottom Results in a Chart-Table

When you include several charts in one report, your managers must THINK about each chart to decide if it shows good news or bad. Here's a fix for that.

How to Remove a Speed Bump From Your Excel Charts

Business & Economics

Charting Methods

The First Excel Dashboard Report

Charley Kyd -
0
The Excel dashboard below is from the first-ever package of dashboard reports, which I created to show Excel's power to a client...
Growing too fast can be dangerous to your company's health. Use the Sustainable Growth Rate ratio to track your company's financial ability to grow.

How Fast Is Too Fast?

Top-ten figures are useful because managers need to know where the greatest opportunities and the worst problems are. Here are ideas to make them readable.

How to Make Top-Ten Charts Easier to Read

How healthy is your company? Here's a mathematical method that can help you to predict whether a business is headed for bankruptcy…if it's still accurate.

Predict Business Bankruptcy Using Z Scores with Excel

A simple change to your Excel-generated balance sheet can give your managers key information to help them manage cash flow more effectively.

Add Cash Flow Information to Your Excel Balance Sheets

Formulas & Functions

Here's one way to highlight exceptional performance in your Excel management reports. You just need an Excel chart, its CHOOSE function, and linked pictures.
Charting Methods

How to Create Excel Traffic Lights with Charts and Text

Charley Kyd -
0
"Traffic lights" are a common feature offered by software designed for management reporting and analysis. Traffic lights provide at least two benefits. First, they alert...
Excel's XY (or "scatter") charts provide amazing power. This introduction to XY charts offers a fun way to learn more about this powerful chart type.

Fun with XY (Scatter) Charts in Excel

It makes sense to document your VBA programs. Here are four easy ways to help yourself and others know what your VBA programs are trying to do, and why.

Corporate VBA Standards for Excel Users Who Program

To reduce errors in reports, you should foot and cross-foot them. But Excel's floating-point arithmetic gets in the way. Here's how to fix the problem.

How to Foot and Cross-Foot Excel Reports in a Floating-Point World

Excel includes many outstanding features that you probably don't know even exist. Here's how to find those features and to use the ones you need.

How to Find and Use Excel’s Best Hidden Features

Excel Methods

Here are nineteen examples of common date calculations used in Excel reports and analyses, using worksheet functions like DATE, EDATE, EOMONTH, and others.
Date-Time Functions

Nineteen Date Calculations in Excel

Charley Kyd -
0
Excel reports and analyses typically include date calculations. But many Excel users have large gaps in their knowledge about this topic. So in this article,...
Term loans can have a variety of repayment periods, interest rates, amortizing methods, and so on. Here's how to calculate amortization schedules for the two most common types of amortizing loans.

How to Use Excel Formulas to Calculate a Term-Loan Amortization Schedule

Here are the only two ways I know to set up formulas that look up data in an Excel Table, using more than one criteria.

Two Ways to Set Up Multi-Criteria Lookup Formulas in Excel

Excel's dynamic range names give your formulas the power to adapt automatically in response to changes in your data or settings. Here's how to set them up.

How to Create and Use Dynamic Range Names in Excel

Most loans and many investments are annuities, which are payments made at fixed intervals over time. Here's how to use Excel to calculate any of the five key unknowns for any annuity.

Excel’s Five Annuity Functions

All Categories

Popular

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...
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...
© ExcelUser, Inc. Copyright © 2004 - 2020 by Charles W. Kyd, all rights reserved.