Friday, April 24, 2026
Linkedin
Linkedin
Home Business & Economics

Business & Economics

    Excel solutions for tasks performed in businesses. And Excel reports and analyses about economic issues.

    Random
    By charting the annual Rate Of Change (ROC) of key measures, you can uncover significant information about your time-series data. And by using the right recession measure, you can put that information into better context.

    Chart Your Rate of Change to Reveal Hidden Business Performance

    Analytical Methods Charley Kyd - 0
    What insights can you gain from the following Excel chart of Apple's quarterly revenues over the past 18 years? I see three things. First, their...
    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...
    You need a volatile workbook to test Excel calculation speeds. Here's how I set one up to test lookup formulas.

    A Volatile Workbook to Test Calculation Times for Excel Lookup Methods

    Business & Economics Charley Kyd - 0
    In Use Excel VBA to Test Report Calculation Times I described a macro that finds the total time necessary to calculate Excel for a specified number...
    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 Tables

    Data Management Charley Kyd - 0
    “Export to Excel is the 3rd most common button in BI apps…after OK and Cancel.” —Rob Collie, one of the founding engineers behind PowerPivot at...
    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

    Reporting Charley Kyd - 0
    "I work for a small (private) company whose owners have requested WEEKLY dashboards on various aspects of the business. Do you have a sample...
    An article in the Wall Street Journal about babies born during the winter months offers some great advice about charts for Excel users in business.

    Excel Charts, Seasonality, & Analysis: Five Lessons from the WSJ

    Business & Economics Charley Kyd - 0
    A 2009 article in the Wall Street Journal offered some great advice for Excel users in business. The article, New Light on the Plight of...
    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?

    Business & Economics 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...
    Both IPMT and ISPMT return the interest payment for a given period for a loan or investment. But Microsoft's help topics haven't made their differences clear. Here's what you need to know about these two financial functions.

    How to Create Even-Payment and Straight-Line Amortization Tables in Excel

    Business & Economics Charley Kyd - 0
    When you borrow money for a fixed period with periodic payments, you could have two types of loans: even-payment or straight-line. Microsoft recognizes those loan...
    Here's how to apply an Excel report, forecast, or analysis for one product, division, or other categoy to any number of categories. Part 2 of 3.

    How to Reproduce Your Excel Work Across Many Categories, Part 2 of 3

    Data Management Charley Kyd - 0
    As I explained in Part 1 of this series, Excel users often need to apply many instances of data to one model or forecast, list...

    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...
    123...13Page 1 of 13

    Latest Articles

    Excel Flowbook Revolution

    Getting Radical with Excel

    Excel Data Plumbing Revolution Charley Kyd - 0
    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?

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