What Is a Tile Grid Map? A tile grid map is a visualization technique used to represent data related to...
Why I Made This List of 50 US States… I grew tired of searching for a well-formatted web page where...
Different Ways to Add Together Dynamic Array Formulas If you are trying to figure out how to apply the addition...
Linking Dynamic Array Formulas into Chart Series With the introduction of Dynamic Array functions in Excel, your spreadsheets can now...
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...
How to Alternate Shading Row Colors (Banded Rows) While Microsoft Excel does not have a dedicated row banding button to...
Introducing the New 2023 Microsoft Office Color Theme Over the years, we've seen the Microsoft Office suite undergo a plethora...
All The Icons For The Wingdings and Webdings Fonts Translated Hey there, design enthusiast! Have you ever stumbled upon those...
Purpose Of This Spreadsheet Country Listing I grew tired of searching for a well-formatted web page where I could easily...
Need A Great Spreadsheet Calendar Template? A spreadsheet calendar in Microsoft Excel can be a helpful tool for managing and...
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...
Stacked Bar Charts Missing Total Labels In Excel Unfortunately, Microsoft does not have the ability to insert data labels at...
Waterfall/Bridge charts are commonly used in the finance world to show up and down variances between two periods of time....
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...
Spreadsheet Sample Data in Excel & CSV Formats I have put this page together to provide everyone with data that...
Filter Function and Partial Matching (Wildcard) Criteria Unfortunately, as of this writing, the Filter function does not contain an input...
Steps To Add The Developer Tab In Excel For PCAdd The Developer Tab in Microsoft WordAdd The Developer Tab in...
Incorporating Checkmark Symbols Into Your Spreadsheets Symbols are great to incorporate into your Excel spreadsheets as they often can add...
Why Are The Columns/Rows Missing? If you landed on this article, you’ve probably been pulling your hair out trying to...
Creating A Search Box In Excel It's unfortunate Excel does not have a form control search box (maybe in the...
Interactive Excel CAGR Calculator Tool If you are looking for a way to quickly calculate a CAGR for a PowerPoint...
Make This Picture In Excel! Has your manager ever emailed you to put together a table or chart based on...
Why Can’t I Use Excel While In The Power Query Editor? For some insane reason, Microsoft decided it was necessary...
There are a few creative ways to add a vertical line to your chart bouncing around the internet. If you...
Why Excel Competency Is Important It’s truly amazing how much of the business world relies on Microsoft Excel. What is...
Map Charts In Excel Are Limited… Let’s face it, Excel’s built-in Map Chart feature seemingly was thrown together overnight. Its...
Quickly Learn Power Query Now! The goal of this guide/tutorial is to provide you with a great starting point in...
Why I Made This City List… I grew tired of searching for a well-formatted web page where I could easily...
Why Can’t I Type Forward Slash In Excel? Hopefully, you have landed on this page because you are quite confused...
Summarizing Stock Data Microsoft Excel now has some great built-in functionalities to track stocks whether it be current or historical...
Why I Created This Goal Tracker At the start of every new year, my wife and I have a tradition...
Why I Made This National Park List For a consulting project, I grew tired of searching for a well-formatted web...
Excel's row/column grouping functionality is a handy way to consolidate or provide a hierarchical order to your spreadsheet data. The...
The AutoSave Setting Since its release, Microsoft has elected to have their AutoSave feature (which constantly saves copies of your...
Get Stock Price History Directly From Excel! Stock Prices used to be a hassle to pull into Excel. I can...
There a many reasons why you might need to adjust your zoom levels while working in Excel. You might need...
Why Icon Fonts? Icon Fonts are fantastic in comparison to icon shapes because we can reference them in our formulas...
Why Do You Need A Blank Value Choice? Sometimes you may come across instances where you want to include an...
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,...
If you haven’t learned about Excel’s Power Query feature, you are missing out on a huge opportunity to create automated...
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...
Detecting Sheet Protection I can’t count how many times I have been completely confused while working in somebody else’s spreadsheet...
Excel for the web (aka Excel Online) now has scripting functionality akin to VBA! We are in the early stages...
Are you looking for a way to visually round up or down your numerical values without changing the underlying cell...
As I sit down to write this article, there are now only a few days remaining in the year 2019....
What Are Custom Number Formats? I love to explain number formats in Excel as the “clothing” of a spreadsheet cell....
Creating A Progress Bar In Excel Progress Bars are simple graphics that can be quite visually powerful by instantly providing...
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...
What Is The Office Insider Version? The “Insider” version of Office (formerly known as “Insider Fast”) is used to test...
We Finally Got It! On June 5th, 2019 Microsoft released a feature to Office 365 that allows Excel users to...
Today I’m going to give you behind-the-scenes access to all the equipment I use here at the TSG headquarters (aka...
By default Excel will convert text to a hyperlink if it determines your data is in a URL or email...
VBA is a coding language used by millions of people across the world to automate tasks in Microsoft Office products....
In this article, I am going to explain the process I use to create an emphasis effect on my userforms...
There’s No Middle Alignment Option… Let’s just get straight to the point….unfortunately for some (lame) reason, Microsoft did not give...
How To Break External Links So you're on a mission to break/remove external links from your Excel workbook, huh? Seems...
It's That Time Of Year Again! If you love analyzing numbers (and chances are if you are a fan of...
I came across this oddity today where I was going to print a report someone sent me and the data...
I am a HUGE advocate of not merging cells as they can cause all sorts of headaches while copying/pasting and...
As Microsoft continues to persuade people to sign up for their Office 365 subscription in lieu of purchasing individual copies...
Slicers Are Great, But Have Limitations Slicers are a great way to provide interactivity to your Excel spreadsheets. They allow...
Choices, Choices, & MORE Choices! With so many educational options available on the internet these days, it can be overwhelming...
WARNING!!! As of Q3 2017, the Yahoo! Finance capabilities in Excel have been disabled (by Yahoo!, after Verizon bought them)....
UPDATE: In July 2017, I received my second MVP award from Microsoft! Thank you for supporting this website and continuing...
What Are Add-ins? Add-ins for Excel are similar to the apps you can download and purchase for your smartphone. They...
Double Trouble I think we have all had our fair share of experiences getting weird outcomes because of duplicate data...
Why Center Across? I am a huge advocate for using the Excel functionality of Center Across Selection instead of Merge...
This is a frustration I seem to always face while creating dashboards or graphics for Excel reports. I create a...
Hey everyone! Chris here and I want to introduce you to a new Excel blog called Spreadsheeto. Bloggers Mikkel and...
Hey everyone! Chris here and I want to introduce you to instructor/blogger Rishabh Pugalia from YodaLearning.com. He has graciously offered to...
We Visualize Data, Why Not Commentary? Have you ever heard that age old phrase, "A picture is worth a thousand...
Checking Lottery Picks = Painful With the new trend of ginormous lottery jackpots, there seem to be more and more...
With all the excitement over the $900 Million PowerBall Jackpot this past weekend, I thought it would be interesting to...
I've been using bullet points inside Excel A LOT as of late and I thought I would share the many...
A Little Background I was literally pulling out my hair trying to figure out how to get my hands on...
Today, I came across a spreadsheet that allowed a user to connect to a remote database via VBA. The spreadsheet...
Our goal as analysts is to tell a story with our data and it is a well-known fact that data...
Wishful Thinking? Have you ever had a time where you wished you could write an IF formula in Excel based on...
Your Excel Resource Guide I'm sure every Excel blog out there has some sort of directory page with recommendations of...
What Is A Waterfall Chart? The main goal of a Waterfall chart is to walk the audience through how one...
Everybody Should Have One! I'm currently going through a reorganization with my day job and I'm going to be interacting...
Shortcuts For Currencies Labeling your data is extremely important as it increases the comprehensibility and decreases false assumptions. As world markets...
Protecting Your Excel Files With A Password There are often files within an organization that need to be restricted from certain...
Restricting Your User's Abilities Microsoft Excel's worksheet password protection options have been known to trip people up from time to...
Microsoft's more recent versions of Outlook (2007 and later) seem to not want to run GIF images inside email messages....
How Secure is Excel? There is not a great deal of documentation out there about how Excel handles password security,...
A Quick Demo Using The Solution Do You Have This Pivot Table Problem? I absolutely hate wasting time! Any time...
All About The Wins As we start to head into the summer months here in the United States, I thought...
In my previous post VBA For Excel's Form Control Combo Boxes, I showed you all the different actions you can...
The "To-Date" Column I was first introduced to this concept a few years ago when I first started working in...
What's Wrong With Excel? I try to get on the Mr. Excel forums a few times a week and this...
What's With All These Fancy Animations? When I first played around with Excel 2013 the new navigation animations were one...
There are definitely times when you are handling confidential data and want to make sure that data stays confidential. This...
Preventing The TODAY( ) Function From Changing This is going to be a brief post, but I came across this...
What Is AutoFit Column Width & AutoFit Row Height? This is a feature that I tend to use a lot...
They Just Don't Mix Well What do you get when you put a cell Note Box right next to a...
What Is Center Across Selection? If you are like most people (me included for quite some time), I suspect you...
I Finally Did It! I’ve thought long and hard about what epic topic I would cover for my very first...
![[Solved] Excel Found A Problem With Formula References In This Worksheet](https://www.thespreadsheetguru.com/wp-content/uploads/2023/08/Excel-Found-Problem-With-Formula-References.svg)
![3 Ways To Alternate Row Colors in Excel [Guide]](https://www.thespreadsheetguru.com/wp-content/uploads/2022/12/Excel-Alternate-Row-Colors-on-Cell-Range.png)
![VLOOKUP Practice Example File [With Solutions]](https://www.thespreadsheetguru.com/wp-content/uploads/2023/04/Learn-Excel-Vlookup-Function.png)
![Which Excel Versions Have XLOOKUP Function? [Solved]](https://www.thespreadsheetguru.com/wp-content/uploads/2022/10/DoIHaveXLOOKUP.png)
![Free Example Data Sets For Spreadsheets [Instant Download]](https://www.thespreadsheetguru.com/wp-content/uploads/2022/10/SpreadsheetSampleData.png)
![How To Show The Developer Ribbon Tab [With Pictures]](https://www.thespreadsheetguru.com/wp-content/uploads/2022/10/UnlockOfficeDeveloperTab.png)
![4 PRO Ways to Create A Filtering Search Box [Excel Download]](https://www.thespreadsheetguru.com/wp-content/uploads/2022/10/ExcelFilteringSearchBox.png)
![Add Vertical Lines To Excel Charts Like A Pro! [Guide]](https://www.thespreadsheetguru.com/wp-content/uploads/2022/05/AddVerticalLineToExcelBarorLineChart.png)
![Excel Guru’s Top Interview Questions To Ask [What I Look For]](https://www.thespreadsheetguru.com/wp-content/uploads/2022/12/Best-Excel-Skills-Interview-Questions.png)
![Quickly Learn Excel’s Power Query Tool [Guide 2022]](https://www.thespreadsheetguru.com/wp-content/uploads/2022/12/PowerQueryGuide.png)
![How To Use Excel’s XLOOKUP Function [Guide 2022]](https://www.thespreadsheetguru.com/wp-content/uploads/2022/12/Microsoft-Excel-XLOOKUP-Function-Guide.png)
![Will VBA Die in 2022? Is It Worth Learning? [Inside Scoop]](https://www.thespreadsheetguru.com/wp-content/uploads/2022/12/Is-VBA-Dead-the-current-state-of-the-Visual-Basic-Language.png)
![Find And Break All External Links In Excel File [Guide 2022]](https://www.thespreadsheetguru.com/wp-content/uploads/2022/12/Excel-Guide-to-Breaking-External-Links.png)
![How To Prevent Copy/Paste Merged Cell Errors [Solved!]](https://www.thespreadsheetguru.com/wp-content/uploads/2022/12/PreventCopyMergedCellErrors.png)
