Friday, November 27, 2020

Recent Content

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.
Business & Economics

An Introduction to Excel Data Plumbing

Charley Kyd -
0
Would you like to: Create your new reports, analyses, forecasts, and other Excel work quickly? Update your Excel work with one command, without using...
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

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

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?

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

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

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

Charley Kyd -
0
In the early 1980s I was the CFO of a company owned by a man whose first instinct was to cut prices. When business was...
These Excel dashboards, inspired by long-running displays in business magazines, illustrate more ways to format your Excel reports.

Sample Excel Dashboard Reports from Forbes and Business Week

The first time the general public saw Excel dashboards was in 1993 when Tektronix used this report to demonstrate the quality of their printers.

The First Excel Dashboard Report Shown in Public

When you combine conditional formatting with charts you can create detailed chart legends that match the relative positions of the lines in your chart.

How to Create Dynamic Chart Legends in Excel

You can sort data with formulas in two ways. One way requires Excel 2019 and above. This article explains how to sort data in all versions of Excel.

How to Sort Data in Reports Automatically Using Excel Formulas

Formulas & Functions

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

How to Structure Your Report Workbook

Charley Kyd -
0
In Weekly & Monthly Top-Ten Activity Reports I introduced two Excel dashboard reports created by Chris Helfrecht. In this post, I’ll describe a critical aspect of...
Conditional formatting with formulas offers power and flexibility for your Excel reports. Here's how to get started.

Conditional Formatting with Formulas

How to Work with Dates Before 1900 in Excel

How to Work with Dates Before 1900 in Excel

In finance, breakeven charts illustrate how your fixed and variable costs vary with your monthly sales. Here's how to set up break-even charts in Excel.

Map Costs and Sales in Excel with a Classic Breakeven Chart

Although Excel's FREQUENCY function was designed to calculate frequency distributions, you also can use the SUM-IF, SUMPRODUCT, INDEX-FREQUENCY, and COUNTIFS functions. Here's a summary of the methods and your options.

Five Ways to Calculate Frequency Distributions in Excel

Excel Methods

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.