Sunday, October 25, 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 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

You can uncover hidden trends by charting the ratio of each month's performance to the same month one year earlier.
Analytical Charting

Introducing the Power of Year-Over-Year Performance Charts in Excel

Charley Kyd -
0
The purpose of management reports should be to help readers find and track patterns of performance…quickly and easily. That’s the attraction of charts, of course....
In this final article of the SUMIFS, SUMPRODUCT series, you'll learn more reasons to use advanced multi-criteria lists in marketing and finance.

Advanced SUMIFS Calculations with Criteria Lists

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

Excel offers two powerful worksheet functions that can return the data you need from any type of worksheet database. One is more powerful, but calculates slowly. The other is nearly as powerful, but much faster.

The Two Functions You MUST Know to Return Values from Excel...

This figure uses the Chicago Fed's National Financial Conditions Index to illustrate how to create an Excel panel chart.

US National Financial Conditions Using Excel Panel Charts

Formulas & Functions

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 second of two methods.
Shortcuts

How to Delete Blank or Unneeded Rows, Method 2

Charley Kyd -
0
Data copied from a web site or imported from a variety of sources often include irrelevant rows of data. For example, the only way to...
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

These keyboard shortcuts will help you to things in Excel that are difficult or time-consuming to do any other way.

Five Really Useful Excel Keyboard Shortcuts

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

You can uncover new insights about your company by transforming your data before you chart it. This method of data transformation has revealed a long-term weakness in the U.S. economy.

This Excel Analytical Charting Strategy Reveals an Economic Warning

Excel Methods

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

An Introduction to Excel’s Normal Distribution Functions

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...
Do you spend hours each period turning raw data into useful information? You can fight such Spreadsheet Hell with help from three key Excel functions.

How to Fight Spreadsheet Hell with Three Excel Lookup Functions

INDEX-MATCH formulas can perform many types of lookups that VLOOKUP can’t. And they're faster. Here are six examples.

How to Use INDEX-MATCH, Part 3: Six Lookups That VLOOKUP Can’t...

Microsoft tells us that many worksheet functions are 'deprecated' or that thy're 'compatibility' functions. Here what that means and why you should care.

What’s a ‘Deprecated’ Function in Excel?

The extreme variability caused by seasonal sales makes it difficult to track and forecast your underlying sales trends. Here's how to solve that problem.

How to Create a Rolling Forecast of Seasonal Sales in...

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.