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 Find the Next Blank Row with VBA Macros 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 Convert Scientific Notation to Numbers in Excel Send Emails through Outlook using Email Addresses from Excel and text from Word Email Current Workbook & or Other Attachments Get the Last Row using VBA in Excel Apply Conditional Formatting to Multiple Cells with a Single Formula Email List of People from Excel Using a Macro Count the Visible Rows in a Filtered List in Excel 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 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 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 Force the User to Enable Macros to use the Workbook Verify User Input or Undo It Don't Let the User Leave a Worksheet Until They Complete a Task 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 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 Made Easy 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
