Sunday, October 25, 2020
Home Business & Economics

Business & Economics

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

    Most popular
    Most loans and many investments are annuities, which are payments made at fixed intervals over time. Here's how to use Excel to calculate any of the five key unknowns for any annuity.

    Excel’s Five Annuity Functions

    Financial Functions Charley Kyd -
    0
    “Help!” the message said. “I know the payment, interest rate, and current balance of a loan, and I need to calculate the number of...
    You can use probability distributions to manage the uncertainty about your assumptions when you create simulations in Excel. Here's how.

    How to Return Random Numbers from a Normal Distribution for Your Excel Forecasts

    Business Statistics Charley Kyd -
    0
    (This is the first of two articles about normal distributions. The second article is, How to Create Monte Carlo Models and Forecasts Using Excel Data...
    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...
    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...
    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

    Excel's Graphic Tools Charley Kyd -
    0
    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...
    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

    Charting Methods 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...
    On Valentine's Day, 2018, tens of thousands of major sites warned their readers that inflation is rising. But that might not be true. These analytical Excel charts suggest a different conclusion.

    What Inflation? How Excel Charts Can Help You Avoid Fake Economic News

    Analytical Methods Charley Kyd -
    0
    The business news on Valentine's Day, 2018, was dominated by talk of rising inflation. A search of Google News showed 67,100 results for the...

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

    Charting Methods 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...
    Excel offers at least three ways to set up data so your reports and analyses can use it easily as a reliable data source.

    Introducing Excel’s Three Types of Spreadsheet Databases

    Data Management Charley Kyd -
    0
    Excel offers three general ways to arrange data in your spreadsheet so you can use it as a database with your worksheet formulas: Simple...
    123...11Page 1 of 11

    Latest Articles

    If you want all your Excel reports, analyses, forecasts, and other Excel work to be highly productive, this is the strategy that will make it happen.

    An Introduction to Excel Data Plumbing

    Business & Economics 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

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