Excel - TheSpreadsheetGuru

Excel Charts

See all the guides »

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

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

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

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

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

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

Excel Dashboards

See all the guides »

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

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

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

Excel Data Cleanup

See all the guides »

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

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

Excel Data Samples

See all the guides »

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

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

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

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

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

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

Excel Formatting

See all the guides »

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

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

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

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

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

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 Formulas

See all the guides »

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

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

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]

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!

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

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

Excel Graphics

See all the guides »

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

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

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

See all the guides »

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

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

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

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

Excel Pivot Tables

See all the guides »

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

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

Excel Power Query

See all the guides »

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

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

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

Excel Protection

See all the guides »

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

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

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

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

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

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

Excel Settings

See all the guides »

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

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

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

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

Excel QAT Setups From Some Of The Excel Community’s Finest

What's a QAT? QAT is short for Quick Access Toolbar and this bar is typically setup to store frequently used Excel functionalities;...

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

Excel Spreadsheet Grid

See all the guides »

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

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

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

Troubleshooting Excel Print Margins

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

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

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

Excel Templates

See all the guides »

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

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

Populate A PowerPoint Quiz From Excel With VBA

A couple months ago I received an email from Titus who was looking for a way to easily populate and...

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

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

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

Excel Userforms

See all the guides »

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

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