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



  • Sort Data Alphabetically or Numerically in Excel 2007 and Later   
  • Quickly Find All Comments in a Spreadsheet in Excel  
  • Convert Numbers Stored as Text to Numbers in Excel  
  • Quickly Combine a List of Values and Put a Delimiter Between Each Value in Excel  
  • Quickly Create a Huge List of Numbers in Excel  
  • Quickly Switch the Columns and Rows of a Data Set in Excel  
  • Easily Compare Duplicate Values in Excel  
  • Highlight Duplicate Values in Excel  
  • Delete All Empty Rows or Blank Cells from a Range in Excel  
  • Split Text into Multiple Cells in Excel  
  • Delete All Rows that Contain a Specific Value in Excel  
  • Count the Number of Cells that Contain Specific Text in Excel  
  • Count the Number of Cells that Start or End with Specific Text in Excel  
  • Enable the Analysis ToolPak in Excel  
  • Sort Data Left to Right in Excel  
  • Group Data Together for Increased Readability in Excel  
  • Sort on Multiple Columns at Once in Excel  
  • List All Defined Names and Values in the Worksheet in Excel  
  • Combine Data from Multiple Worksheets in Excel  
  • Filter While Leaving Original Data Intact in Excel  
  • Case Sensitive Sorting in Excel  
  • Create and Manage Tables in Excel  
  • Use a Form to Enter Data into a Table in Excel  
  • Using Formulas with Tables in Excel  
  • Complex Structured References (Table Formulas) in Excel  
  • Determine if Cells Contain a Specific Value in Excel  
  • Filter and Sort Data on Charts in Excel  
  • Average Non-Contiguous Cells in Excel  
  • Round to a Specific Decimal for Any Number in Excel  
  • Guide to Combine and Consolidate Data in Excel  
  • Sum Values from Every X Number of Rows 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 Occurrences of the Largest or Smallest Value in a Range  
  • Find the Most Frequently Occurring Value in a List in Excel  
  • SUBTOTAL Function - Work on Filtered Data in Excel  
  • Formula to Count Occurrences of a Word in a Cell or Range in Excel  
  • Formula to Count Occurrence of Specific Characters in a Cell  
  • Choose Random Values or Cells from a List in Excel  
  • Remove All HTML from Text in Excel  
  • Get the Last Result from a List in Excel  
  • Split Cells with Multiple Lines - Text-to-Columns using Carriage Return  
  • Edit Multiple Worksheets at Once in Excel  
  • 5 Must Know Paste Special Tricks  
  • Searchable List in Excel - Easy Method  
  • Fast Search Entire Excel Workbook & Return All Results  
  • Fast Search Multiple Workbooks - VBA Macro  
  • Fast Search Multiple Workbooks in Excel with a File Picker - VBA Macros  
  • SUMIF(S) Based on Cell Color  
  • 3 Simple Tips for Quickly Understanding Large Spreadsheets in Excel  
  • Ignore Zeros with MIN() & Other Functions in Excel  
  • Filter Data as you Type in Excel  
  • 5 Awesome Tips to Save Time Working with Huge Worksheets in Excel  
  • Keep Leading Zeros in Numbers in Excel - 2 Ways  
  • Advanced Data Filters in Excel - Introduction  
  • Data Sensitivity Analysis in Excel - What If Data Tables  
  • Advanced Worksheet Controls in Excel using a Checkbox  
  • Advanced Decision Making using CHOOSE in Excel  
  • Exclude Cells that are Filtered, Hidden or Grouped from Formulas  
  • Transpose Every X Number of Rows in Excel - Advanced Transpose Technique  
  • SUMIFS Examples in Excel  
  • Coronavirus Stats Analysis in Excel  
  • Analyze Dynamically Sized Data Sets in Excel  
  • Goal Seek in Excel - 2 Methods - Automated and By Hand  
  • Goal Seek in Excel  
  • IFS Function - Multiple IF Statements in One  
  • Formula to Get the Last Value from a List in Excel  
  • Excel Input Form with Macros and VBA  
  • Remove Table Format in Excel  
  • Find the Most Frequently Occurring Number in a List  
  • 3 Methods to Remove Spaces Between Text in Excel  
  • Make All Numbers in a List Positive in Excel  
  • Make Negative Numbers Positive in Excel and Vice Versa  
  • Formulas Based on Cell Color - SUMIFS, IF, COUNTIF, Etc.  
  • NOT Function - Change False to True and True to False in Excel  
  • Highlight, Sort, and Group the Top and Bottom Performers in a List in Excel  
  • CLEAN() Function Excel  
  • Delete Duplicate Values in All Versions of Excel  
  • Remove Hidden Spaces from Excel - Including Char(160)  
  • Elegant Date and Location Filtering in Excel - A Must See!  
  • Increment a Value Every X Number of Rows in Excel  
  • Slicer Power Analysis in Excel - Pivot Tables + Pivot Charts + Tables + Slicers  
  • 6 Tips to Quickly Clean Data in Excel  
  • 3 Slicer Tricks for Pivot Tables in Excel  
  • Get the Decimal Part of a Number in Excel  
  • Get the Integer Part of a Number in Excel  
  • Remove Deleted Items from Slicers & Pivot Tables  
  • 4 Easy Ways in Excel to Convert Numbers Stored as Text to Numbers - Workbook Included  
  • Count Occurrences of Unique Values in a List in Excel  
  • Excel Import Web Data Copy/Paste + Easy Analysis  
  • Exact Function - Case Sensitive Comparison in Excel  
  • Logical Comparison Operators in Excel - How to Compare Things  
  • FILTER in Excel - Limit, Sort, & Rank  
  • Custom Data Views Controlled by a Drop Down Menu in Excel  
  • Convert Scientific Notation to Numbers in Excel  
  • Count Cells that Contain Specific Text in Excel  
  • Count the Visible Rows in a Filtered List in Excel  
  • Data Visualization and Summary Trick for Excel - Outlining Data  
  • Easy Pivot Table in Excel (Auto-Subtotals Feature)  
  • How to Calculate Hours Worked in Excel  
  • Highlight Important Excel Data With a Single Button Click  
  • 4 Simple Tricks to Make Data Easy to Understand Visually  
  • Interactive Clickable Buttons and Interface Without Using VBA/Macros in Excel  
  • Highlightable Tables in Excel (EASY)  
  • Split & Combine Text Using Flash Fill in Excel  
  • Quickly Consolidate and Compare Data in Excel Using a Pivot Chart & Pivot Table  
  • Connect to MySQL from Excel (Complete Guide)  
  • Custom Threshold Highlighting Trick in Excel  
  • Custom Delete Rows in Excel  
  • Monitor Data in Excel without VBA/Macros  
  • Make Threshold Alert Popups in Excel - Easy Version  
  • Helper Slicer Visual Analysis Trick for Excel  
  • Custom Sort in Excel (The Easy Way)