Thursday, October 22, 2020

Recent Content

Here's how to boost your Excel output, slash your Excel errors, and improve your Excel reports and analyses—whether you work for a large or small company.
Training & Services

How to Be Significantly More Productive in Excel

Charley Kyd -
0
The Excel charts below are professional-quality. But that's not what makes them so unusual. Instead... ● You can update them in a few seconds, with...
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

All Excel reports perform at least four tasks. Good reports assign these tasks to four sections, with specific worksheets defining each section.

How to Structure Your Report Workbook

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

Featured Articles

Here's how to boost your Excel output, slash your Excel errors, and improve your Excel reports and analyses—whether you work for a large or small company.

How to Be Significantly More Productive in Excel

Training & Services Charley Kyd -
0
The Excel charts below are professional-quality. But that's not what makes them so unusual. Instead... ● You can update them in a few seconds, with...
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?

Data Management Charley Kyd -
0
You can improve your Excel reports and analyses significantly if you keep your data in an Excel database. Microsoft, Oracle, IBM, and others sell...

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

Formulas & Functions

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

The Basics of Professional Excel Charting

Charley Kyd -
0
When you're reporting, you can't run a cable from your data to your readers' brains. But the next-best alternative is to use great charts. By "great...
Beginning in Excel 2016 in Office 365, your formulas can set gaps in your line and scatter charts. Here are two ways to use the feature in your reports.

Two Business Uses for Excel’s New Chart Feature

Does Excel's INDEX worksheet function work for you only some of the time? Here are ways to learn why your INDEX function isn't working as you expect.

How to Debug INDEX in Excel

When you see changes in trends of business performance, it's natural to ask what caused the changes. Here's one way to do it with Excel charts.

Compare Performance to Yes-No Conditions in Excel Charts

First Excel Dashboard Report Showing Financial Data for a Public Company

Excel Methods

You need a volatile workbook to test Excel calculation speeds. Here's how I set one up to test lookup formulas.
Business & Economics

A Volatile Workbook to Test Calculation Times for Excel Lookup Methods

Charley Kyd -
0
In Use Excel VBA to Test Report Calculation Times I described a macro that finds the total time necessary to calculate Excel for a specified number...

How to Use SUMPRODUCT to Create Two-Dimensional Lookups in Excel Formulas

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

How to Use SUMPRODUCT to Find the Last Item in an Excel List

How to Use SUMPRODUCT to Find the Last Item in an...

This table summarizes the performance of Excel's worksheet functions primarily designed to work with dates

Overview of Excel’s Date Functions

All Categories

Popular

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

Financial Functions Charley Kyd -
0
“Help!” the message said. “I know the payment, interest rate, and current balance of a loan, and I need to calculate the number of...
You can use probability distributions to manage the uncertainty about your assumptions when you create simulations in Excel. Here's how.

How to Return Random Numbers from a Normal Distribution for Your Excel Forecasts

Business Statistics Charley Kyd -
0
(This is the first of two articles about normal distributions. The second article is, How to Create Monte Carlo Models and Forecasts Using Excel Data...
The Monte Carlo method allows you to forecast performance using probability distributions for your assumptions. And Data Tables provide a quick and easy way to implement the Monte Carlo method. Here's how to do it.

How to Create Monte Carlo Models and Forecasts Using Excel Data Tables

Business Statistics Charley Kyd -
0
(Download the workbook.) (This is the second of two articles about normal distributions. The first article is, How to Return Random Numbers from a Normal...
© ExcelUser, Inc. Copyright © 2004 - 2020 by Charles W. Kyd, all rights reserved.