×

Excel

Build A Tile Grid Map of The United States In Excel

Build A Tile Grid Map of The United States In Excel

What Is a Tile Grid Map? A tile grid map is a visualization technique used to represent data related to...

List of the 50 States, Abbreviations, & Capitals

List of the 50 States, Abbreviations, & Capitals

Why I Made This List of 50 US States… I grew tired of searching for a well-formatted web page where...

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

Dynamic Array Formula Spill Ranges With Charts

Dynamic Array Formula Spill Ranges With Charts

Linking Dynamic Array Formulas into Chart Series With the introduction of Dynamic Array functions in Excel, your spreadsheets can now...

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

3 Ways To Alternate Row Colors in Excel [Guide]

3 Ways To Alternate Row Colors in Excel [Guide]

How to Alternate Shading Row Colors (Banded Rows) While Microsoft Excel does not have a dedicated row banding button to...

Microsoft Office 2023 Theme Color Update

Microsoft Office 2023 Theme Color Update

Introducing the New 2023 Microsoft Office Color Theme Over the years, we've seen the Microsoft Office suite undergo a plethora...

Wingdings & Webdings Font Icon Character Map (Printable Cheat Sheet)

Wingdings & Webdings Font Icon Character Map (Printable Cheat Sheet)

All The Icons For The Wingdings and Webdings Fonts Translated Hey there, design enthusiast! Have you ever stumbled upon those...

Clean List of World Countries, Abbreviations, & Capitals For Spreadsheets

Clean List of World Countries, Abbreviations, & Capitals For Spreadsheets

Purpose Of This Spreadsheet Country Listing I grew tired of searching for a well-formatted web page where I could easily...

Printable Blank Calendar Templates For 2023

Printable Blank Calendar Templates For 2023

Need A Great Spreadsheet Calendar Template? A spreadsheet calendar in Microsoft Excel can be a helpful tool for managing and...

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

Add Total Value Labels to Stacked Bar Chart in Excel (Easy)

Add Total Value Labels to Stacked Bar Chart in Excel (Easy)

Stacked Bar Charts Missing Total Labels In Excel Unfortunately, Microsoft does not have the ability to insert data labels at...

How To Build Waterfall (Bridge) Charts In Excel

How To Build Waterfall (Bridge) Charts In Excel

Waterfall/Bridge charts are commonly used in the finance world to show up and down variances between two periods of time....

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

Free Example Data Sets For Spreadsheets [Instant Download]

Free Example Data Sets For Spreadsheets [Instant Download]

Spreadsheet Sample Data in Excel & CSV Formats I have put this page together to provide everyone with data that...

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 Show The Developer Ribbon Tab [With Pictures]

How To Show The Developer Ribbon Tab [With Pictures]

Steps To Add The Developer Tab In Excel For PCAdd The Developer Tab in Microsoft WordAdd The Developer Tab in...

How To Write A Checkmark Symbol Formula in Excel

How To Write A Checkmark Symbol Formula in Excel

Incorporating Checkmark Symbols Into Your Spreadsheets Symbols are great to incorporate into your Excel spreadsheets as they often can add...

My Excel Columns Or Rows Not Hidden But Missing?!

My Excel Columns Or Rows Not Hidden But Missing?!

Why Are The Columns/Rows Missing? If you landed on this article, you’ve probably been pulling your hair out trying to...

4 PRO Ways to Create A Filtering Search Box [Excel Download]

4 PRO Ways to Create A Filtering Search Box [Excel Download]

Creating A Search Box In Excel It's unfortunate Excel does not have a form control search box (maybe in the...

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

How To Get Data From A Picture In Excel

How To Get Data From A Picture In Excel

Make This Picture In Excel! Has your manager ever emailed you to put together a table or chart based on...

Use Power Query and Excel At The Same Time

Use Power Query and Excel At The Same Time

Why Can’t I Use Excel While In The Power Query Editor? For some insane reason, Microsoft decided it was necessary...

Add Vertical Lines To Excel Charts Like A Pro! [Guide]

Add Vertical Lines To Excel Charts Like A Pro! [Guide]

There are a few creative ways to add a vertical line to your chart bouncing around the internet. If you...

Excel Guru’s Top Interview Questions To Ask [What I Look For]

Excel Guru’s Top Interview Questions To Ask [What I Look For]

Why Excel Competency Is Important It’s truly amazing how much of the business world relies on Microsoft Excel. What is...

