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
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
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
Excel VBA: Check If File or Folder Exists (DIR) Open File or Create Folder The DIR VBA function plays an important role if you need to refer to other files or folders in your macro. DIR returns a string that represents a directory
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
3 Ways to Transpose Excel Data (Rotate data from Horizontal to Vertical or Vice Versa) Check out 3 ways to Transpose your data in Excel. These are useful when you want to switch the orientation of your data from columns to rows
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
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
Excel Sort (by Value, Color, Icon, Own List) & How to Unsort Sorting is super easy in Excel! You'll learn how to sort by values (ascending, descending), how to sort alphabetically & much more.
How can you make navigation easier for your larger workbooks? You could create an ActiveX combo-box that automatically adds the sheet names to the drop-down. Once the user selects a sheet, they jump to the respective sheet. If the user deletes a sheet, renames