Excel Forum
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



  • NOW() - Display The Current Time in Excel  
  • How to Find and Fix Errors in Complex Formulas in Excel  
  • How to Use Multiple Functions and Formulas in a Single Cell in Excel  
  • MODE() - Find Most Repeated Value in a List in Excel  
  • Error Values in Excel - Full Explanation  
  • Quickly See All Cells linked to a Formula or Function in Excel  
  • Enter a Constant Value in a Defined Name in Excel - Text, Numbers, Formulas, Etc.  
  • Quickly Convert Formulas into Their Output Values in Excel  
  • Dynamic Named Range in Excel  
  • Stop Formula Calculation in Excel - Increase Worksheet Performance  
  • OFFSET Function in Excel  
  • Dynamic Formulas that Update When you Add Data in Excel  
  • 3D References - Formulas that Reference Multiple Sheets at Once in Excel  
  • Display all Formulas at Once in Excel  
  • Generate Random Numbers within a Range in Excel  
  • Round Numbers Up or Down in Excel  
  • AND Function - Check if All Arguments are True  
  • OR Function - Check if Any Argument is True  
  • Get the Row or Column Number of a Cell in Excel  
  • REPT Function in Excel - Repeat Values  
  • Count the Number of Unique Values in a List in Excel  
  • Using Parentheses in Excel  
  • Show All Formulas in a Worksheet in Excel  
  • Check if Cell is Empty or Not in Excel  
  • Calculate Percent Change in Excel  
  • Nest IF Statements in Excel  
  • Make Complex Formulas for Conditional Formatting in Excel  
  • Wildcards in Excel  
  • Manually Calculate Formulas and Functions in Excel  
  • Multiply by True and False in Excel  
  • SUMIFS - Sum Values Based on Multiple Criteria in Excel  
  • Excel Formulas Won't Update  
  • CHOOSE Function in Excel  
  • Convert Numbers into True and False in Excel  
  • Sum Values from Every X Number of Rows in Excel  
  • SUMIF - Sum Values Based on Criteria in Excel  
  • Sum Values that Equal 1 of Many Conditions across Multiple Columns in Excel  
  • Sum Values that Meet 1 of Multiple Conditions in Excel  
  • Sum a Range with Errors in Excel  
  • Sum the Visible Rows from a Filtered List in Excel  
  • Average the Visible Rows in a Filtered List in Excel  
  • MAX and MIN Values from a Filtered List in Excel  
  • Count Cells Containing TRUE or FALSE in Excel  
  • Count the Errors in a Range in Excel  
  • Average Cells Excluding Zeros in Excel  
  • Count Blank Cells in Excel  
  • SMALL Function - Get the Lowest Values from a List in Excel  
  • LARGE Function - Get the Highest Values from a List in Excel  
  • Partial Match Lookup with Numbers in Excel  
  • Find the Most Frequently Occurring Value in a List in Excel  
  • SUBTOTAL Function - Work on Filtered Data in Excel  
  • MOD Function in Excel  
  • Odd or Even Row Formulas in Excel  
  • Easy Excel Formulas Every N Rows - Not an Array  
  • INDIRECT Function in Excel - Powerful Range References  
  • SUMPRODUCT in Excel - Introduction  
  • Check Multiple Conditions in Excel - 5 Awesome Tips and Tricks  
  • yt embed test 2  
  • Amazing 3D Formulas in Excel  
  • 5 Tips for Evaluating Complex Formulas in Excel  
  • Deconstructing Complex Formulas in Excel  
  • Prevent Errors From Appearing in Excel  
  • Guide to Referencing Other Excel Files with Formulas and Functions  
  • Regular Expression Search Formula in Excel - Regex  
  • PI() Function in Excel - Math not Food  
  • SEARCH() vs FIND() Function in Excel  
  • Make Better IF Statements in Excel - Learn to Convert Complex Formulas into True False Values  
  • SEQUENCE() Function - Excel 365 New Function for List Making  
  • SORTBY() - New Excel 365 Function to Sort Data  
  • Excel 365 Wildcard Vlookup to Return All Partial Matches  
  • NOT Function - Change False to True and True to False in Excel  
  • UNIQUE() Function - Excel 365 Function for Removing Duplicates  
  • IF() Statement Function in Excel - How to use it  
  • 5 Powerful Techniques for Building Advanced Formulas  
  • TEXTJOIN with Different Delimiters at Once in Excel  
  • Formula Auto-Increment After So Many Rows  
  • Excel Tips - Quickly Fill Formulas and Text Series in a Few Seconds  
  • SWITCH() Function in Excel and 3 Alternatives  
  • ARRAYTOTEXT() Function Excel - 5 Practical Examples  
  • The Power of TRUE FALSE in Excel  
  • Logical Comparison Operators in Excel - How to Compare Things  
  • Compare Values in Excel - Beginner to Advanced  
  • ROMAN() & ARABIC() Function in Excel  
  • How to use the CONVERT Function in Excel  
  • Count the Visible Rows in a Filtered List in Excel  
  • Dynamic Excel Formulas Made Easy - 2 Methods