• VLOOKUP() Function in Excel  
  • Make Your Macros Available in All Workbooks in Excel  
  • Combine Values from Multiple Cells into One Cell in Excel  
  • Prevent Spaces from Being Entered in Cells in Excel  
  • Run a Macro When you Click a Button in Excel  
  • Calculate Someone's Age in Excel  
  • Delete Duplicate Values in All Versions of Excel  
  • Open PDF from Excel  
  • 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  
  • Get the Decimal Part of a Number in Excel  
  • Apply Conditional Formatting to Multiple Cells with a Single Formula  
  • Vlookup to Return the Min, Max, or Average Value in Excel  
  • 6 Tips to Quickly Clean Data in Excel  
  • 5 Bite-Size Vlookup Tricks for Excel  
  • 6 Tricks to Make Dates Work in Excel  
  • Easy Excel Web Import  
  • Force a User to Enable Macros in Excel - Advanced Version  
  • How to Use INDEX MATCH Lookups in Excel - Step-by-Step Guide  
  • 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 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  
  • Get, Input, Clear, and Move Values Around a Worksheet  
  • Activate vs. Select - The Important Difference  
  • 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 Macro 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  
  • 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  
  • TEXTJOIN with Different Delimiters at Once in Excel  
  • 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 Web Data Copy/Paste + Easy Analysis  
  • Pivot Chart Formatting Copy Trick in Excel - Excel Quickie  
  • 3 Slicer Tricks for Pivot Tables in Excel  
  • 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  
  • SWITCH() Function in Excel and 3 Alternatives  
  • Toggle Visible Items in Excel Using a Button  
  • Remove Deleted Items from Slicers & Pivot Tables  
  • Send Email from Excel - The Basics  
  • 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