Build A United States Dashboard Map Chart In Excel

Build A United States Dashboard Map Chart In Excel

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 Excel’s Power Query Tool [Guide 2022]

Quickly Learn Excel’s Power Query Tool [Guide 2022]

Quickly Learn Power Query Now! The goal of this guide/tutorial is to provide you with a great starting point in...

List of Top 50 Largest Cities in United States

List of Top 50 Largest Cities in United States

Why I Made This City List… I grew tired of searching for a well-formatted web page where I could easily...

Why Forward-Slash (/) Key Does Not Work in Excel

Why Forward-Slash (/) Key Does Not Work in Excel

Why Can’t I Type Forward Slash In Excel? Hopefully, you have landed on this page because you are quite confused...

List of Top 50 Largest Cities In The World

List of Top 50 Largest Cities In The World

Why I Made This City List… I grew tired of searching for a well-formatted web page where I could easily...

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

New Years Resolution Goal Tracker

New Years Resolution Goal Tracker

Why I Created This Goal Tracker At the start of every new year, my wife and I have a tradition...

Simple List of National Parks In The United States

Simple List of National Parks In The United States

Why I Made This National Park List For a consulting project, I grew tired of searching for a well-formatted web...

How To Change Excel’s Group Outline Direction Settings

How To Change Excel’s Group Outline Direction Settings

Excel's row/column grouping functionality is a handy way to consolidate or provide a hierarchical order to your spreadsheet data. The...

How To Turn Off Excel’s AutoSave By Default

How To Turn Off Excel’s AutoSave By Default

