VLOOKUP() Function in Excel Make Your Macros Available in All Workbooks in Excel Combine Values from Multiple Cells into One Cell in Excel How to Quickly Find Data Anywhere in Excel Ignore Blanks in a Data Validation List 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 Logical Comparison Operators in Excel - How to Compare Things 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 Pass Values from One Macro to Another Macro Get the Decimal Part of a Number in Excel Send Emails through Outlook using Email Addresses from Excel and text from Word Email Current Workbook & or Other Attachments Apply Conditional Formatting to Multiple Cells with a Single Formula Email List of People from Excel Using a Macro 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 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 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 Send Emails from Excel - Automatically and by Hand The Power of TRUE FALSE 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 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 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 Import 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 + 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 ARRAYTOTEXT() Function Excel - 5 Practical Examples 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 Dynamic Data Templates in Excel 365 FILTER in Excel - Limit, Sort, & Rank 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 Explode Cells 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 Data Validation List with Dynamic Arrays in Excel
