Monday, September 22, 2025
Linkedin
Linkedin
Home Formulas & Functions Page 9

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.

    Latest
    Term loans can have a variety of repayment periods, interest rates, amortizing methods, and so on. Here's how to calculate amortization schedules for the two most common types of amortizing loans.

    How to Use Excel Formulas to Calculate a Term-Loan Amortization Schedule

    Formulas & Functions Charley Kyd - 0
    "How do I calculate cumulative principal and interest for term loans? I have scoured the web for a function that will perform this task,...
    SUMPRODUCT is one of Excel's most-powerful worksheet functions. Here, for example, you can use it in one formula to search text in one cell for many items.

    How to Perform Multiple Table Searches Using the SEARCH & SUMPRODUCT Functions in Excel

    Formulas & Functions Charley Kyd - 0
    SUMPRODUCT is one of Excel's most-powerful worksheet functions. Here, for example, you can use it in one formula to search text in one cell...
    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...
    Using Excel 2007 and above, you can create shaded areas in charts to specify areas of special interest. Here's how to do this using normal curves.

    How to Create Normal Curves With Shaded Areas in Excel

    Formulas & Functions Charley Kyd - 0
    Adding shaded areas to normal curves like this is a challenging task in Excel charting. But once you know how, it's not difficult to...

    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?

    Accounting & Finance 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

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