• 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  
  • Apply Conditional Formatting to Multiple Cells with a Single Formula  
  • Vlookup to Return the Min, Max, or Average Value in Excel  
  • 5 Bite-Size Vlookup Tricks for Excel  
  • 6 Tricks to Make Dates Work in Excel  
  • 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