Friday, January 22, 2021
Home Formulas & Functions

Formulas & Functions

    Virtually everything business users do with Excel involves worksheet formulas and functions. And this category concentrates on that topic.

    This category also includes what Microsoft calls “Names”—which many of us call “Range Names.” More accurately, however, “Names” are named formulas.

    Check tags for information about specific functions.

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

    Latest Articles

    We compare Excel's five columnar lookup functions.

    XLOOKUP vs VLOOKUP vs INDEX-MATCH vs SUMIFS

    Formulas & Functions 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...
    If you want all your Excel reports, analyses, forecasts, and other Excel work to be highly productive, this is the only strategy that will work for you.

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