×

Excel Formulas

How To Sum Dynamic Array Function Spill Ranges

How To Sum Dynamic Array Function Spill Ranges

Different Ways to Add Together Dynamic Array Formulas If you are trying to figure out how to apply the addition...

4 Formulas That Can Return An Excel Tab’s Name

4 Formulas That Can Return An Excel Tab’s Name

Formula To Determine Current Sheet's Name In the vast world of Microsoft Excel, users often find themselves delving into intricate...

[Solved] Excel Found A Problem With Formula References In This Worksheet

[Solved] Excel Found A Problem With Formula References In This Worksheet

How To Troubleshoot This Persistent Error Message Not this dialog box again! If you are reading this article, you have...

VLOOKUP Practice Example File [With Solutions]

VLOOKUP Practice Example File [With Solutions]

What Is Vlookup? Vlookup stands for Vertical Lookup and is part of a group of functions that I like to...

Excel’s Offset Function: Easily Understand It!

Excel’s Offset Function: Easily Understand It!

Overview Of The OFFSET function Welcome to my tutorial on one of Excel's powerful and versatile functions - OFFSET! Excel's...

XLOOKUP Formula To Return All Matches

XLOOKUP Formula To Return All Matches

Can You Return All Matches With XLOOKUP? Currently, you cannot return multiple lookup results with Excel’s XLOOKUP function. You can...

Which Excel Versions Have XLOOKUP Function? [Solved]

Which Excel Versions Have XLOOKUP Function? [Solved]

Versions Of Microsoft Excel For XLOOKUP Function The following versions of Microsoft Excel include the XLOOKUP function: Excel 2021 or...

How To Use Wildcards/Partial Match With Excel’s Filter Function

How To Use Wildcards/Partial Match With Excel’s Filter Function

Filter Function and Partial Matching (Wildcard) Criteria Unfortunately, as of this writing, the Filter function does not contain an input...

How To Calculate A CAGR Formula In Excel (Correctly)

How To Calculate A CAGR Formula In Excel (Correctly)

Interactive Excel CAGR Calculator Tool If you are looking for a way to quickly calculate a CAGR for a PowerPoint...

Determine YTD Stock Growth With Excel’s STOCKHISTORY Function

Determine YTD Stock Growth With Excel’s STOCKHISTORY Function

Summarizing Stock Data Microsoft Excel now has some great built-in functionalities to track stocks whether it be current or historical...

Pull Historical Stock Price Data in Excel

Pull Historical Stock Price Data in Excel

Get Stock Price History Directly From Excel! Stock Prices used to be a hassle to pull into Excel. I can...

Calculating Picture Frame Spacing in Excel (Inches)

Calculating Picture Frame Spacing in Excel (Inches)

The Chore of Hanging Pictures Often times when I find myself needing to hang multiple picture frames next to each...

Dynamically Reference Excel Tables Inside A Vlookup Function

Dynamically Reference Excel Tables Inside A Vlookup Function

In this article, we are going to explore how to reference a specific Excel Table object from a drop-down list...

How To Pull Cryptocurrency Prices In Excel

How To Pull Cryptocurrency Prices In Excel

Cryptocurrencies Now In Excel! When Excel received the capability to retrieve stock data directly within the spreadsheet via data types,...

All About Excel’s New LET Function

All About Excel’s New LET Function

Excel has released a new function in 2020 that will allow you to define variables within the scope of the...

7 Ways To Generate Unique Values List In Excel

7 Ways To Generate Unique Values List In Excel

There are many scenarios you may come across while working in Excel where you only desire unique values in a...

How To Use A Double XLOOKUP Formula

How To Use A Double XLOOKUP Formula

Have you heard of an XLOOKUP/XLOOKUP? No, I didn’t stutter in my writing….there is now such a thing as a...

How To Use Excel’s XLOOKUP Function [Guide 2022]

How To Use Excel’s XLOOKUP Function [Guide 2022]

On August 28th, 2019, Microsoft unveiled a new Excel function with the intent of making 3 beloved and rivaled functions...

Add Real-Time Stock Prices And Metrics To Excel

Add Real-Time Stock Prices And Metrics To Excel

We Finally Got It! On June 5th, 2019 Microsoft released a feature to Office 365 that allows Excel users to...

Find And Break All External Links In Excel File [Guide 2022]

Find And Break All External Links In Excel File [Guide 2022]

How To Break External Links So you're on a mission to break/remove external links from your Excel workbook, huh? Seems...

Use Yahoo! Finance To Pull Stock Information Into Excel

Use Yahoo! Finance To Pull Stock Information Into Excel

WARNING!!! As of Q3 2017, the Yahoo! Finance capabilities in Excel have been disabled (by Yahoo!, after Verizon bought them)....

Combining Text With The CONCAT and TEXTJOIN Excel Functions

Combining Text With The CONCAT and TEXTJOIN Excel Functions

Hey everyone! Chris here and I want to introduce you to a new Excel blog called Spreadsheeto. Bloggers Mikkel and...

Formulas To Calculate Longest & Current Win Streaks

Formulas To Calculate Longest & Current Win Streaks

All About The Wins As we start to head into the summer months here in the United States, I thought...

Why Does Excel Say Cell Values Are Not Equal When They Are?

Why Does Excel Say Cell Values Are Not Equal When They Are?

What's Wrong With Excel? I try to get on the Mr. Excel forums a few times a week and this...

[FREE Training] 10 Amazing Excel Efficiency Tricks. Why Don't People Know These?!

X