Friday, March 24, 2023
Home Excel Methods Excel Dashboards

Excel Dashboards

    Here’s where you’ll find techniques to turn a variety of data into an insightful display, using Excel.

    Random
    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

    Excel Dashboards Charley Kyd -
    0
    Management reporting is all about communication. Reporting Return On Equity (ROE) is a case in point. The ROE financial ratio is a key measure of...
    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

    Excel Dashboards Charley Kyd -
    0
    This mock-up is based on a format that Business Week used about thirty years ago. However, their report used a different color scheme. As...
    You can use Slicers rather than Validation Lists to control any settings in your interactive workbooks. You're not limited to controlling only Tables and Pivot Tables. Here's how to do it.

    Interactive Dashboard Magic with Excel Slicers

    Excel Dashboards Charley Kyd -
    0
    The figure below illustrates an Excel magic trick I created for an Excel Dashboard, using in Excel 2016. The key trick is the method I...
    Here's one way to highlight exceptional performance in your Excel management reports. You just need an Excel chart, its CHOOSE function, and linked pictures.

    How to Create Excel Traffic Lights with Charts and Text

    Excel Dashboards Charley Kyd -
    0
    "Traffic lights" are a common feature offered by software designed for management reporting and analysis. Traffic lights provide at least two benefits. First, they alert...
    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

    Excel Dashboards Charley Kyd -
    0
    Tektronix invented one of the early moderately priced color printers. When one of their employees saw a sample of my Excel dashboards from 1992, the...
    If you have seasonal sales, or other measures of performance, Cycle Plots can offer more insight into your performance than traditional charting techniques.

    How to Create Cycle Plots in Excel to Chart Seasonal Sales Data

    Excel Dashboards Charley Kyd -
    0
    If your company's sales are seasonable, you've probably seen a chart that looks something like the first one below. This Excel chart shows the continuous...
    Spreadsheet users in businesses have distributed management dashboard reports for more than 30 years. Here's an example from the early days of spreadsheets.

    The First Spreadsheet Dashboard: Mini-Graph Reports in Lotus 1-2-3

    Excel Dashboards Charley Kyd -
    0
    This is the first dashboard report ever created with spreadsheets. I worked on this reporting technique in the early 1980s, then included this report...

    First Excel Dashboard Report Showing Financial Data for a Public Company

    Excel Dashboards Charley Kyd -
    0
    The figure below shows the first Excel dashboard to display data about a public company. Although this report looks quite similar to today's reports,...
    Most range names in Excel apply to the entire workbook. But you also can define them to apply only to one worksheet. Here's why and how to do that.

    How and Why to Define Excel Range Names with a Worksheet Scope

    Excel Dashboards Charley Kyd -
    0
    In Excel, a name can be global to a workbook or local to a worksheet. The traditional method we all use when we create...

    The First Excel Dashboard Report

    Excel Dashboards Charley Kyd -
    0
    The Excel dashboard below is from the first-ever package of dashboard reports, which I created to show Excel's power to a client...
    12Page 1 of 2

    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 -
    0
    (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 -
    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...
    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 -
    0
    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...
    Advertisement
    © ExcelUser, Inc. Copyright © 2004 - 2020 by Charles W. Kyd, all rights reserved.