Excel Dashboards Archives - ExcelUser.com

Wednesday, May 31, 2023

Home Tags Excel Dashboards

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

July 22, 2020

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

June 20, 2020

The First Excel Dashboard Report

April 17, 2020

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

Weekly & Monthly Top-Ten Activity Reports

February 17, 2020

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

February 17, 2020

First Excel Dashboard Report Showing Financial Data for a Public Company

February 17, 2020

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

February 17, 2020

All Categories

Latest Articles

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?

Accounting & Finance Charley Kyd - July 26, 2022

(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

Aggregation Functions Charley Kyd - January 17, 2022

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

Two economists have introduced a new leading indicator, which predicts a recession soon. These Excel charts illustrate their insight. If they're correct, Excel users will be very busy in the months ahead.

Consumer Sentiment Suggests a 2022 Recession

Charting Methods Charley Kyd - December 17, 2021

In recent months, business websites have speculated about recessions and stagflation in 2022. These predictions could affect your Excel work significantly in the next few...