Monday, March 1, 2021
Home Business & Economics Page 11

Business & Economics

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

    Random
    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...
    An Excel-Friendly Database is defined as an organized collection of data from which worksheet formulas can return values. Here are five Excel-friendly databases.

    Introducing Excel-Friendly Databases

    Business & Economics Charley Kyd -
    0
    The most productive way to flow data to your Excel reports and analyses is to use Excel formulas to flow data from an Excel-Friendly...
    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...
    This Excel table shows the top and bottom five results, with charts that show the most recent three month trends. And it updates automatically.

    Show Top and Bottom Results in a Chart-Table

    Business & Economics Charley Kyd -
    0
    The workbook that supports the following figure does a lot of work! First, it uses Power Query to download the weekly unemployment claims and the...
    Economic analysts use the Beveridge Curve to analyze the labor market through business cycles. You can use it to analyze how any two measures—internal or external—correspond over time.

    Beveridge-Chart Trend Analysis with Excel

    Economic Indicators Charley Kyd -
    0
    Here's a great way to discover new insights in your company's data: Always watch for new methods of looking at data...even if you care nothing...
    To reduce errors in reports, you should foot and cross-foot them. But Excel's floating-point arithmetic gets in the way. Here's how to fix the problem.

    How to Foot and Cross-Foot Excel Reports in a Floating-Point World

    Error Reduction Charley Kyd -
    0
    At first glance, the following report is an ordinary one. It merely sums an Excel Table by Product and Region, and then foots and...

    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...
    The Wall Street Journal wrote that companies are dropping Excel because it doesn't work well with data—a problem that was solved more than twenty years ago.

    How Your Company Can Work Without Limits in Excel

    Business & Economics Charley Kyd -
    0
    "CFOs at companies including P.F. Chang’s China Bistro Inc., ABM Industries Inc. and Wintrust Financial Corp. are on a similar drive to reduce how...
    Beginning in Excel 2016 in Office 365, your formulas can set gaps in your line and scatter charts. Here are two ways to use the feature in your reports.

    Two Business Uses for Excel’s New Chart Feature

    Analytical Methods Charley Kyd -
    0
    For decades, I've been whining about the need for Excel to have some way for our formulas to specify a gap in line and...
    To use Account Groups in Excel formulas, you first must define the groups. Here’s how to do it using either simple lists or Dynamic Arrays.

    How to Define General Ledger Account Groups in Excel

    Array Formulas Charley Kyd -
    0
    In Part 1 of this series, How to Report GL Account Groups in Excel, we explored the strategy for creating financial reports that use...
    1...91011Page 11 of 11

    Latest Articles

    The LET function is the most powerful function that Microsoft has released for Excel in years. Here's an introduction to its features.

    How to Use Excel’s LET Function

    Array Formulas Charley Kyd -
    0
    In the summer of 2020, Microsoft introduced the LET function for Excel 365—one of the most-significant new worksheet functions that Microsoft has introduced in...
    You can ratchet down errors in your Excel reports by using an Error Summary Table that uses conditional formatting to alert you to errors.

    How to Set Up an Automatic Error-Checking System in Excel Reports

    Accounting & Finance Charley Kyd -
    0
    Decades ago, I worked as a cost accountant for a large company. But because our department received terrible reports, I wrote my own reports...using...
    Here's how to create an Excel array from two others, with the arrays stacked either one on top of the other, or side-by-side, like books on a shelf.

    How to Stack and Shelve Dynamic Arrays

    Downloads Charley Kyd -
    0
    While using Excel 365 recently, I needed to create one dynamic array that would consist of two arrays, with one stacked on top of...
    Advertisement
    Advertisement
    © ExcelUser, Inc. Copyright © 2004 - 2020 by Charles W. Kyd, all rights reserved.