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

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
    Pivot Tables aren't merely a way to interact with your data. You also can use them as a rich source of data for standard reports and analyses. And you don't need to limit formulas to GETPIVOTDATA; you also can use SUMIFS, SUMPRODUCT, and all other Excel functions with pivots. Here's how.

    How to Set Up a Pivot Table as an Excel-Friendly Database

    Formulas & Functions Charley Kyd - 0
    You can use a Pivot Table as a database in the same way that you can use Excel Tables and other Excel-Friendly Databases (EFDs). In...
    You need a volatile workbook to test Excel calculation speeds. Here's how I set one up to test lookup formulas.

    A Volatile Workbook to Test Calculation Times for Excel Lookup Methods

    Formulas & Functions Charley Kyd - 0
    In Use Excel VBA to Test Report Calculation Times I described a macro that finds the total time necessary to calculate Excel for a specified number...
    This simple VBA procedure finds the precise time it takes to calculate a workbook. You can use it to test competing workbook design methods.

    Use Excel VBA to Test Report Calculation Times

    Lookup Formulas and Functions Charley Kyd - 0
    I once exchanged email with an experienced Excel jockey who insisted that VLOOKUP was Excel’s fastest lookup method. It was even faster, he said,...
    INDEX-MATCH formulas can perform many types of lookups that VLOOKUP can’t. And they're faster. Here are six examples.

    How to Use INDEX-MATCH, Part 3: Six Lookups That VLOOKUP Can’t Do

    Formulas & Functions Charley Kyd - 0
    In this three-part series, I'm showing you how to use INDEX-MATCH. In Part 1, I showed you how to use the INDEX function. In Part...
    Most Excel users need to look up data in workbooks. But what's the best lookup method?

    Excel’s VLOOKUP vs INDEX-MATCH Functions

    Formulas & Functions Charley Kyd - 0
    Excel offers two primary lookup methods: VLOOKUP and INDEX-MATCH. Although the two methods are similar, INDEX-MATCH is more powerful. I suspect, however, that VLOOKUP is better-known and more...
    The MATCH function makes the INDEX function useful. This is the second of a three-part series designed to INDEX-MATCH clearer.

    How to Use INDEX-MATCH, Part 2: The MATCH Function

    Formulas & Functions Charley Kyd - 0
    In this three-part series, I'm showing you how to use INDEX-MATCH. In Part 1, I showed you how to use the INDEX function. Here,...
    INDEX-MATCH is Excel's most-powerful lookup method. But many users find it challenging. This is the first of a three-part series designed to INDEX-MATCH clearer.

    How to Use INDEX-MATCH, Part 1: The INDEX Function

    Formulas & Functions Charley Kyd - 0
    Which is best, VLOOKUP or INDEX-MATCH? You might be surprised at the question, because the answer never has been in doubt. INDEX-MATCH can do anything...
    A limited number of Excel worksheet functions can use wildcard characters to filter results. Here a guide to using them.

    Guide to 20 Worksheet Functions that Use Wildcards

    Formulas & Functions Charley Kyd - 0
    Excel offers nearly 20 worksheet functions that support the ability to use wildcards in their arguments. You'll find them listed below, with links to...
    This simple invoicing system allows you to keep a list of products and prices in Excel, then use VLOOKUP or INDEX-MATCH to populate an invoice with the item and quantity you choose.

    Use Excel’s INDEX-MATCH or VLOOKUP Functions to Populate Invoices and POs

    Accounting & Finance Charley Kyd - 0
    A visitor asked how to set up a simple invoicing system in Excel. This is a common problem in many small businesses, divisions, and sales...
    When you want to look up data in Excel, you should never use a worksheet function with "lookup" in its name. Here's why...

    Why INDEX-MATCH Is Far Better Than VLOOKUP or HLOOKUP in Excel

    Formulas & Functions Charley Kyd - 0
    (Download the workbook.) Excel’s VLOOKUP function is more popular than the INDEX-MATCH function combination, probably because when Excel users need to look up data then a "lookup" function...
    Load more

    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.