The AutoSave Setting Since its release, Microsoft has elected to have their AutoSave feature (which constantly saves copies of your...

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

5 Ways to Zoom In/Out of your Spreadsheet Window

5 Ways to Zoom In/Out of your Spreadsheet Window

There a many reasons why you might need to adjust your zoom levels while working in Excel. You might need...

The Amazing Hidden Icon/Symbol Font Inside Excel (Not Wingdings!)

The Amazing Hidden Icon/Symbol Font Inside Excel (Not Wingdings!)

Why Icon Fonts? Icon Fonts are fantastic in comparison to icon shapes because we can reference them in our formulas...

Adding A Blank Option in a Data Validation Drop Down List in Excel

Adding A Blank Option in a Data Validation Drop Down List in Excel

Why Do You Need A Blank Value Choice? Sometimes you may come across instances where you want to include an...

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

Override Values With Formula Using Power Query

Override Values With Formula Using Power Query

If you haven’t learned about Excel’s Power Query feature, you are missing out on a huge opportunity to create automated...

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

Determining When An Excel Spreadsheet Is Protected

Determining When An Excel Spreadsheet Is Protected

Detecting Sheet Protection I can’t count how many times I have been completely confused while working in somebody else’s spreadsheet...

How To Enable Office Scripts For Excel Online

How To Enable Office Scripts For Excel Online

Excel for the web (aka Excel Online) now has scripting functionality akin to VBA! We are in the early stages...

Custom Number Format: Round To Nearest Thousands

Custom Number Format: Round To Nearest Thousands

Are you looking for a way to visually round up or down your numerical values without changing the underlying cell...

5 Excel Features I’m Excited To Use in 2020

5 Excel Features I’m Excited To Use in 2020

As I sit down to write this article, there are now only a few days remaining in the year 2019....

Writing Your Own Custom Number Formats in Excel

Writing Your Own Custom Number Formats in Excel

What Are Custom Number Formats? I love to explain number formats in Excel as the “clothing” of a spreadsheet cell....

How To Create Excel Progress Bar Charts (Professional-Looking!)

How To Create Excel Progress Bar Charts (Professional-Looking!)

Creating A Progress Bar In Excel Progress Bars are simple graphics that can be quite visually powerful by instantly providing...

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

How To Install Office 365 Insider Fast Version

How To Install Office 365 Insider Fast Version

What Is The Office Insider Version? The “Insider” version of Office (formerly known as “Insider Fast”) is used to test...

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

TSG HQ – My Home Office Setup

TSG HQ – My Home Office Setup

Today I’m going to give you behind-the-scenes access to all the equipment I use here at the TSG headquarters (aka...

Prevent Auto-Hyperlinking In Excel

Prevent Auto-Hyperlinking In Excel

By default Excel will convert text to a hyperlink if it determines your data is in a URL or email...

Will VBA Die in 2022? Is It Worth Learning? [Inside Scoop]

Will VBA Die in 2022? Is It Worth Learning? [Inside Scoop]

VBA is a coding language used by millions of people across the world to automate tasks in Microsoft Office products....

Creating Userform Buttons That Highlight Mouse Hovering

Creating Userform Buttons That Highlight Mouse Hovering

In this article, I am going to explain the process I use to create an emphasis effect on my userforms...

How To Vertically Center A Userform Textbox

How To Vertically Center A Userform Textbox

There’s No Middle Alignment Option… Let’s just get straight to the point….unfortunately for some (lame) reason, Microsoft did not give...

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

Christmas Expense & Budget Tracker Excel Template (Free!)

Christmas Expense & Budget Tracker Excel Template (Free!)

It's That Time Of Year Again! If you love analyzing numbers (and chances are if you are a fan of...

Troubleshooting Excel Print Margins

Troubleshooting Excel Print Margins

I came across this oddity today where I was going to print a report someone sent me and the data...

One Instance When Merging Cells Is Needed!

One Instance When Merging Cells Is Needed!

I am a HUGE advocate of not merging cells as they can cause all sorts of headaches while copying/pasting and...

Excel Weaknesses: A Wishlist For Much Needed Improvements

Excel Weaknesses: A Wishlist For Much Needed Improvements

As Microsoft continues to persuade people to sign up for their Office 365 subscription in lieu of purchasing individual copies...

How To Customize The Order Of Your Excel Slicer Buttons

How To Customize The Order Of Your Excel Slicer Buttons

Slicers Are Great, But Have Limitations Slicers are a great way to provide interactivity to your Excel spreadsheets. They allow...

Best Online Excel & VBA Courses (2022)

Best Online Excel & VBA Courses (2022)

Choices, Choices, & MORE Choices! With so many educational options available on the internet these days, it can be overwhelming...

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

My First Microsoft Excel MVP Award!

My First Microsoft Excel MVP Award!

UPDATE: In July 2017, I received my second MVP award from Microsoft! Thank you for supporting this website and continuing...

Top Microsoft Excel Add-ins You Should Consider Using

Top Microsoft Excel Add-ins You Should Consider Using

What Are Add-ins? Add-ins for Excel are similar to the apps you can download and purchase for your smartphone. They...

How To Find And Remove Duplicate Excel Cell Data

How To Find And Remove Duplicate Excel Cell Data

Double Trouble I think we have all had our fair share of experiences getting weird outcomes because of duplicate data...

How To Add A Center Across Selection Button To Excel’s Home Ribbon Tab

How To Add A Center Across Selection Button To Excel’s Home Ribbon Tab

Why Center Across? I am a huge advocate for using the Excel functionality of Center Across Selection instead of Merge...

Retain Font Formats After Changing An Excel Shape’s Formula

Retain Font Formats After Changing An Excel Shape’s Formula

This is a frustration I seem to always face while creating dashboards or graphics for Excel reports. I create a...

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

Best Excel Keyboard Shortcuts For Editing Columns & Rows

Best Excel Keyboard Shortcuts For Editing Columns & Rows

Hey everyone! Chris here and I want to introduce you to instructor/blogger Rishabh Pugalia from YodaLearning.com. He has graciously offered to...

Adding Tickmark Indicators To Your Excel Analysis Comments

Adding Tickmark Indicators To Your Excel Analysis Comments

We Visualize Data, Why Not Commentary? Have you ever heard that age old phrase, "A picture is worth a thousand...

Excel PowerBall Lottery Ticket Checker Spreadsheet

Excel PowerBall Lottery Ticket Checker Spreadsheet

Checking Lottery Picks = Painful With the new trend of ginormous lottery jackpots, there seem to be more and more...

Excel PowerBall Lottery Simulator Spreadsheet

Excel PowerBall Lottery Simulator Spreadsheet

With all the excitement over the $900 Million PowerBall Jackpot this past weekend, I thought it would be interesting to...

Adding Bullet Points To Your Excel Spreadsheet Cells & Text Boxes

Adding Bullet Points To Your Excel Spreadsheet Cells & Text Boxes

I've been using bullet points inside Excel A LOT as of late and I thought I would share the many...

How To Get Office 2016 With A 365 ProPlus Account

How To Get Office 2016 With A 365 ProPlus Account

A Little Background I was literally pulling out my hair trying to figure out how to get my hands on...

Masking (Hiding) A Password As It Is Entered In An Excel Text Box

Masking (Hiding) A Password As It Is Entered In An Excel Text Box

Today, I came across a spreadsheet that allowed a user to connect to a remote database via VBA. The spreadsheet...

Create A Bar Chart With Separate Positive And Negative Colors

Create A Bar Chart With Separate Positive And Negative Colors

Our goal as analysts is to tell a story with our data and it is a well-known fact that data...

Using Cell Formatting Logic With Excel Formulas

Using Cell Formatting Logic With Excel Formulas

Wishful Thinking?  Have you ever had a time where you wished you could write an IF formula in Excel based on...

Online Excel & VBA Blog Resources

Online Excel & VBA Blog Resources

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 (Bridge) Chart

What Is A Waterfall (Bridge) Chart

What Is A Waterfall Chart? The main goal of a Waterfall chart is to walk the audience through how one...

Printable Excel Contact List With Dynamic Dotted Underlines

Printable Excel Contact List With Dynamic Dotted Underlines

Everybody Should Have One! I'm currently going through a reorganization with my day job and I'm going to be interacting...

PC & Mac Financial Currency Keyboard Shortcuts

PC & Mac Financial Currency Keyboard Shortcuts

Shortcuts For Currencies Labeling your data is extremely important as it increases the comprehensibility and decreases false assumptions.  As world markets...

How To Password Protect Opening An Excel File

How To Password Protect Opening An Excel File

Protecting Your Excel Files With A Password There are often files within an organization that need to be restricted from certain...

The Various Ways To Password Protect Excel Worksheets

The Various Ways To Password Protect Excel Worksheets

Restricting Your User's Abilities Microsoft Excel's worksheet password protection options have been known to trip people up from time to...

How To Run Animated GIF images in Outlook 2007, 2010, & 2013

How To Run Animated GIF images in Outlook 2007, 2010, & 2013

Microsoft's more recent versions of Outlook (2007 and later) seem to not want to run GIF images inside email messages....

Understanding Excel’s Password Security Methodology

Understanding Excel’s Password Security Methodology

How Secure is Excel? There is not a great deal of documentation out there about how Excel handles password security,...

Quickly Change Pivot Table Field Calculation From Count To Sum

Quickly Change Pivot Table Field Calculation From Count To Sum

A Quick Demo Using The Solution Do You Have This Pivot Table Problem? I absolutely hate wasting time!  Any time...

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

Scroll To Chart Based on Form Control Combo Box Selection

Scroll To Chart Based on Form Control Combo Box Selection

In my previous post VBA For Excel's Form Control Combo Boxes, I showed you all the different actions you can...

Hiding A To-Date Column When Reporting Month or Quarter End Results

Hiding A To-Date Column When Reporting Month or Quarter End Results

The "To-Date" Column I was first introduced to this concept a few years ago when I first started working in...

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

How To Disable (Turn Off) Excel 2013’s In-Window Animations

How To Disable (Turn Off) Excel 2013’s In-Window Animations

What's With All These Fancy Animations? When I first played around with Excel 2013 the new navigation animations were one...

The “Security Effect” – How To Create Partially Anonymous Data

The “Security Effect” – How To Create Partially Anonymous Data

There are definitely times when you are handling confidential data and want to make sure that data stays confidential.  This...

Shortcut To Insert Today’s Date in Excel

Shortcut To Insert Today’s Date in Excel

Preventing The TODAY( ) Function From Changing This is going to be a brief post, but I came across this...

Why Can’t My Row Height Automatically Adjust?!

Why Can’t My Row Height Automatically Adjust?!

What Is AutoFit Column Width & AutoFit Row Height? This is a feature that I tend to use a lot...

How To Resolve Cell Notes/Freeze Panes Issues

How To Resolve Cell Notes/Freeze Panes Issues

They Just Don't Mix Well What do you get when you put a cell Note Box right next to a...

How To Prevent Copy/Paste Merged Cell Errors [Solved!]

How To Prevent Copy/Paste Merged Cell Errors [Solved!]

What Is Center Across Selection? If you are like most people (me included for quite some time), I suspect you...

A Guru State Of Mind

A Guru State Of Mind

I Finally Did It! I’ve thought long and hard about what epic topic I would cover for my very first...