Featured Tutorials
More than 100 Free Excel Tutorials in 1 Place
Over 100 Excel Tutorials in ONE Place The links in this file are updated on a monthly basis. Check back to get the latest file. On my YouTube channel, I often get questions like: "Do you have a video on *specific* topic?" or "How can I do *this* Excel task?" Actually, a lot of the videos on my channel are from you.
Formulas
Convert Numbers to Words
Excel Formula to Convert Numbers to Words One of the most asked for Excel features is the ability to turn a number into words. Because many people need this ability, and Excel does not currently possess such a feature, the old saying “Necessity is the mother of invention” took over. One
Change CASE of text in Excel (3 ways including NO Formulas)
Change CASE of text in Excel (3 ways including NO Formulas) How do we change the case of text in Excel to normalize our data or to fix casing errors? Changing lower case text to upper case text, upper case text to proper case text (where the first letter is upper
Excel RANK without Skipping Numbers (Top 3 Report with Duplicates)
Excel RANK without Skipping Numbers (Top 3 Report with Duplicates) Let's look at Excel’s ranked function. How can you rank your values in descending or ascending order and how can you rank duplicate values without skipping numbers in the sequence?es. Let's look
Dashboards
Reset Dependent Drop-down in Excel
Reset Dependent Drop-down in Excel (with a tiny bit of VBA) Learn how to reset a dependent drop-down list in Excel with a little bit of VBA. The problem we get with dependent data validation lists is that when you change the value of the first data validation, the value for the
Excel Dependent Combo Box Solves an Annoying Problem
This Excel Dependent Combo Box Solves an Annoying Problem (you've probably had this) In this tutorial you'll learn a lot about combo box drop-down lists in Excel: 1. How to create a combo box drop-down list 2. How to create a dependent Combo Box drop-down. 3. How to restrict the combo
How to Create a Sales Funnel Chart in Excel (Not the “usual” Funnel)
How to Create a Sales Funnel Chart in Excel (Not the "usual" Funnel) Excel 2016 has a built-in sales funnel graph, but what it doesn't have is a funnel chart that looks like a funnel. In this tutorial I show you how you can tweak the existing funnel chart to make
Charts
Charting Survey Results in Excel
Charting Survey Results in Excel (Visualize Employee Satisfaction results) This post spotlights a practical way to visualize survey results in Excel, particularly surveys that follow a “like/hurt” format. Surveys, like employee surveys, that provide a range of choices between “Strongly Disagree” to “Strongly Agree”, or simpler surveys that provide “Disagree-Neutral-Agree” options.
Highlight Max & Min Values in an Excel Line Chart
Highlight Max & Min Values in an Excel Line Chart (Conditional Formatting in Charts) Is it possible to call attention to the highest and lowest values in a line chart dynamically? Can we color or accent these values in the line chart when our data changes? Can we have the colors
3 Handy Excel Chart Tips You Might Have Missed
3 Handy Excel Chart Tips You Might Have Missed This post will focus on three little-known chart features that will save you time when creating reports include charts. Let’s see how many you know versus how many are new to you. Two
Features
Why you SHOULD be USING Custom Number Formatting
Why you SHOULD be USING Custom Number Formatting in Excel Let’s see a few Excel Custom Number Formatting tips that will not only save you time, but also help you avoid common spreadsheet mistakes. First, we’ll see the formatting in action and how it helps tell our story in the most
Change HORIZONTAL Data to VERTICAL
Excel HACK: Change HORIZONTAL Data to VERTICAL (NO Transpose Function needed) Efficiency is a key objective here at XelPlus, but sometimes even the best of us miss the mark. In a previous post, we discussed three different ways to transpose data in Excel. The third method discussed was more of a
Excel shortcut keys you SHOULD know!
Excel shortcut keys you SHOULD know! This post‘s topic is one the most requested topics for the site. SHORTCUTS!!!! These are keyboard shortcuts that EVERY Excel user needs to know, practice, and commit to muscle memory. From the beginning Excel user to the most advanced power-user ninja; knowing these shortcuts will
VBA
Excel List Box to Display & Print Multiple Sheets as ONE Print Job with VBA
Excel List Box to Display & Print Multiple Sheets as ONE Print Job with VBA This post will show you how to create an Excel macro that will allow you to print specific worksheets by selecting them form an automatically generated list. Our goal is to create an ActiveX list box
3 Methods to Unhide All Sheets in Excel (& how to hide)
3 Methods to Unhide All Sheets in Excel (& how to hide) How can you unhide all Excel sheets at once? Hiding many worksheets at once is easy in Excel. Click on a sheet, hold down the control or the shift key, click on the other sheets you'd like to hide,
How to use the Message Box in Excel VBA
How to use the Message Box in Excel VBA (syntax you'll need for MsgBox) In this tutorial you'll quickly learn the correct syntax to create a VBA message box (also referred to as a pop-up dialogue box) in Excel. I first show you how to create a message box that displays
DYNAMIC ARRAYS
Searchable Drop Down List in Excel (Very Easy with Dynamic Arrays)
Searchable Drop Down List in Excel (Very Easy with Dynamic Arrays) “Does Excel have a feature to allow a Data Validation list to be searchable?” This is a common question asked on this site and most any Excel training venue. What do we mean by a searchable Data Validation list? Let’s
Excel Dynamic Arrays – Excel will never be the same
Excel Dynamic Arrays - New Functions and Calculation Methods Dynamic Array formulas are new to Excel Office 365. Microsoft has listened to our requests and designed a set of functions that will completely change the way we use Excel. After this, everything will change! You'll be using simple Excel formulas for
OTHER NEWS
3 PowerPoint HACKS for INSTANT Improvement
3 PowerPoint HACKS for INSTANT Improvement (incl. Morph between Shapes) This post will introduce you to three PowerPoint techniques that you can use to impress your colleagues and boss. They will think you spent HOURS honing and crafting your presentation… …but you won’t. This will be our little secret.
Have You Tried These PowerPoint Presentation Tips?
Have You Tried These PowerPoint Presentation Tips? This post is a bit of a departure from the norm. Instead of discussing some lifechanging Excel feature, let’s talk about delivering better presentations. I want to share three tips that helped me create more effective PowerPoint slides and deliver the aforementioned better presentations.
Excel Dynamic Arrays – Excel will never be the same
Excel Dynamic Arrays - New Functions and Calculation Methods Dynamic Array formulas are new to Excel Office 365. Microsoft has listened to our requests and designed a set of functions that will completely change the way we use Excel. After this, everything will change! You'll be using simple Excel formulas for