Wednesday, January 27, 2021
Home Excel Methods

Excel Methods

    Articles that explain or illustrate Excel’s features, functions, and methods.

    Featured posts
    Excel databases can be Tables of data, Pivot Tables, or even lists that your reports and analyses can use easily. This introduction will get you started.

    What the Heck is an Excel Database?

    Business & Economics Charley Kyd -
    0
    You can raise your Excel productivity significantly and slash your Excel errors—if you keep your data in an Excel database. Microsoft, Oracle, IBM, and others...

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

    Latest Articles

    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...
    We compare Excel's five columnar lookup functions.

    XLOOKUP vs VLOOKUP vs INDEX-MATCH vs SUMIFS

    Downloads Charley Kyd -
    0
    SUMIFS? Really? Why is SUMIFS included among those lookup methods? I'll explain in a few minutes. But first, let's look at the lookup methods shown in...
    How to aggregate named groups of GL accounts.

    How to Report GL Account Groups in Excel

    Accounting & Finance Charley Kyd -
    0
    Believe it or not, this income statement is quite sophisticated. It's not nearly as simple-minded as it looks. In fact, this income statement illustrates a...
    Advertisement
    Advertisement
    © ExcelUser, Inc. Copyright © 2004 - 2020 by Charles W. Kyd, all rights reserved.