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 365 Wildcard Vlookup to Return All Partial Matches SORTBY() - New Excel 365 Function to Sort Data FILTER() Function Excel - Power Lookup for the Future SEQUENCE() Function - Excel 365 New Function for List Making UNIQUE() Function - Excel 365 Function for Removing Duplicates 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
