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

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

Business & Economics 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

Excel Tables 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...
1...202122Page 21 of 22