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

These example dashboards—prepared by an Excel-using employee—use charts and tables to show top-ten results for a medical device company.
Charting Methods

Weekly & Monthly Top-Ten Activity Reports

Charley Kyd -
0
When one of my readers, Chris Helfrecht, sent the two sample Excel dashboards below, he wrote that he tried to follow my methods for...
When your Excel formulas get their data from an Excel data worksheet, it's easy to set up weekly dashboard or other reports in Excel.

Weekly Dashboard Reporting with Excel

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

Using gauges in your management dashboard reports is a big mistake. Gauges hide information that managers need and waste space in management reports.

Down With Gauges!

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

Formulas & Functions

In a workbook with many sheets, you easily can select the sheet you want from a list of sheet names in your workbook. And you don't need VBA to do it.
Worksheet Interaction

Quickly Find a Worksheet in an Excel Workbook With Many Sheets

Charley Kyd -
0
I’m not opposed to using VBA. I think it’s great fun and it can be very useful. But in a business setting, if VBA...
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.

How to Delete Blank or Unneeded Rows, Method 2

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

Most Excel gurus can do simple things in worksheets more quickly than early-stage Excel users can. Here are some time-saving ways to get started.

Save Time with Excel Range Selections

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

Excel Methods

The MATCH function makes the INDEX function useful. This is the second of a three-part series designed to INDEX-MATCH clearer.
Formulas & Functions

How to Use INDEX-MATCH, Part 2: The MATCH Function

Charley Kyd -
0
In this three-part series, I'm showing you how to use INDEX-MATCH. In Part 1, I showed you how to use the INDEX function. Here,...
How to Work with Dates Before 1900 in Excel

How to Work with Dates Before 1900 in 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

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

Here's how to set up Future- and Present-Value formulas that allow compounding by using an interest rate and referencing cash flows and their dates.

Find Future and Present Values from Scheduled Cash Flows in Excel

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.