Excel Formulas - TheSpreadsheetGuru

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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