Thursday, March 20, 2025
Home Search

dashboards - search results

If you're not happy with the results, please do another search
Using the right Excel charts to display year-to-date variances can clarify budgets and spending problems. But using the wrong charts is a waste of time.

Show Useful Year-to-Date Variance Charts in Your Excel Dashboards

0
Many companies have a difficult time creating charts of spending variances. In fact, many companies rely on charts that are nearly useless for that...
Your data can contain many important, hidden patterns. But simple transformations in Excel can help to reveal them—as this example illustrates.

Simple Transformations Can Reveal Hidden Patterns in Your Data

0
Excel users have at least two significant advantages over business professionals who rely on other analytical and reporting tools. First advantage: We Excel users can...
Use this unique Excel dashboard to track the general rate of inflation, your personal rate, and the rate of the goods and services you buy.

Inflation Tracker Excel Dashboard with Consumer Prices

0
U.S. President John F. Kennedy once said of a growing economy, "A rising tide lifts all boats." However, a rising inflationary tide does not lift...
Update this Excel dashboard with 15 key US mortgage interest rates every business day, with one command. Each chart shows 71 days of rates.

Mortgage Rates Excel Dashboard

0
What direction are mortgage rates in the US heading? This Mortgage Rates Excel dashboard will tell you. You can see the full version of it...
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

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

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

Of all the Excel features that users don’t use very often, Excel's Linked Picture tool probably is the most powerful. This tool, known in...
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

0
Because managers need QUICK insight, we should remove as many speed bumps as possible from our reports and analyses. The following figure with two Excel...
The two Excel dashboard-like charts with May data show that consumer confidence has dropped like a rock since March. But Asia's data isn't available yet.

Dashboard-Like Excel Charts of International Consumer Confidence

0
The following Excel figure displays its charts in a dashboard-like format. At least, it's in a format that dashboards should use! When you use simple...
These Excel column charts of employment, business lending, and freight shipments show mixed signals about the current health of the US economy.

Excel Bar Charts with Economic Indicators

0
The Excel figure below shows three indicators of the US economy. Two show economic improvements and one doesn't. The Excel Perspective Using column charts rather than...

Latest Articles

Excel Flowbook Revolution

Getting Radical with Excel

It's time to think about Excel in a radical new way—when we use it to work with business or economic data. It's time, in fact,...
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?

(Originally published in Inc Magazine.) What typically tops the list of worries of the chief executive officers of fast growing companies? Financing that growth, according...

How to Smooth Data by Using the TREND Function

0
Years ago, I read that Prof. William S. Cleveland had suggested that data could be smoothed by calculating a centered trendline through adjacent data—a...
Advertisement