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



  • Scale Data for Printing in Excel - Fit more onto a Printed Page  
  • Link to Cells on Other Worksheets in Excel  
  • Install a Macro into an Excel Spreadsheet  
  • Years, Months, Days Between two dates in Excel  
  • Rename a Module for an Excel Macro  
  • No more #DIV/0!  
  • Set a Photo/Image as an Excel Worksheet Background  
  • AutoFilter with an Excel Macro  
  • MODE() - Find Most Repeated Value in a List in Excel  
  • Remove Gridlines in Excel 2007 and Later  
  • Sort Data Alphabetically or Numerically in Excel 2007 and Later   
  • NOW() - Display The Current Time in Excel  
  • Make Column Headings Numbers instead of Letters - Make R1C1 Style References in Excel 2007  
  • Simplify VBA Coding for Common Functions  
  • Hide or Protect a Tab in Excel - 2 ways  
  • Quickly Enter the System Date in Excel - Keyboard Shortcut  
  • Copy one range and paste in another range  
  • Select Cells in Excel using Macros and VBA  
  • Select Ranges of Cells in Excel using Macros and VBA  
  • VLOOKUP() Function in Excel  
  • Hide Data Within a Worksheet in Excel  
  • Import a Worksheet from One Workbook to Another in Excel  
  • Make Your Macros Available in All Workbooks in Excel  
  • How to Add a New Line to a Message Box (MsgBox) in Excel VBA Macros  
  • How to Make Macros Run A LOT Faster  
  • Guide to Making Your Macro Run Faster and Better in Excel  
  • Print Only Specific Parts of a Worksheet in Excel  
  • How to use Vlookup Across Multiple Worksheets in Excel  
  • Quickly Switch the Columns and Rows of a Data Set in Excel  
  • How to Find and Fix Errors in Complex Formulas in Excel  
  • Capitalize First Letter of Every Word in a Cell - PROPER Function  
  • Combine Values from Multiple Cells into One Cell in Excel  
  • HLOOKUP in Excel  
  • Remove Personal Information from Excel Files  
  • Quickly Create a Huge List of Numbers in Excel  
  • Guide to Referencing Other Excel Files with Formulas and Functions  
  • Store Large Numbers in Excel  
  • How to Use Multiple Functions and Formulas in a Single Cell in Excel  
  • IF() Statement Function in Excel - How to use it  
  • How to Enter Data into Excel  
  • Remove Gridlines from Only Part of a Worksheet in Excel  
  • Quickly Copy the Last Action to Multiple Cells in Excel  
  • How to Resize Rows and Columns in Excel Quickly  
  • Quickly Find All Comments in a Spreadsheet in Excel  
  • How to Add, Remove, and Rearrange Columns and Rows in Excel  
  • Quickly Move Cells Around a worksheet in Excel Cut/Paste Trick  
  • How to import Text Files (CSV) into Excel  
  • Sorting Data by Date, Text, or Number in Excel  
  • Introduction to Using Filters to Refine Data in Excel  
  • How to Quickly Find Data Anywhere in Excel  
  • Quickly Replace A Lot of Data in Excel  
  • How to View, Arrange, or Hide All Shapes, Charts, Pictures, Etc. in Excel  
  • How to View the Selection Pane in Excel When there are No Visible Objects  
  • Join a Date and Time into a Single Cell using VBA Macros in Excel  
  • Excel Time - Summing Time Greater than 24 Hours  
  • Excel VBA - Create an Array - 3 ways  
  • How to Add Formatting to Cells and Data in Excel Styles, Fonts, Colors, & More  
  • Display Numbers, Dates, & Times in the Correct Format in Excel  
  • How to Arrange Data within Cells in Excel  
  • Highlight Rows that Meet a Certain Condition in Excel  
  • How to Add Boxes, Buttons, Arrows, Speech-Bubbles, Hearts, and More to a Spreadsheet in Excel  
  • Quickly Add, Edit, & Manage Business Specific Diagrams in Excel (SmartArt)  
  • 3D References - Formulas that Reference Multiple Sheets at Once in Excel  
  • Calculate the Difference Between Time Greater than 24 Hours 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  
  • Run a Macro from Another Macro in Excel  
  • Calculate the Difference Between Two Times in Excel  
  • Calculate the Total Time Worked Minus Lunch Breaks in Excel  
  • Quickly See All Cells linked to a Formula or Function in Excel  
  • Find the Next Blank Row with VBA Macros in Excel  
  • Get the Name of a Worksheet in Macros VBA in Excel  
  • Loop through All Worksheets in Excel using VBA and Macros  
  • Understanding Formulas and Functions in Excel  
  • How to Input, Edit, and manage Formulas and Functions in Excel  
  • Linking Cells in Excel  
  • Naming Cells in Excel to Make Using Formulas/Functions Easier  
  • Absolute and Relative Cell References in Excel  
  • Performing Calculations in Excel - Order of Operations Explained  
  • How to Find and Understand Excel Functions  
  • Easily Input Complex Functions in Excel  
  • Introducing Logic into Formulas and Functions in Excel  
  • How to Create and Manage a Chart in Excel  
  • Update, Change, and Manage the Data Used in a Chart in Excel  
  • Changing Any Element in a Chart in Excel  
  • Format Any Element of a Chart in Excel  
  • Combine Multiple Chart Types in Excel to Make Powerful Charts  
  • Excel Data Validation - Limit What a User Can Enter into a Cell  
  • Ignore Blanks in a Data Validation List in Excel  
  • Dynamic Named Range in Excel  
  • OFFSET Function in Excel  
  • Make a Drop Down List Menu in a Cell in Excel  
  • Dynamic Formulas that Update When you Add Data in Excel  
  • Prevent Duplicate Values in Excel  
  • Completely Hide the Ribbon Menu in Excel  
  • Hide or Unhide a Worksheet by Hand in Excel  
  • Minimize or Maximize the Ribbon Menu in Excel  
  • Completely Hide the Quick Access Toolbar in Excel  
  • Change the Default Number of Worksheets Created in a New Excel Workbook  
  • FV Function - Get the Future Value in Excel  
  • Hide the Excel Interface and Show Only Data  
  • Add Notes and Comments to Cells in Excel  
  • Print Gridlines in Excel  
  • Prevent Charts from Printing in Excel  
  • Prevent a User from Changing Any Data in Excel  
  • Stop Formula Calculation in Excel - Increase Worksheet Performance  
  • PV Function - Get the Present Value in Excel  
  • Loop Through an Array in Excel VBA Macros  
  • Use Colors to Organize Excel Tabs  
  • Password Protect Excel Files  
  • Quickly Clear all Formatting in Excel  
  • Vlookup on Data with Spaces  
  • Convert Numbers Stored as Text to Numbers in Excel  
  • Make Negative Numbers Positive in Excel and Vice Versa  
  • Mark an Excel File as Complete and Final Version  
  • Quickly Combine a List of Values and Put a Delimiter Between Each Value in Excel  
  • Keep Leading Zeros in Numbers in Excel - 2 Ways  
  • Error Values in Excel - Full Explanation  
  • Remove Vlookup #N/A Error in Excel  
  • Excel Formatting for Zip Codes and Phone Numbers  
  • Automatically Run a Macro When a Workbook is Opened  
  • Make Users Enable Macros in Order to View a Workbook in Excel  
  • RATE Function - Calculate an Interest Rate in Excel  
  • Require a Unique List of Numbers in a Range in Excel  
  • Display all Formulas at Once in Excel  
  • Easily Compare Duplicate Values in Excel  
  • Make All Text Upper Case or Lower Case in Excel  
  • Delete All Empty Rows or Blank Cells from a Range in Excel  
  • Prevent Spaces from Being Entered in Cells in Excel  
  • Generate Random Numbers within a Range in Excel  
  • Limit the Total Amount a User Can Enter into a Range of Cells in Excel  
  • PMT Function - Get the Payment Due for a Loan in Excel  
  • Round Numbers Up or Down in Excel  
  • Show Fewer Decimal Places Without Losing Precision in Excel  
  • Quickly Copy Cell Formatting to Other Cells in Excel  
  • Split Text into Multiple Cells in Excel  
  • Delete All Rows that Contain a Specific Value in Excel  
  • NPER Function - Calculate Number of Periods Needed for a Set of Payments in Excel  
  • Top Excel Keyboard Shortcuts to Increase Productivity  
  • Increment a Value Every X Number of Rows in Excel  
  • Run a Macro When you Click a Button in Excel  
  • Shade Every Other Row in Excel Quickly  
  • Print Comments in Excel  
  • Automatically Shade Every Other Row When You Add Data in Excel  
  • Vlookup with a Range of Numbers in Excel  
  • AND Function - Check if All Arguments are True  
  • OR Function - Check if Any Argument is True  
  • 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  
  • Get the Row or Column Number of a Cell in Excel  
  • Make All Numbers in a List Positive in Excel  
  • Quickly Resize Multiple Columns or Rows at Once in Excel  
  • Enable the Analysis ToolPak in Excel  
  • Allow Only Certain People to Edit Specific Cells in Excel  
  • Export an Excel File to a CSV File  
  • Print the Current Date or Time in Excel  
  • Stop Excel from Changing Numbers to Dates or Anything Else  
  • Print All Worksheets at Once in Excel  
  • Get the Last Day of the Month in Excel  
  • TRIM - Remove Spaces From the Sides of Text and Extra Ones in the Middle in Excel  
  • Get the Number of Workdays Between Two Dates in Excel  
  • Get the Day of the Week (1 to 7) for a Date in Excel - WEEKDAY  
  • Get a Date that is So Many Working Days Before or After a Date in Excel - WORKDAY  
  • Calculate Someone's Age in Excel  
  • Change the Order of Tabs in Excel  
  • Sparkling Christmas Tree in Excel  
  • Get the Current Date in Excel  
  • 3 Methods to Remove Spaces Between Text in Excel  
  • Easily Enter Fractions into Excel  
  • View Different Parts of a Worksheet at Once in Excel  
  • Delete Duplicate Values in All Versions of Excel  
  • Sort Data Left to Right in Excel  
  • Chart Hidden Data in Excel  
  • Group Data Together for Increased Readability in Excel  
  • Sort on Multiple Columns at Once in Excel  
  • Print Specific Rows or Columns on Each Page in Excel  
  • REPT Function in Excel - Repeat Values  
  • Easy Way to Manage Names in Excel  
  • Freeze or Lock Specific Rows and Columns when Scrolling in Excel  
  • List All Defined Names and Values in the Worksheet in Excel  
  • Best Lookup Formula in Excel - Index and Match  
  • Insert and Manage Page Breaks in Excel  
  • Count the Number of Unique Values in a List in Excel  
  • Remove Print Preview Lines in Excel  
  • MOD Function in Excel  
  • Dates in Excel Explained  
  • Logical Comparison Operators in Excel - How to Compare Things  
  • Using Parentheses in Excel  
  • Return the Min or Max Value Using a Lookup in Excel - INDEX MATCH  
  • Error bars in Charts in Excel  
  • Create Gantt Chart in Excel Easily  
  • Add, Manage, & Remove Trendlines in Charts in Excel  
  • Make a Transparent Chart in Excel  
  • Change the Name of a Chart in Excel  
  • Make Professional Looking Rounded Buttons in Excel  
  • Combine Data from Multiple Worksheets in Excel  
  • Filter While Leaving Original Data Intact in Excel  
  • Add Image Background to a Chart in Excel  
  • Open PDF from Excel  
  • Connect the Line for a Chart in Excel and Skip Blanks  
  • Thermometer Chart in Excel  
  • Case Sensitive Sorting in Excel  
  • Show All Formulas in a Worksheet in Excel  
  • Center Titles Across Multiple Cells in Excel  
  • Get a Table Look with Only the Formatting in Excel  
  • Create and Manage Tables in Excel  
  • Dynamic Charts in Excel - The Easy Way  
  • Use a Form to Enter Data into a Table in Excel  
  • Remove Table Format in Excel  
  • Using Formulas with Tables in Excel  
  • Complex Structured References (Table Formulas) in Excel  
  • Loop through a Range of Cells in Excel VBA/Macros  
  • Stop a Macro from Running in Excel  
  • Pause a Macro or Make it Slow Down in Excel  
  • Make Y Axis Start at 0 in Charts in Excel  
  • Change Axis Units on Charts in Excel  
  • Close Excel Workbook using VBA Macros  
  • Open Excel Workbook Using VBA Macros  
  • Password Protect Excel VBA Macros  
  • Break out of or Exit Different Types of Loops in VBA Macros in Excel  
  • Add Formatting to Comments in Excel  
  • Remove All Hyperlinks Quickly in Excel  
  • Determine if Cells Contain a Specific Value in Excel  
  • NOT Function - Change False to True and True to False in Excel  
  • Prevent Images and Shapes from Resizing or Moving in Excel  
  • Increment a Date By X Days for Each Row in Excel  
  • Highlight, Sort, and Group the Top and Bottom Performers in a List in Excel  
  • Link to a Location Within the Spreadsheet in Excel  
  • Turn Off the Formatting Window Popup in Excel  
  • Create a Custom Function in Excel - UDF  
  • Filter and Sort Data on Charts in Excel  
  • Excel Function to Remove All Text OR All Numbers from a Cell  
  • Excel Prank - Automatically Change User-Entered Text  
  • Loop through a Range of Cells in a UDF in Excel  
  • Insert Check Mark in Excel - 3 Ways - Incl. VBA and UDF  
  • Simple Excel Function to Extract a Word or Text from a Cell  
  • Simple Excel Function to Combine Text with a Separator  
  • Countdown Timer in Excel  
  • VBA Comparison Operators  
  • Excel VBA MsgBox - Message Box Macro  
  • What is a Macro in Excel?  
  • Put Data into a Worksheet using a Macro in Excel  
  • Get Data from the Worksheet into a Macro in Excel  
  • Get User Submitted Data from a Prompt in Excel using VBA Macros  
  • Simple Alternatives to UserForms  
  • Select Data from Separate Worksheets with Macros VBA in Excel  
  • Variables in Macros VBA for Excel - Practical Guide  
  • Run a Macro when a User Does Something in the Worksheet in Excel  
  • Activate or Navigate to a Worksheet using Macros VBA in Excel  
  • Macro to Open a Website from Excel  
  • Input Form to Get Data and Store it in Another Tab in Excel  
  • Comments in Macros in Excel  
  • Macro to get Data from Another Workbook in Excel  
  • Logical Operators in Excel VBA Macros  
  • List all Conditional Formatting Formulas in Excel  
  • VBA IF Statement in Excel Macros  
  • Run a Macro when a User Does Something in the Workbook in Excel  
  • Vlookup on Dates and Times in Excel  
  • Excel Prank - Prevent Closing a Workbook  
  • Pass Values from One Macro to Another Macro  
  • Average Non-Contiguous Cells in Excel  
  • Get Formulas from Cells in Excel with VBA  
  • Install Solver Add-In for Excel  
  • Get the Integer Part of a Number in Excel  
  • Get the Decimal Part of a Number in Excel  
  • Change Minutes from a Decimal to a Percentage of an Hour  
  • Goal Seek in Excel  
  • Highlight Duplicate Values in Excel  
  • Transpose a Column into Multiple Rows in Excel  
  • Run a Macro When a Specific Cell Changes in Excel  
  • Do Something Every so Many Rows with a Macro in Excel  
  • Convert Scientific Notation to Numbers in Excel  
  • Vlookup Partial Match in Excel  
  • Convert Column Number to Letter Using a Formula in Excel  
  • Filter Data in Excel to Display Records that Contain a Value Between Two Values - AutoFilter.  
  • Send Emails through Outlook using Email Addresses from Excel and text from Word  
  • Email Current Workbook & or Other Attachments  
  • Vlookup Function That Searches The Entire Workbook in Excel - UDF  
  • Display Filter Arrows in a Table or Data Set in Excel - AutoFilter  
  • Automatically Highlight the Active or Selected Cell  
  • Stop Excel Events from Triggering when Running a Macro  
  • Remove (Delete) Hyperlinks from Worksheets  
  • Make Text Uppercase  
  • Output the File Path to and Name of a Workbook in Excel - UDF  
  • Generate a Non-Repeating List of Random Numbers in Excel - UDF  
  • Filter Data in Excel to Display Results that Contain 1 of 2 Possible Values - AutoFilter  
  • Delete Rows in Excel if Completely Empty  
  • Highlight Cells with Text or Formulas (non-empty cells)  
  • Determine a Cell's Color with this UDF - Outputs as Text or the Index Number in Excel  
  • Add Comments to Cells with an Excel Macro  
  • Disable Calculation of Cells when Running a Macro in Excel  
  • Delete Empty Columns  
  • Delete All Comments in a Worksheet in Excel Macro  
  • Print Specific Pages in Excel  
  • Change Formulas to Absolute or Relative References  
  • Output the Name of the Current Excel Workbook Without the File Extension - UDF  
  • Delete Blank Rows in Excel  
  • Extract a Word from a Sentence / Cell in Excel with this UDF - Allows for a User-Defined Delimiter  
  • Filter Data to Show the Bottom X Percent of the Data Set in Excel - AutoFilter  
  • Highlight Cells which Contain Formulas  
  • Pass Arguments to a Macro Called from a Button or Sheet in Excel  
  • Delete Comments in Excel - Permanently Remove Specific Comments from Excel  
  • Change Text to Lowercase  
  • Get Comment Text from Cell Comments in Excel - UDF  
  • Format Cells in The General (default) Format in Excel Number Formatting  
  • Format Cells as Time in Excel  
  • Get Values from a Chart  
  • Convert an Incorrect Date Format into a Real Date in Excel  
  • Display or Show all of the Comments within an Entire Excel Workbook  
  • Highlight the Row of the Selected Cell  
  • Filter Data in Excel to Show Only the Top X Percent of that Data Set - AutoFilter  
  • Output the Name of the Current Excel Workbook Including Extension - UDF  
  • Print Preview Screen Display for The Current or Selected Worksheets in Excel  
  • Prevent Excel Alerts and Messages Appearing While Running a Macro in Excel  
  • Return the ISO Week Number from a Date in Excel - UDF  
  • Filter Data to Show Only the Bottom 10 Items in Excel - AutoFilter  
  • Filter Data to Show the Top X Number of Items in Excel - AutoFilter  
  • Pop-Up Message Box When a Cell Reaches a Certain Value or Contains Certain Text  
  • Open Microsoft Word from Excel  
  • Show a Single Comment in Excel - Means the Comment is Always Visible, No Hovering Necessary  
  • Format Cells in The Long Date Number Format in Excel  
  • Display The Actual Link / Email Address From Links in Excel - UDF  
  • Get Text from Comments in Excel Including the Author of the Comment - UDF  
  • Filter Data to Show the Top 10 Percent of the Data Set in Excel - AutoFilter  
  • Hide Comments in Excel Completely - Even Indicators Will not Appear  
  • Extract the Last Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF  
  • Delete Empty or 'Broken' Named Ranges (#REF!)  
  • Convert Numeric Dollar Values into Text in Excel - UDF  
  • Format Cells as a Fraction in Excel Number Formatting  
  • Highlight the Row and Column of the Selected Cell  
  • Return the ISO Standards Start of the Year in Excel - First Monday of the Year - UDF  
  • Determine if a Cell Contains a Function in Excel - Great for Conditional Formatting and Validation - UDF  
  • Filter Data in Excel - AutoFilter  
  • Format Cells in The Number (Numerical) Number Format in Excel  
  • Count The Number of Words in a Cell or Range of Cells in Excel - UDF  
  • Output the Worksheet Name in a Cell in Excel - UDF  
  • Protect and Unprotect All Worksheets at Once  
  • Open Microsoft PowerPoint from Excel  
  • Delete Multiple Named Ranges Quickly  
  • Format Cells as a Scientific Number in Excel Number Formatting  
  • Create a Column Chart with a Macro in Excel  
  • Reverse Row or Column Order in a Worksheet  
  • Save the Current Worksheet as a New Excel Workbook File  
  • Vlookup Macro to Return All Matching Results from a Sheet in Excel  
  • Input Really Long Numbers into Excel  
  • Get the First Word from a Cell in Excel  
  • Prevent Errors From Appearing in Excel  
  • Get the Last Row using VBA in Excel  
  • Round to a Specific Decimal for Any Number in Excel  
  • SUBSTITUTE() Function - Change Specific Text within a Cell in Excel  
  • Apply Conditional Formatting to Multiple Cells with a Single Formula  
  • Check if Cell is Empty or Not in Excel  
  • Calculate Percent Change in Excel  
  • Automatically Lock Certain Cells in Excel using a Macro  
  • Add Description Text to a UDF in Excel  
  • Add Time Together Limiting by Working Hours and Excluding Weekends and Holidays in Excel  
  • Formula to Delete the First or Last Word from a Cell in Excel  
  • Convert Time to Minutes and Vice Versa in Excel  
  • Combine Worksheets from Multiple Workbooks into One  
  • Guide to Combine and Consolidate Data in Excel  
  • Find the Last Column with Data in Excel VBA  
  • Email List of People from Excel Using a Macro  
  • Get the Day of Week from a Date in Excel  
  • Format a Date to Show Only the Day of Week in Excel  
  • Display the Current Day of the Week 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  
  • Me Keyword in Excel Macros & VBA  
  • SUMIFS - Sum Values Based on Multiple Criteria in Excel  
  • Excel Formulas Won't Update  
  • Multiple Conditional Formatting Rules for a Cell in Excel  
  • 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  
  • SUBTOTAL Function - Work on Filtered Data in Excel  
  • Count the Visible Rows in a Filtered List in Excel  
  • Average the Visible Rows in a Filtered List in Excel  
  • Vlookup to Return the Min, Max, or Average Value 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 Number in a List  
  • Count the Occurrences of the Largest or Smallest Value in a Range  
  • Print Page Numbers on Excel Worksheets  
  • Find the Most Frequently Occurring Value in a List in Excel  
  • Edit Multiple Worksheets at Once in Excel  
  • View Separate Parts of a Worksheet at Once in Excel  
  • View Separate Worksheets at Once in Excel  
  • Print Different First Page in Excel  
  • List All Files from a Directory into Excel  
  • Make Excel Easier to Read  
  • Vlookup to Return All Matching Results  
  • Zoom in Excel Using Keyboard Shortcuts  
  • Print Different Headers for Odd and Even Pages in Excel  
  • Copy and Paste Data using Macro VBA in Excel  
  • Run a Macro at Set Intervals in Excel  
  • Remove Dashed Lines from Copy Paste VBA in Excel  
  • Make a UserForm in Excel  
  • What is a UserForm in Excel?  
  • UserForm Controls  
  • Showing a UserForm  
  • Closing a UserForm  
  • UserForm Properties List and Explanation  
  • UserForm Properties Overview  
  • UserForm Control Properties Overview  
  • Getting Data from a UserForm  
  • Add Values to a ListBox  
  • Excel VBA SaveAs to Overwrite an Existing File Without Prompt  
  • Add Values to a ComboBox  
  • Reset All Values in a UserForm  
  • Excel Prank - Random Cell Selection  
  • Use Macros with UserForms  
  • Add Text to UserForms and Labels  
  • Excel Prank - Random Pop-up Window  
  • UserForm Events  
  • UserForm Controls Events  
  • Put Data into a UserForm  
  • Excel Prank - Sheet Jumping  
  • Remove the Title Bar from a UserForm  
  • Resizable UserForm  
  • Scrollable UserForm  
  • Modeless UserForm  
  • Transparent UserForm  
  • Creating a Splash Screen in Excel  
  • Vlookup Across Multiple Workbooks  
  • Get Data from Separate Workbooks in Excel  
  • SUMIFS Examples in Excel  
  • Formulas Based on Cell Color - SUMIFS, IF, COUNTIF, Etc.  
  • SUMIF(S) Based on Cell Color  
  • Excel Prank - Hide Text on Cell Selection  
  • 15 IF Statement Examples in Excel  
  • Loop Through Controls in a UserForm  
  • Select Ranges in the Worksheet from a UserForm  
  • Multi-Page UserForm  
  • 6 Useful INDEX MATCH Lookup Examples in Excel - Workbook Included  
  • Disable/Enable Buttons in UserForms  
  • Dependent ComboBox Drop Down Menus  
  • Multi-Column ComboBox Drop Down Menus in Forms  
  • Multiple Selections in a ListBox  
  • Get Data from a ListBox Control  
  • Move Items between ListBox Controls  
  • 10 Excel Tricks for Formulas  
  • 5 Helpful Text Extraction Examples in Excel  
  • 15 MUST KNOW Excel Keyboard Shortcuts  
  • Excel Formula to Get Domain Name from a URL  
  • Formula to Count Occurrence of Specific Characters in a Cell  
  • Formula to Count Occurrences of a Word in a Cell or Range in Excel  
  • 6 Tips to Quickly Clean Data in Excel  
  • 5 Bite-Size Vlookup Tricks for Excel  
  • Formulas to Remove First or Last Character from a Cell in Excel  
  • 5 Data Validation Examples - Including 4 Custom - Workbook Included  
  • Excel Macros Class 1 - Getting Started Programming Macros  
  • 4 Easy Ways in Excel to Convert Numbers Stored as Text to Numbers - Workbook Included  
  • Excel Macros Class 2 - Getting and Outputting Data - Workbook Included  
  • 5 Easy Ways to Quickly Hide Data in Excel  
  • Exact Function - Case Sensitive Comparison in Excel  
  • Prevent Cells from Summing to a Negative Value or Vice Versa  
  • Count Occurrences of Unique Values in a List in Excel  
  • Choose Random Values or Cells from a List in Excel  
  • Center Excel Spreadsheets for Printing  
  • 5 Simple Printing Tricks for Excel  
  • ActiveCell vs Selection VBA for Excel  
  • Convert Month Name to Number and Vice Versa in Excel  
  • 6 Tricks to Make Dates Work in Excel  
  • Remove All HTML from Text in Excel  
  • Formula to Get the Last Value from a List in Excel  
  • Get the Last Result from a List in Excel  
  • Macro to Replace HTML Entities with Readable Text  
  • Automatically Copy New Data to Another Worksheet  
  • Excel Macro Class 3 - Looping through Ranges & Working with Cells  
  • Odd or Even Row Formulas in Excel  
  • Create UserForm Control Templates  
  • Automatically Timestamp Entries in Excel  
  • Excel VBA Check if a Cell is in a Range  
  • Calculate Hours Worked - Day or Night Shift & Breaks in Excel  
  • Excel Macro Class 4 - Looping Copying Deleting Data  
  • Convert Time to Decimal - Hours, Minutes, Seconds  
  • 6 Must Know Excel Formatting Keyboard Shortcuts  
  • Excel Macros Class 5 - Get User Input - Message Box  
  • Excel Macro Class 6 - Get User Input - Input Box  
  • Split Cells with Multiple Lines - Text-to-Columns using Carriage Return  
  • Guide to Creating Charts with a Macro in Excel  
  • Edit Multiple Worksheets at Once in Excel  
  • Auto Update Chart Data in Excel  
  • Copy Data or Formatting to Multiple Worksheets in Excel  
  • 5 Must Know Paste Special Tricks  
  • Instantly Fill Thousands of Rows with Numbers, Dates, or Formulas  
  • 4 Tricks for Linking Workbooks in Excel  
  • 8 Tips to Become an Expert in Conditional Formatting for Excel  
  • 6 Expert Chart Techniques in Excel - Master Stock Chart  
  • Searchable List in Excel - Easy Method  
  • Fast Search Entire Excel Workbook & Return All Results  
  • Fast Search Multiple Workbooks - VBA Macro  
  • Idiot-Proof Forms in Excel - Part 1 - Formatting  
  • Idiot-Proof Forms in Excel - Part 2 - Validation  
  • Idiot-Proof Forms in Excel - Part 3 - Macro & Error Display  
  • Idiot-Proof Forms in Excel - Part 4 - Protect Your Form  
  • Fast Search Multiple Workbooks in Excel with a File Picker - VBA Macros  
  • Idiot-Proof Forms in Excel - Part 5 - Save Data from the Form  
  • Idiot-Proof Forms in Excel - Part 6 - View Saved Data in the Form  
  • Idiot-Proof Forms in Excel - Part 7 - Update Data  
  • Idiot-Proof Forms in Excel - Part 8 - Delete Data  
  • test tutorial 1  
  • test tutorial 1  
  • test vid 1  
  • Big Video Test  
  • Big Video Test  
  • Big Boy File Upload Test  
  • Big File Upload and View Test 1  
  • Consistent Button Formatting  
  • Different Button Styles  
  • Hide Entire Excel Interface  
  • Stop Buttons from Resizing  
  • Limit ID Field to a Number (Advanced Methods)  
  • Require Leading Zeros for an ID  
  • Data Entry Hints using Input Messages  
  • Custom Error Display  
  • Name Cells for Easier Macro Reference  
  • Additional Worksheet References in the Macro  
  • Hide Data Columns  
  • Password Protect the Entire Workbook  
  • Secure Helper Worksheets  
  • Hide and Protect the Data Worksheet  
  • Keep Formatting when Saving Data  
  • Keep Leading Zeros when Saving Data  
  • Name Form Ranges for Better Macro Use and Readability  
  • Password Protect the Data Worksheet  
  • Prevent Duplicate Entries  
  • Use Form Field Range Variables  
  • Case Sensitive Search  
  • Partial Match Search  
  • Return the Last Record - Bottom-to-Top Search  
  • Request Update Confirmation  
  • Require a Password to Update a Record  
  • Update only Certain Fields from the Form  
  • Delete Data without Using a Popup Window  
  • Request Delete Confirmation  
  • Require a Password to Delete a Record  
  • Reset Form Validation after Deleting Data  
  • Add or Remove Password Protection for the Macros and VBA Project  
  • Better VBA for Clearing the Form  
  • Clear Form Button  
  • Ensure ID Values are Stored and Retrieved Correctly  
  • Remove Auto-Password Protect Option in VBA  
  • Rename VBA Modules for Better Readability  
  • Formatting the Form  
  • Adding Validation to the Form  
  • Add Error Display and Macro Functionality to the Form  
  • Protect the Form  
  • Save Form Data  
  • View Saved Data  
  • Update Data  
  • Delete Data  
  • Import Series - Import CSV TXT File into Excel  
  • Import Series - Power Query - Overview  
  • Import Series - 5 Tricks to Copy Excel Data to Other Workbooks  
  • Easy Excel Web Import  
  • VBA Macro to Import Web Data into Excel  
  • Access to Excel Data Import  
  • Excel Tricks to Clean Data  
  • Little-Known Printing Tricks for Excel  
  • Reusable Cover Page for Printing  
  • The Best Tips for Recording Macros in Excel  
  • Excel VBA Tip - Stop Selecting Cells!  
  • Force a User to Enable Macros in Excel - Advanced Version  
  • The Best Find & Replace Tricks for Excel  
  • Convert Excel Dates into Text  
  • 3 Amazing Tricks to Add Alternate Row Colors in Excel  
  • Transpose Every X Number of Rows in Excel - Advanced Transpose Technique  
  • Simple Excel Function to Combine Values in All Versions of Excel - UDF  
  • Easy Excel Formulas Every N Rows - Not an Array  
  • 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  
  • Make a UDF with Variable Number of Arguments in Excel  
  • Lookup to Return the 2nd, 3rd, or Nth Matching Result in Excel - VLOOKUP & INDEX  
  • How to Use INDEX MATCH Lookups in Excel - Step-by-Step Guide  
  • 5 Awesome Tips to Save Time Working with Huge Worksheets in Excel  
  • Send Emails from Excel - Automatically and by Hand  
  • Extract Text Before or After the 1st, 2nd, 3rd, Nth Delimiter in Excel  
  • Convert Month Names to Numbers and Numbers to Names in Excel  
  • Use Macros on Password Protected Worksheets in Excel  
  • Advanced Data Filters in Excel - Introduction  
  • Run a Macro when a User Changes a Specific Cell Range or Any Cell in Excel  
  • INDIRECT Function in Excel - Powerful Range References  
  • SUMPRODUCT in Excel - Introduction  
  • The Power of TRUE FALSE in Excel  
  • Check Multiple Conditions in Excel - 5 Awesome Tips and Tricks  
  • Data Sensitivity Analysis in Excel - What If Data Tables  
  • Advanced Decision Making using CHOOSE in Excel  
  • Exclude Cells that are Filtered, Hidden or Grouped from Formulas  
  • Advanced Worksheet Controls in Excel using a Checkbox  
  • Link Worksheet Form Controls with Cells on Protected Worksheets without VBA Macros in Excel  
  • Prevent Duplicate Values in a Range in Excel  
  • Variable Default Values - How to Check for Them and Reset Them  
  • Determine Variable Type - Enables Better Coding  
  • Sheets vs. Worksheets - What You Need to Know  
  • How to Name Variables - Helpful Tips and Common Pitfalls  
  • Helpful Shortcuts for Working with Variables  
  • Message Boxes with Buttons, Formatting, and Style  
  • Message Box Button Clicks - Making Decisions from Message Boxes  
  • How to Use Dates in Excel  
  • 5 Tips for Evaluating Complex Formulas in Excel  
  • Top Tips for Using Named Ranges in Excel  
  • 6 Must Know Text Manipulation Extraction Functions in Excel  
  • Amazing 3D Formulas in Excel  
  • Run Macros at Set Intervals in Excel  
  • Deconstructing Complex Formulas in Excel  
  • 3 Ways to Automatically Update Drop Down Lists in Excel - Data Validation  
  • Calculate Days Between Dates Excluding Weekends and Holidays  
  • Coronavirus Stats Analysis in Excel  
  • Analyze Dynamically Sized Data Sets in Excel  
  • Activate vs Select vs Selection vs ActiveCell  
  • Goal Seek in Excel - 2 Methods - Automated and By Hand  
  • Get, Input, Clear, and Move Values Around a Worksheet  
  • Storing Data in the Macro  
  • Copy and Paste Data  
  • Working with Formulas  
  • Insert/Delete Cells, Ranges, Rows & Columns  
  • Additional Ways to Get/Input Data into the Worksheet  
  • Excel Input Form with Macros and VBA  
  • Reference Cells and Ranges  
  • Advanced Range Selection  
  • Reference Rows and Columns  
  • Activate vs. Select - The Important Difference  
  • User Selected Cells and Ranges  
  • Offset Ranges  
  • Select Cells, Ranges, Rows and Columns within Other Ranges  
  • Never Select Cells Again  
  • Reference Worksheets  
  • Additional Method to Reference Worksheets  
  • Navigate to and Select Worksheets  
  • Work on the Currently Visible Worksheet  
  • Reference Cells and Ranges on Other Worksheets  
  • Adding and Removing Worksheets  
  • Work on New Worksheets - Rename, Add Data, etc.  
  • Move and Copy Worksheets  
  • Common Worksheet Properties  
  • Reverse FIND Formula in Excel - Easily Get the Last Words from Cells  
  • Division Me Crazy - 2 Ways to Divide Numbers in Excel VBA  
  • IF Statement - The Foundation of Decision Making  
  • IF Statement Advanced  
  • Select Case Statement - Make More Readable Decisions  
  • With Statement - Easier Code Writing  
  • GoTo Statement - The correct way to use this!  
  • Simplify Complex IF Statements  
  • Case Insensitive Checks - Control How VBA Compares Text  
  • Arithmetic Operators - Let's Do Math!  
  • Comparison Operators  
  • Logical Operators - Allow Multiple Conditional Checks  
  • Operator Precedence - Control What Occurs When  
  • WILDCARD Vlookup to Return All Matches  
  • VBA File Selection Window to Open Files in Excel  
  • Regular Expression Search Formula in Excel - Regex  
  • Make Better IF Statements in Excel - Learn to Convert Complex Formulas into True False Values  
  • Create an Index / Table of Contents worksheet  
  • SEARCH() vs FIND() Function in Excel  
  • PI() Function in Excel - Math not Food  
  • Fastest Way to Remove Formatting in Excel  
  • How to Make Macros Run Automatically  
  • Workbook Automation Events - Opening, Closing, Saving and Navigating Worksheets  
  • Worksheet Automation Events - Activating, Selecting, Changing Data and Navigating Worksheets  
  • ME to the Rescue - Making Life Easier  
  • Run a Macro When a Specific Cell, Range, Row or Column Changes  
  • Prevent Endless Loops with Error Handling in Events - The Better Way  
  • Force the User to Enable Macros to use the Workbook  
  • Highlight the Selected Cell  
  • Verify User Input or Undo It  
  • Don't Let the User Leave a Worksheet Until They Complete a Task  
  • What is an Array in VBA and How to Make Your First Array  
  • Static Arrays - You Decide the Size  
  • Dynamic Arrays Part 1 - Increased Flexibility  
  • Dynamic Arrays Part 2 - Dynamic Resizing  
  • Multi-Dimensional Arrays - First Step to Working with Ranges in Arrays  
  • Arrays & Ranges Part 1 - Super Fast Range Evaluation  
  • Arrays & Ranges Part 2 - Dynamic Ranges & Single Cell Selection  
  • Easy Array Looping - Look but Don't Touch  
  • Helpful Array Features - Clearing, Checking, Splitting, Joining and Option Base  
  • Excel Formula Formatting Trick to Make Life Easier  
  • Easily Tab/Enter Through Input Forms in Excel - Faster/Better Forms in Excel  
  • Show the Current Date Every Day in Excel (or Time)  
  • CLEAN() Function Excel  
  • Remove Hidden Spaces from Excel - Including Char(160)  
  • Better Edit Excel Formulas in the Conditional Formatting Window or Name Manager  
  • What are Variables and How to Use Them  
  • Option Explicit - Forced Declarations - When, How, and Why to Use It  
  • Variable Types - A Guide  
  • Declaring Variables - Rules, Tips, and Shortcuts  
  • Variable Scope - Project Variables, Module Variables, and Procedure Variables  
  • Precedence - Controlling Variables with the Same Name  
  • Constants - Hardcoding for Strength  
  • Static - Keep My Variables Alive  
  • Confirm User Input using VBA and Macros in Excel  
  • Excel VBA to Select Data from Other Worksheets - VBA Quickie 1  
  • Automatically Updating Dependent Drop Down List Menus in Excel  
  • InputBox - Simple User Input  
  • Formula Input  
  • Date Input  
  • Select a Cell or Range from a Prompt  
  • Get Multiple Inputs from the User  
  • Reference Workbooks  
  • Reference the Current Workbook  
  • Create a New Workbook - 3 Ways  
  • Open Workbooks - Including Password Protected and Read Only  
  • Get Input - The Better Way - Part 1 - Introduction  
  • Get Input - The Better Way - Part 2 - More Features and Caveats  
  • Save Workbooks - 4 Ways  
  • Close Workbooks - Including All of Excel and With and Without Saving  
  • Delete a Workbook  
  • Work on New, Opened, and Other Workbooks - The Proper Way!  
  • Check if a Workbook Exists and is Open - Prevent Errors  
  • What are Loops and How are they Useful?  
  • Do Loops - Do While, Do Until, & Infinite  
  • For Next Loop  
  • For Each Loop  
  • While Wend Loop  
  • Nesting Loops - Controlling Loops within Loops  
  • Stop Loops Early - User Controlled, Automatic, and Nested  
  • Advanced Loop Condition Checks  
  • Loop through Cells, Worksheets, and Workbooks using Collections - The Proper Way  
  • Breaking Apart Macros for Debugging  
  • Analyzing Variables with the Locals and Watch Windows  
  • Quick and Powerful Checks with the Immediate Window  
  • Option Explicit and Compile VBA Project  
  • Stop a Long-Running or Frozen Macro  
  • Error Handling  
  • Make Better Decisions with Errors  
  • Elegant Custom Errors and Messages  
  • Object Variables - Part 1 - Ranges, Worksheets, and Workbooks  
  • Object Variables - Part 2 - Set to Nothing or Not  
  • Excel Formula to Remove ALL Special Characters  
  • Make Rounded Corner Cells in Excel  
  • Elegant Date and Location Filtering in Excel - A Must See!  
  • Excel ToolTips on Mouse Hover for Buttons and Shapes  
  • Excel Prank - Zooming into Craziness - For Fun :)  
  • Worksheet Nav with Buttons (No VBA)  
  • Custom Cool Buttons in Excel - With Animations!  
  • Hide or Toggle Worksheet Sections without VBA in Excel  
  • Generate a Unique List of Random Numbers With a Simple Formula + (GUID/UUID Generator)  
  • Easy Colors in VBA - Store and Use Them  
  • 5 Powerful Techniques for Building Advanced Formulas  
  • Easy Date Conversion with VBA  
  • Worksheet Functions for VBA - VLOOKUP() and More  
  • Automated Text Import in Excel with File Selection - The Easy Way - VBA  
  • Formula Auto-Increment After So Many Rows  
  • Slicer Power Analysis in Excel - Pivot Tables + Pivot Charts + Tables + Slicers  
  • Text to Number Format Formula in Excel  
  • 3 Tips for Faster and Better VBA Macros in Excel - Simple to Advanced  
  • Excel Macro Timer - Easy to Use  
  • Require a Password to View Hidden Worksheets in Excel - VBA Tutorial  
  • Excel Tips - Quickly Fill Formulas and Text Series in a Few Seconds  
  • Excel Date Filter Magic - Last Month, This Month, YTD & More + Awesome Interface  
  • Hide Macros (VBA) from the User in Excel  
  • Excel Import Web Data Copy/Paste + Easy Analysis  
  • Pivot Chart Formatting Copy Trick in Excel - Excel Quickie  
  • Save Hours with the Selection Pane in Excel  
  • 5 Tips for Passing Values to Macros (VBA) - Beginner to Advanced  
  • Hide the Entire Excel Interface - Ribbon Menu, Quick Access Toolbar, Status Bar, and More  
  • Toggle Visible Items in Excel Using a Button  
  • Remove Deleted Items from Slicers & Pivot Tables  
  • Send Email from Excel - The Basics + Short Syntax for Better Copy/Pasting  
  • Send Emails to Multiple Recipients at Once - Includes a Dynamic Method for Getting the Recipients from a List in the Worksheet  
  • Email a List of People - Custom Emails for Everyone in the List  
  • Send Emails with a Signature from Outlook  
  • Send an HTML Email - Including How to Manage It and Easily Import It into the Macro  
  • Send Emails with Attachments (Single and Multiple)  
  • Email the Current Workbook (And Email Split Syntax Introduction)  
  • Email Worksheets (One or Many)  
  • Email the Entire Workbook as a PDF Attachment  
  • Email a Worksheet as a PDF Attachment (And Solve Common Issues with the Process)  
  • Email Multiple Worksheets as a PDF Attachment  
  • Automatically Send Emails When a Cell Reaches a Certain Value  
  • Handle Common Errors with Sending Emails  
  • Send Emails Faster  
  • Introduction to the Course  
  • Compare Values in Excel - Beginner to Advanced  
  • Generate Random Dates in Excel  
  • List Slicer Selections in a Cell in Excel  
  • Send Emails from Excel - Automatically and by Hand  
  • Stop Tables from Auto-Filling Formulas Down in Excel  
  • Add Check Marks to Cells by Double-Clicking or Typing  
  • Custom Data Views Controlled by a Drop Down Menu in Excel  
  • ROMAN() & ARABIC() Function in Excel  
  • 4 Tips to Camouflage Slicers in Excel  
  • Reuse Pivot Table Filters in Row, Column, & Value Fields  
  • Get the Numeric Value of any Constant in VBA  
  • The Magically Appearing Cell in Excel  
  • Simple Checkbox Control in Excel  
  • Vlookup Date Picker in Excel (Dynamic)  
  • Easier Table References in Excel  
  • Easy Way to Reference Macros from Other Modules in Excel  
  • Use Pivot Tables and Slicers on Protected Worksheets  
  • Make Dates from Drop Down Lists in Excel  
  • Option Buttons with Formulas in Excel  
  • Make Quick Lists for Drop Down Menus - Save A LOT of Time  
  • How to use the CONVERT Function in Excel  
  • Custom Buttons to Hide & Show Worksheets in Excel  
  • Reset a Worksheet with a Button Click  
  • Hide Formulas in Excel  
  • 30 Second VLOOKUP() in Excel  
  • Make a Password Prompt Input for Excel (With Masked Input)  
  • Count Cells that Contain Specific Text in Excel  
  • Automatically Updating Range References in VBA  
  • Your First UserForm  
  • More UserForm Controls & Require/Validate Form Input  
  • Advanced ComboBox and ListBox Usage - Multiple Selections & Columns & Dependent Menus  
  • Multiple Tabs, Scrollable Forms, & Paragraph Style Inputs  
  • Usability Tips for Professional UserForms - Control Protection, Default Values and More  
  • ActiveX & Form Controls in the Worksheet  
  • Introduction to the Project  
  • Sample Import Files to Use for this Project  
  • How to Manage Large Project Creation & Planning  
  • Create Visual Interfaces for Better Programming  
  • Advanced Code Structures for Larger Projects & Address Variable Usage  
  • How to Build & Test Larger Macros with Ease  
  • Robust Function Development & Real-World Debugging Examples  
  • Building Helper Features for Your Project  
  • Advanced Date Programming  
  • Using Wrapper Functions to Make More Maintainable Code  
  • Dynamic File Creation, Deletion & Cleaning Procedures  
  • Create and Manage Custom Reports, Worksheet Configurations, and Exports  
  • Protecting Against Bad User Inputs  
  • Automatically Email Auto-Generated Custom Reports to Lists of People with the Click of a Button  
  • Professional Integration of the Visual Interface with the Backend Programming  
  • Error Handling System for Large Projects  
  • Security - Building a Password Protection Control System & Protected Access Container  
  • Adding Professional Documentation - The 4 Pillars of Documenting Your Code  
  • Congratulations Rockstar!  
  • Introduction to the Project  
  • Planning the Project's Coding and Visuals (A Design Framework)  
  • Visuals Creation - Professional Tables, Rounded Corners, Stylish Buttons  
  • The First Code - How to Build More Complex Macros and Code Structures  
  • How to Save Time by Reusing Code Safely  
  • User-Friendly Support Functions - Viewing, Refreshing, Clearing Values and More  
  • Adding Dynamic Buttons to Entries in a Table to Manage Them - Edit and Delete  
  • Protecting Everything using VBA  
  • The Completed Project  
  • Validate Data & User Input with VBA  
  • Using Worksheet Functions in Macros (Simple & Advanced)  
  • Calling Other Macros and Passing Values - An Introduction  
  • Tables - The Simple Way  
  • Tables - Advanced Guide (Everything You Need to Know)  
  • Search for Values in Excel - Single Match or All Matches  
  • Advanced Searching for Values - Entire Workbook Search, Wildcards, Formatting Search and Last Row Search  
  • Special Cell Magic - Finding/Deleting Empty Rows, Working with Filtered Data & More  
  • Shapes - The Basic Guide  
  • Shapes - Advanced Techniques & Working with Multiple Shapes  
  • Shapes - Looping and Legacy Form Controls  
  • Importing into Excel - The Easy Way  
  • Advanced File Import - Super Fast for Smaller Files  
  • Advanced File Import - Method Required for Large Files  
  • Advanced File Import - Using the File System Object (FSO)  
  • Data Import Analysis Guide  
  • Building a Robust Data Import Parser (Filtering Before Import, Excluding Rows, & More)  
  • Calling Other Macros - Passing Required, Optional, and Default Arguments, Values, and Arrays  
  • Create Custom VBA Functions that Return Values to a Macro  
  • ByRef vs ByVal - Learn How to Keep Your Data Safe  
  • Add More Power with Advanced Arguments & Result Control  
  • Create Custom Excel Worksheet Functions - User Defined Functions (UDF)  
  • Public vs Private Procedures - How to Hide Your Macros  
  • Enums - Manage Custom Lists and Macro Argument Inputs with Ease  
  • Large Project Management, Documentation & When to Make New Procedures (Code Abstraction)  
  • PivotTables - What You Need to Know!  
  • PivotTables - Filtering and Loops (Dates Included)  
  • PivotTables - Slicers and Timelines (The Guide)  
  • Filtering and Sorting - The How To Guide  
  • Filtering and Sorting - Date Filters (Basic to Advanced - Rolling Dates & More)  
  • Learn New Commands on Your Own & Do Something Useful with Ranges (Macro Recorder + Object Browser)  
  • Practical Use of Better Range References and Number Formatting (On Imported Data)  
  • Powerful Range Methods You Must Know - Union, Resize, CurrentRegion and Intersect  
  • Find the Next Empty or Last Row/Column (The Complete Guide)  
  • The Proper Way to Work with Ranges (Advanced)  
  • Simple System for Using a Default Input Value and Validating It  
  • Force the User to Input Something - 2 Ways  
  • Require Single Cell Selection - And How to Structure More Advanced Code  
  • Zero and "False" Inputs - Avoiding Common Errors  
  • Let the User Choose Which Files to Work With - Including Filtered Selections  
  • Multiple File Selection - How to Allow it and Work with The Files  
  • Let the User Choose Where to Save Files and Under What Name and Type  
  • The Proper Way to Work with Worksheets  
  • Cross-Worksheet (and Workbook) Range Reference Concept - Very Important  
  • The Running Turkey in Excel - Happy Thanksgiving :)  
  • Turkey Takeover in Excel - Turkeys Everywhere Edition  
  • Export to PDF & Managing Print Settings - Entire Workbook, Selected Worksheets or Specific Ranges  
  • Export TXT, CSV & Worksheets (A Professional System that Ensures Data Integrity)  
  • Export PivotTables (The Proper Way) + Unique File Generation Trick  
  • Email from Excel (The Full Guide) - With Multiple Recipients, Attachments, HTML, Signatures, Email Error Handling & More  
  • Password Protect Macros and VBA Projects  
  • Protect a Worksheet - Advanced Options & Avoiding Errors  
  • Making Admin Worksheets (With Password Protection)  
  • Next Empty Row Trick in Excel VBA & Macros  
  • Dynamic Excel Formulas Made Easy - 2 Methods  
  • Assignment Task - Ranges & Assignment Section Explanation  
  • Assignment Answer - Ranges  
  • Assignment Task - Get & Input Data  
  • Assignment Answer - Get & Input Data  
  • Assignment Task - Worksheets  
  • Assignment Answer - Worksheets  
  • Assignment Task - Logic & Control  
  • Assignment Answer - Logic & Control  
  • Assignment Task - Variables Introduction  
  • Assignment Answer - Variables Introduction  
  • Assignment Task - Popup Windows & Input  
  • Assignment Answer - Popup Windows & Input  
  • Assignment Task - Workbooks  
  • Assignment Answer - Workbooks  
  • Assignment Task - Loops  
  • Assignment Answer - Loops  
  • Assignment Task - Variables  
  • Assignment Answer - Variables  
  • Assignment Task - Arrays  
  • Assignment Answer - Arrays  
  • Assignment Task - Error Handling  
  • Assignment Task - Automation  
  • Assignment Answer - Error Handling  
  • Assignment Answer - Automation  
  • Assignment Task - Advanced Macro Control  
  • Assignment Answer - Advanced Macro Control  
  • Assignment Task - Security  
  • Assignment Answer - Security  
  • How to Use the Course  
  • Your First Macro! (The VBA/Macro Intro.)  
  • Quick Tip to Better Understand VBA Code  
  • The Visual Basic Editor Interface (VBE)  
  • The Basics of How VBA Works (Objects & The Object Browser)  
  • The Macro Recorder (Good & Evil)  
  • Excel VBA Course Preview  
  • VBA Login System for Excel  
  • Cell Change Tracker Video  
  • VBA Login System Files  
  • Cell Change Tracker Files  
  • One-Click Workbook Reset Video  
  • One-Click Workbook Reset Files  
  • Better Worksheet References Video  
  • Better Worksheet References Files  
  • Professional Interface Video  
  • Professional Interface Files  
  • Fast Export Worksheets Video  
  • Fast Export Worksheets Files  
  • Auto-Workbook Directory Video  
  • Auto-Workbook Directory Files  
  • Auto-Delete Excel Files Video  
  • Auto-Delete Excel Files (Files)  
  • Auto-Close Excel Workbook Video  
  • Auto-Close Excel Workbook File  
  • Loop Through a Folder Using VBA/Macros Video  
  • Loop Through a Folder Using VBA/Macros File  
  • Introduction to the Tutorial  
  • Video Tutorial and Downloadable File  
  • Add Check Boxes for a More User Friendly Excel Worksheet  
  • Dark Mode for Excel (Including Worksheets) - NO VBA Required  
  • Organize Data in Excel with Custom Lists  
  • Quickly Reset All Form Controls in a Worksheet in Excel  
  • Easy Cell Change Tracker in Excel  
  • Make Perfect Scrollable Boxes in Worksheets in Excel - Great for a Dashboard  
  • 4 Powerful Dynamic Chart Designs in Excel  
  • 5 Simple Tips for Making BETTER Macros in Excel!  
  • Custom Password Template to Auto-Hide Data in Worksheets  
  • Kill Command in Excel (Delete Files Using VBA)  
  • Data Visualization and Summary Trick for Excel - Outlining Data  
  • Easy Pivot Table in Excel (Auto-Subtotals Feature)  
  • Use Formatted Dates and Numbers within Other Text in Excel  
  • How to Calculate Hours Worked in Excel  
  • Highlight Important Excel Data With a Single Button Click  
  • Use a Check Box to Highlight Important Excel Data - Video  
  • Downloadable File  
  • 4 Simple Tricks to Make Data Easy to Understand Visually  
  • Simple Data Input Form for Tables in Excel - No VBA Required  
  • Downloadable File  
  • Interactive Clickable Buttons and Interface Without Using VBA/Macros in Excel  
  • Quickly Delete All Comments from Excel  
  • 3 Tips to Hide Excel Data from Nosy Co-Workers (The Nice Way)  
  • Make a Dynamic Invoice Template in Excel  
  • The One Amazing Tip for Large Worksheet Navigation in Excel  
  • 3 Excel Worksheets to Never Start from Scratch!