Excel’s VLOOKUP Function Explained

Formulas & Functions Charley Kyd - 0
Excel's VLOOKUP function looks in the first column of an array and moves across the row to return the value of a cell. VLOOKUP is...
Two unusual formulas can use the SEARCH or FIND functions to search any number of cells for any number of words—almost instantly.

How I Set Up SEARCH and FIND Formulas on Steroids

Data Management Charley Kyd - 0
I've used Excel long enough to recognize when I've stumbled across an unusual formula. And it happened again a few minutes ago. In the past,...
Use this unique Excel dashboard to track the general rate of inflation, your personal rate, and the rate of the goods and services you buy.

Inflation Tracker Excel Dashboard with Consumer Prices

Business & Economics Charley Kyd - 0
U.S. President John F. Kennedy once said of a growing economy, "A rising tide lifts all boats." However, a rising inflationary tide does not lift...
Excel's Quick Access Toolbar can save you many clicks and needless work. Here are the eight QAT tools that I use, and how I use them.

Eight Great Tools for Your Quick Access Toolbar

Excel Productivity Charley Kyd - 0
I use eight great tools in my Quick Action Toolbar (QAT), and you might want to consider using them yourself. Before I get into the...
Update this Excel dashboard with 15 key US mortgage interest rates every business day, with one command. Each chart shows 71 days of rates.

Mortgage Rates Excel Dashboard

Training & Solutions Charley Kyd - 0
What direction are mortgage rates in the US heading? This Mortgage Rates Excel dashboard will tell you. You can see the full version of it...

How to Set Up Multiple Conditional Formats with Formulas

Conditional Formatting Charley Kyd - 0
In How to Set Up a Square-Format U.S. Map in Excel, I showed how to create a square-format US map in Excel. I also...
When conditional formatting rules conflict, Excel can deliver unexpected formatting results. These two guidelines make Excel's logic clear.

How Excel Manages Conflicting Conditional Formats with Formulas

Conditional Formatting Charley Kyd - 0
When we're working with conditional formatting with formulas, how does Excel manage conditional formatting rules that conflict with each other? And how does the "Stop...
Here's how to calculate the annual rate of inflation both by comparing prices several years apart, and by several months apart.

How to Calculate Inflation in Three Different Ways

Analytical Methods Charley Kyd - 0
Today, in the third quarter of 2021, the business press is churning out an avalanche of articles about the return of inflation. Although some...
This Excel map relies on conditional formatting to highlight areas of interest.

How to Set Up a Square-Format U.S. Map in Excel

Conditional Formatting Charley Kyd - 0
For several years, the Wall Street Journal has occasionally used a square-format US map like the following image. But when I noticed a recent...
It should have been a simple Excel formula. But it became a two-part puzzle needing arrays, ASCII, and text concatenation to answer.

A Two-Part Excel Puzzle, with Arrays, Text, ASCII, and Concatenation

Array Formulas Charley Kyd - 0
Recently, I needed to compare two long columns of text of various lengths to make sure that each row of text in column A...
123...22Page 2 of 22