Unlock Excel VBA & Macros Course is here!
22 hours top quality content!
Over 50 Excel mcro examples for download & useful VBA codes you can use for your work.
Get my Top 10 Excel Formulas eBook
Latest Tutorials
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
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
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
Excel VBA: Check If File or Folder Exists (DIR)
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
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
Trusted by
