Formulas
Quick Excel Trick to Unstack Data from One Column to Multiple Columns
Quick Excel Trick to Unstack Data from one Column to Multiple Columns In this Excel tutorial, we'll take a look at the easiest method of unstacking data. The great thing about this method is that it's dynamic, so if your source data changes, the stacked version updates automatically.
Count Day of Week Between Dates in Excel (How many Fridays?)
Count Day of Week Between Dates in Excel (How many Fridays?) How can you figure out how many Friday's are included between two days? For example, if our start date is December 3, 2018 and our end date is December 22, 2018 the answer should be 3. What do you think?
Excel SUM based on Partial Text Match (SUMIFS with wildcards)
Excel SUM based on Partial Text Match (SUMIFS with Wildcards) Learn how to SUM values in Excel based on a partial text match. This is great for cases when you need to sum a column based on "criteria contains" a specific value or text. For these cases you can use Excel's SUMIF
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
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
Creative Infographics in Excel
Creative infographics in Excel(Male, Female icons) Using fillable icons on charts is a good way to visualize data. In this example, the male and female icons will be used. To do this:Set up the data tableInsert a clustered column chartInsert icons into the chartFormat the chart axisOverlap the seriesFormat the chart area
How to create a Step Chart in Excel
This tutorial is a Step by Step approach to creating a Step Chart in Excel from Scratch. You can also download the template from the link below. What is a Step Chart? A Step Chart is great for visualizing variables that change on an irregular basis. It can be used to visualize inventory or
Features
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,
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
Change the Number Format of a Cell Based on a Condition in Excel
Change the Number Format of a Cell Based on a Condition Quickly learn how to change the number format of a cell based on the value of another cell. In this example, I show you how you can format a cell so its number format switches between currency and no currency.
VBA
Data types, DIM & SET (Learn to use them correctly)
Data Types, DIM & SET (Learn to use them correctly) “Data types for variables. Why are they important? Why do we need them?” These are very good questions. To be honest, you can write perfectly acceptable programs and procedures without using data types. The reason programmers don’t do this is because
Loop Through Cells Inside the Used Range (For Each Collection Loop)
Excel VBA: Loop through cells inside the used range (For Each Collection Loop) In this video we count the number of cells that contain formulas on our worksheet. We do this with Excel VBA with the help of the For Each Collection loop. This allows us to loop through each cell
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
OTHER NEWS
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,
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
First Excel Hash Challenge between 6 MVPs
What is #ExcelHash? It's the Iron Chef Tournament between 6 Excel MVP YouTubers. If you're serious about learning Excel, you've probably come across their videos: Mike Girvin from Excel is Fun; Bill Jelen from MrExcel; Mynda Treacy from MyOnlineTrainingHub; Jon Acampora from Excel Campus; Oz from Excel on Fire and myself: Leila Gharani. On September