Scale Data for Printing in Excel - Fit more onto a Printed Page Link to Cells on Other Worksheets in Excel Install a Macro into an Excel Spreadsheet Years, Months, Days Between two dates in Excel Rename a Module for an Excel Macro No more #DIV/0! Set a Photo/Image as an Excel Worksheet Background AutoFilter with an Excel Macro MODE() - Find Most Repeated Value in a List in Excel Remove Gridlines in Excel 2007 and Later Sort Data Alphabetically or Numerically in Excel 2007 and Later
NOW() - Display The Current Time in Excel Make Column Headings Numbers instead of Letters - Make R1C1 Style References in Excel 2007 Simplify VBA Coding for Common Functions Hide or Protect a Tab in Excel - 2 ways Quickly Enter the System Date in Excel - Keyboard Shortcut Copy one range and paste in another range Select Cells in Excel using Macros and VBA Select Ranges of Cells in Excel using Macros and VBA VLOOKUP() Function in Excel Hide Data Within a Worksheet in Excel Import a Worksheet from One Workbook to Another in Excel Make Your Macros Available in All Workbooks in Excel How to Add a New Line to a Message Box (MsgBox) in Excel VBA Macros How to Make Macros Run A LOT Faster Guide to Making Your Macro Run Faster and Better in Excel Print Only Specific Parts of a Worksheet in Excel How to use Vlookup Across Multiple Worksheets in Excel Quickly Switch the Columns and Rows of a Data Set in Excel How to Find and Fix Errors in Complex Formulas in Excel Capitalize First Letter of Every Word in a Cell - PROPER Function Combine Values from Multiple Cells into One Cell in Excel HLOOKUP in Excel Remove Personal Information from Excel Files Quickly Create a Huge List of Numbers in Excel Guide to Referencing Other Excel Files with Formulas and Functions Store Large Numbers in Excel How to Use Multiple Functions and Formulas in a Single Cell in Excel IF() Statement Function in Excel - How to use it How to Enter Data into Excel Remove Gridlines from Only Part of a Worksheet in Excel Quickly Copy the Last Action to Multiple Cells in Excel How to Resize Rows and Columns in Excel Quickly Quickly Find All Comments in a Spreadsheet in Excel How to Add, Remove, and Rearrange Columns and Rows in Excel Quickly Move Cells Around a worksheet in Excel Cut/Paste Trick How to import Text Files (CSV) into Excel Sorting Data by Date, Text, or Number in Excel Introduction to Using Filters to Refine Data in Excel How to Quickly Find Data Anywhere in Excel Quickly Replace A Lot of Data in Excel How to View, Arrange, or Hide All Shapes, Charts, Pictures, Etc. in Excel How to View the Selection Pane in Excel When there are No Visible Objects Join a Date and Time into a Single Cell using VBA Macros in Excel Excel Time - Summing Time Greater than 24 Hours Excel VBA - Create an Array - 3 ways How to Add Formatting to Cells and Data in Excel Styles, Fonts, Colors, & More Display Numbers, Dates, & Times in the Correct Format in Excel How to Arrange Data within Cells in Excel Highlight Rows that Meet a Certain Condition in Excel How to Add Boxes, Buttons, Arrows, Speech-Bubbles, Hearts, and More to a Spreadsheet in Excel Quickly Add, Edit, & Manage Business Specific Diagrams in Excel (SmartArt) 3D References - Formulas that Reference Multiple Sheets at Once in Excel Calculate the Difference Between Time Greater than 24 Hours in Excel Enter a Constant Value in a Defined Name in Excel - Text, Numbers, Formulas, Etc. Quickly Convert Formulas into Their Output Values in Excel Run a Macro from Another Macro in Excel Calculate the Difference Between Two Times in Excel Calculate the Total Time Worked Minus Lunch Breaks in Excel Quickly See All Cells linked to a Formula or Function in Excel Find the Next Blank Row with VBA Macros in Excel Get the Name of a Worksheet in Macros VBA in Excel Loop through All Worksheets in Excel using VBA and Macros Understanding Formulas and Functions in Excel How to Input, Edit, and manage Formulas and Functions in Excel Linking Cells in Excel Naming Cells in Excel to Make Using Formulas/Functions Easier Absolute and Relative Cell References in Excel Performing Calculations in Excel - Order of Operations Explained How to Find and Understand Excel Functions Easily Input Complex Functions in Excel Introducing Logic into Formulas and Functions in Excel How to Create and Manage a Chart in Excel Update, Change, and Manage the Data Used in a Chart in Excel Changing Any Element in a Chart in Excel Format Any Element of a Chart in Excel Combine Multiple Chart Types in Excel to Make Powerful Charts Excel Data Validation - Limit What a User Can Enter into a Cell Ignore Blanks in a Data Validation List in Excel Dynamic Named Range in Excel OFFSET Function in Excel Make a Drop Down List Menu in a Cell in Excel Dynamic Formulas that Update When you Add Data in Excel Prevent Duplicate Values in Excel Completely Hide the Ribbon Menu in Excel Hide or Unhide a Worksheet by Hand in Excel Minimize or Maximize the Ribbon Menu in Excel Completely Hide the Quick Access Toolbar in Excel Change the Default Number of Worksheets Created in a New Excel Workbook FV Function - Get the Future Value in Excel Hide the Excel Interface and Show Only Data Add Notes and Comments to Cells in Excel Print Gridlines in Excel Prevent Charts from Printing in Excel Prevent a User from Changing Any Data in Excel Stop Formula Calculation in Excel - Increase Worksheet Performance PV Function - Get the Present Value in Excel Loop Through an Array in Excel VBA Macros Use Colors to Organize Excel Tabs Password Protect Excel Files Quickly Clear all Formatting in Excel Vlookup on Data with Spaces Convert Numbers Stored as Text to Numbers in Excel Make Negative Numbers Positive in Excel and Vice Versa Mark an Excel File as Complete and Final Version Quickly Combine a List of Values and Put a Delimiter Between Each Value in Excel Keep Leading Zeros in Numbers in Excel - 2 Ways Error Values in Excel - Full Explanation Remove Vlookup #N/A Error in Excel Excel Formatting for Zip Codes and Phone Numbers Automatically Run a Macro When a Workbook is Opened Make Users Enable Macros in Order to View a Workbook in Excel RATE Function - Calculate an Interest Rate in Excel Require a Unique List of Numbers in a Range in Excel Display all Formulas at Once in Excel Easily Compare Duplicate Values in Excel Make All Text Upper Case or Lower Case in Excel Delete All Empty Rows or Blank Cells from a Range in Excel Prevent Spaces from Being Entered in Cells in Excel Generate Random Numbers within a Range in Excel Limit the Total Amount a User Can Enter into a Range of Cells in Excel PMT Function - Get the Payment Due for a Loan in Excel Round Numbers Up or Down in Excel Show Fewer Decimal Places Without Losing Precision in Excel Quickly Copy Cell Formatting to Other Cells in Excel Split Text into Multiple Cells in Excel Delete All Rows that Contain a Specific Value in Excel NPER Function - Calculate Number of Periods Needed for a Set of Payments in Excel Top Excel Keyboard Shortcuts to Increase Productivity Increment a Value Every X Number of Rows in Excel Run a Macro When you Click a Button in Excel Shade Every Other Row in Excel Quickly Print Comments in Excel Automatically Shade Every Other Row When You Add Data in Excel Vlookup with a Range of Numbers in Excel AND Function - Check if All Arguments are True OR Function - Check if Any Argument is True Count the Number of Cells that Contain Specific Text in Excel Count the Number of Cells that Start or End with Specific Text in Excel Get the Row or Column Number of a Cell in Excel Make All Numbers in a List Positive in Excel Quickly Resize Multiple Columns or Rows at Once in Excel Enable the Analysis ToolPak in Excel Allow Only Certain People to Edit Specific Cells in Excel Export an Excel File to a CSV File Print the Current Date or Time in Excel Stop Excel from Changing Numbers to Dates or Anything Else Print All Worksheets at Once in Excel Get the Last Day of the Month in Excel TRIM - Remove Spaces From the Sides of Text and Extra Ones in the Middle in Excel Get the Number of Workdays Between Two Dates in Excel Get the Day of the Week (1 to 7) for a Date in Excel - WEEKDAY Get a Date that is So Many Working Days Before or After a Date in Excel - WORKDAY Calculate Someone's Age in Excel Change the Order of Tabs in Excel Sparkling Christmas Tree in Excel Get the Current Date in Excel 3 Methods to Remove Spaces Between Text in Excel Easily Enter Fractions into Excel View Different Parts of a Worksheet at Once in Excel Delete Duplicate Values in All Versions of Excel Sort Data Left to Right in Excel Chart Hidden Data in Excel Group Data Together for Increased Readability in Excel Sort on Multiple Columns at Once in Excel Print Specific Rows or Columns on Each Page in Excel REPT Function in Excel - Repeat Values Easy Way to Manage Names in Excel Freeze or Lock Specific Rows and Columns when Scrolling in Excel List All Defined Names and Values in the Worksheet in Excel Best Lookup Formula in Excel - Index and Match Insert and Manage Page Breaks in Excel Count the Number of Unique Values in a List in Excel Remove Print Preview Lines in Excel MOD Function in Excel Dates in Excel Explained Logical Comparison Operators in Excel - How to Compare Things Using Parentheses in Excel Return the Min or Max Value Using a Lookup in Excel - INDEX MATCH Error bars in Charts in Excel Create Gantt Chart in Excel Easily Add, Manage, & Remove Trendlines in Charts in Excel Make a Transparent Chart in Excel Change the Name of a Chart in Excel Make Professional Looking Rounded Buttons in Excel Combine Data from Multiple Worksheets in Excel Filter While Leaving Original Data Intact in Excel Add Image Background to a Chart in Excel Open PDF from Excel Connect the Line for a Chart in Excel and Skip Blanks Thermometer Chart in Excel Case Sensitive Sorting in Excel Show All Formulas in a Worksheet in Excel Center Titles Across Multiple Cells in Excel Get a Table Look with Only the Formatting in Excel Create and Manage Tables in Excel Dynamic Charts in Excel - The Easy Way Use a Form to Enter Data into a Table in Excel Remove Table Format in Excel Using Formulas with Tables in Excel Complex Structured References (Table Formulas) in Excel Loop through a Range of Cells in Excel VBA/Macros Stop a Macro from Running in Excel Pause a Macro or Make it Slow Down in Excel Make Y Axis Start at 0 in Charts in Excel Change Axis Units on Charts in Excel Close Excel Workbook using VBA Macros Open Excel Workbook Using VBA Macros Password Protect Excel VBA Macros Break out of or Exit Different Types of Loops in VBA Macros in Excel Add Formatting to Comments in Excel Remove All Hyperlinks Quickly in Excel Determine if Cells Contain a Specific Value in Excel NOT Function - Change False to True and True to False in Excel Prevent Images and Shapes from Resizing or Moving in Excel Increment a Date By X Days for Each Row in Excel Highlight, Sort, and Group the Top and Bottom Performers in a List in Excel Link to a Location Within the Spreadsheet in Excel Turn Off the Formatting Window Popup in Excel Create a Custom Function in Excel - UDF Filter and Sort Data on Charts in Excel Excel Function to Remove All Text OR All Numbers from a Cell Excel Prank - Automatically Change User-Entered Text Loop through a Range of Cells in a UDF in Excel Insert Check Mark in Excel - 3 Ways - Incl. VBA and UDF Simple Excel Function to Extract a Word or Text from a Cell Simple Excel Function to Combine Text with a Separator Countdown Timer in Excel VBA Comparison Operators Excel VBA MsgBox - Message Box Macro What is a Macro in Excel? Put Data into a Worksheet using a Macro in Excel Get Data from the Worksheet into a Macro in Excel Get User Submitted Data from a Prompt in Excel using VBA Macros Simple Alternatives to UserForms Select Data from Separate Worksheets with Macros VBA in Excel Variables in Macros VBA for Excel - Practical Guide Run a Macro when a User Does Something in the Worksheet in Excel Activate or Navigate to a Worksheet using Macros VBA in Excel Macro to Open a Website from Excel Input Form to Get Data and Store it in Another Tab in Excel Comments in Macros in Excel Macro to get Data from Another Workbook in Excel Logical Operators in Excel VBA Macros List all Conditional Formatting Formulas in Excel VBA IF Statement in Excel Macros Run a Macro when a User Does Something in the Workbook in Excel Vlookup on Dates and Times in Excel Excel Prank - Prevent Closing a Workbook Pass Values from One Macro to Another Macro Average Non-Contiguous Cells in Excel Get Formulas from Cells in Excel with VBA Install Solver Add-In for Excel Get the Integer Part of a Number in Excel Get the Decimal Part of a Number in Excel Change Minutes from a Decimal to a Percentage of an Hour Goal Seek in Excel Highlight Duplicate Values in Excel Transpose a Column into Multiple Rows in Excel Run a Macro When a Specific Cell Changes in Excel Do Something Every so Many Rows with a Macro in Excel Convert Scientific Notation to Numbers in Excel Vlookup Partial Match in Excel Convert Column Number to Letter Using a Formula in Excel Filter Data in Excel to Display Records that Contain a Value Between Two Values - AutoFilter. Vlookup Function That Searches The Entire Workbook in Excel - UDF Display Filter Arrows in a Table or Data Set in Excel - AutoFilter Automatically Highlight the Active or Selected Cell Stop Excel Events from Triggering when Running a Macro Remove (Delete) Hyperlinks from Worksheets Make Text Uppercase Output the File Path to and Name of a Workbook in Excel - UDF Generate a Non-Repeating List of Random Numbers in Excel - UDF Filter Data in Excel to Display Results that Contain 1 of 2 Possible Values - AutoFilter Delete Rows in Excel if Completely Empty Highlight Cells with Text or Formulas (non-empty cells) Determine a Cell's Color with this UDF - Outputs as Text or the Index Number in Excel Add Comments to Cells with an Excel Macro Disable Calculation of Cells when Running a Macro in Excel Delete Empty Columns Delete All Comments in a Worksheet in Excel Macro Print Specific Pages in Excel Change Formulas to Absolute or Relative References Output the Name of the Current Excel Workbook Without the File Extension - UDF Delete Blank Rows in Excel Extract a Word from a Sentence / Cell in Excel with this UDF - Allows for a User-Defined Delimiter Filter Data to Show the Bottom X Percent of the Data Set in Excel - AutoFilter Highlight Cells which Contain Formulas Pass Arguments to a Macro Called from a Button or Sheet in Excel Delete Comments in Excel - Permanently Remove Specific Comments from Excel Change Text to Lowercase Get Comment Text from Cell Comments in Excel - UDF Format Cells in The General (default) Format in Excel Number Formatting Format Cells as Time in Excel Get Values from a Chart Convert an Incorrect Date Format into a Real Date in Excel Display or Show all of the Comments within an Entire Excel Workbook Highlight the Row of the Selected Cell Filter Data in Excel to Show Only the Top X Percent of that Data Set - AutoFilter Output the Name of the Current Excel Workbook Including Extension - UDF Print Preview Screen Display for The Current or Selected Worksheets in Excel Prevent Excel Alerts and Messages Appearing While Running a Macro in Excel Return the ISO Week Number from a Date in Excel - UDF Filter Data to Show Only the Bottom 10 Items in Excel - AutoFilter Filter Data to Show the Top X Number of Items in Excel - AutoFilter Pop-Up Message Box When a Cell Reaches a Certain Value or Contains Certain Text Open Microsoft Word from Excel Show a Single Comment in Excel - Means the Comment is Always Visible, No Hovering Necessary Format Cells in The Long Date Number Format in Excel Display The Actual Link / Email Address From Links in Excel - UDF Get Text from Comments in Excel Including the Author of the Comment - UDF Filter Data to Show the Top 10 Percent of the Data Set in Excel - AutoFilter Hide Comments in Excel Completely - Even Indicators Will not Appear Extract the Last Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF Delete Empty or 'Broken' Named Ranges (#REF!) Convert Numeric Dollar Values into Text in Excel - UDF Format Cells as a Fraction in Excel Number Formatting Highlight the Row and Column of the Selected Cell Return the ISO Standards Start of the Year in Excel - First Monday of the Year - UDF Determine if a Cell Contains a Function in Excel - Great for Conditional Formatting and Validation - UDF Filter Data in Excel - AutoFilter Format Cells in The Number (Numerical) Number Format in Excel Count The Number of Words in a Cell or Range of Cells in Excel - UDF Output the Worksheet Name in a Cell in Excel - UDF Protect and Unprotect All Worksheets at Once Open Microsoft PowerPoint from Excel Delete Multiple Named Ranges Quickly Format Cells as a Scientific Number in Excel Number Formatting Create a Column Chart with a Macro in Excel Reverse Row or Column Order in a Worksheet Save the Current Worksheet as a New Excel Workbook File Vlookup Macro to Return All Matching Results from a Sheet in Excel Input Really Long Numbers into Excel Get the First Word from a Cell in Excel Prevent Errors From Appearing in Excel Get the Last Row using VBA in Excel Round to a Specific Decimal for Any Number in Excel SUBSTITUTE() Function - Change Specific Text within a Cell in Excel Apply Conditional Formatting to Multiple Cells with a Single Formula Check if Cell is Empty or Not in Excel Calculate Percent Change in Excel Automatically Lock Certain Cells in Excel using a Macro Add Description Text to a UDF in Excel Add Time Together Limiting by Working Hours and Excluding Weekends and Holidays in Excel Formula to Delete the First or Last Word from a Cell in Excel Convert Time to Minutes and Vice Versa in Excel Combine Worksheets from Multiple Workbooks into One Guide to Combine and Consolidate Data in Excel Find the Last Column with Data in Excel VBA Email List of People from Excel Using a Macro Get the Day of Week from a Date in Excel Format a Date to Show Only the Day of Week in Excel Display the Current Day of the Week in Excel Nest IF Statements in Excel Make Complex Formulas for Conditional Formatting in Excel Wildcards in Excel Manually Calculate Formulas and Functions in Excel Multiply by True and False in Excel Me Keyword in Excel Macros & VBA SUMIFS - Sum Values Based on Multiple Criteria in Excel Excel Formulas Won't Update Multiple Conditional Formatting Rules for a Cell in Excel CHOOSE Function in Excel Convert Numbers into True and False in Excel Sum Values from Every X Number of Rows in Excel SUMIF - Sum Values Based on Criteria in Excel Sum Values that Equal 1 of Many Conditions across Multiple Columns in Excel Sum Values that Meet 1 of Multiple Conditions in Excel Sum a Range with Errors in Excel Sum the Visible Rows from a Filtered List in Excel SUBTOTAL Function - Work on Filtered Data in Excel Count the Visible Rows in a Filtered List in Excel Average the Visible Rows in a Filtered List in Excel Vlookup to Return the Min, Max, or Average Value in Excel MAX and MIN Values from a Filtered List in Excel Count Cells Containing TRUE or FALSE in Excel Count the Errors in a Range in Excel Average Cells Excluding Zeros in Excel Count Blank Cells in Excel SMALL Function - Get the Lowest Values from a List in Excel LARGE Function - Get the Highest Values from a List in Excel Partial Match Lookup with Numbers in Excel Find the Most Frequently Occurring Number in a List Count the Occurrences of the Largest or Smallest Value in a Range Print Page Numbers on Excel Worksheets Find the Most Frequently Occurring Value in a List in Excel Edit Multiple Worksheets at Once in Excel View Separate Parts of a Worksheet at Once in Excel View Separate Worksheets at Once in Excel Print Different First Page in Excel List All Files from a Directory into Excel Make Excel Easier to Read Vlookup to Return All Matching Results Zoom in Excel Using Keyboard Shortcuts Print Different Headers for Odd and Even Pages in Excel Copy and Paste Data using Macro VBA in Excel Run a Macro at Set Intervals in Excel Remove Dashed Lines from Copy Paste VBA in Excel Make a UserForm in Excel What is a UserForm in Excel? UserForm Controls Showing a UserForm Closing a UserForm UserForm Properties List and Explanation UserForm Properties Overview UserForm Control Properties Overview Getting Data from a UserForm Add Values to a ListBox Excel VBA SaveAs to Overwrite an Existing File Without Prompt Add Values to a ComboBox Reset All Values in a UserForm Excel Prank - Random Cell Selection Use Macros with UserForms Add Text to UserForms and Labels Excel Prank - Random Pop-up Window UserForm Events UserForm Controls Events Put Data into a UserForm Excel Prank - Sheet Jumping Remove the Title Bar from a UserForm Resizable UserForm Scrollable UserForm Modeless UserForm Transparent UserForm Creating a Splash Screen in Excel Vlookup Across Multiple Workbooks Get Data from Separate Workbooks in Excel SUMIFS Examples in Excel Formulas Based on Cell Color - SUMIFS, IF, COUNTIF, Etc. SUMIF(S) Based on Cell Color Excel Prank - Hide Text on Cell Selection 15 IF Statement Examples in Excel Loop Through Controls in a UserForm Select Ranges in the Worksheet from a UserForm Multi-Page UserForm 6 Useful INDEX MATCH Lookup Examples in Excel - Workbook Included Disable/Enable Buttons in UserForms Dependent ComboBox Drop Down Menus Multi-Column ComboBox Drop Down Menus in Forms Multiple Selections in a ListBox Get Data from a ListBox Control Move Items between ListBox Controls 10 Excel Tricks for Formulas 5 Helpful Text Extraction Examples in Excel 15 MUST KNOW Excel Keyboard Shortcuts Excel Formula to Get Domain Name from a URL Formula to Count Occurrence of Specific Characters in a Cell Formula to Count Occurrences of a Word in a Cell or Range in Excel 6 Tips to Quickly Clean Data in Excel 5 Bite-Size Vlookup Tricks for Excel Formulas to Remove First or Last Character from a Cell in Excel 5 Data Validation Examples - Including 4 Custom - Workbook Included Excel Macros Class 1 - Getting Started Programming Macros 4 Easy Ways in Excel to Convert Numbers Stored as Text to Numbers - Workbook Included Excel Macros Class 2 - Getting and Outputting Data - Workbook Included 5 Easy Ways to Quickly Hide Data in Excel Exact Function - Case Sensitive Comparison in Excel Prevent Cells from Summing to a Negative Value or Vice Versa Count Occurrences of Unique Values in a List in Excel Choose Random Values or Cells from a List in Excel Center Excel Spreadsheets for Printing 5 Simple Printing Tricks for Excel ActiveCell vs Selection VBA for Excel Convert Month Name to Number and Vice Versa in Excel 6 Tricks to Make Dates Work in Excel Remove All HTML from Text in Excel Formula to Get the Last Value from a List in Excel Get the Last Result from a List in Excel Macro to Replace HTML Entities with Readable Text Automatically Copy New Data to Another Worksheet Excel Macro Class 3 - Looping through Ranges & Working with Cells Odd or Even Row Formulas in Excel Create UserForm Control Templates Automatically Timestamp Entries in Excel Excel VBA Check if a Cell is in a Range Calculate Hours Worked - Day or Night Shift & Breaks in Excel Excel Macro Class 4 - Looping Copying Deleting Data Convert Time to Decimal - Hours, Minutes, Seconds 6 Must Know Excel Formatting Keyboard Shortcuts Excel Macros Class 5 - Get User Input - Message Box Excel Macro Class 6 - Get User Input - Input Box Split Cells with Multiple Lines - Text-to-Columns using Carriage Return Guide to Creating Charts with a Macro in Excel Edit Multiple Worksheets at Once in Excel Auto Update Chart Data in Excel Copy Data or Formatting to Multiple Worksheets in Excel 5 Must Know Paste Special Tricks Instantly Fill Thousands of Rows with Numbers, Dates, or Formulas 4 Tricks for Linking Workbooks in Excel 8 Tips to Become an Expert in Conditional Formatting for Excel 6 Expert Chart Techniques in Excel - Master Stock Chart Searchable List in Excel - Easy Method Fast Search Entire Excel Workbook & Return All Results Fast Search Multiple Workbooks - VBA Macro Idiot-Proof Forms in Excel - Part 1 - Formatting Idiot-Proof Forms in Excel - Part 2 - Validation Idiot-Proof Forms in Excel - Part 3 - Macro & Error Display Idiot-Proof Forms in Excel - Part 4 - Protect Your Form Fast Search Multiple Workbooks in Excel with a File Picker - VBA Macros Idiot-Proof Forms in Excel - Part 5 - Save Data from the Form Idiot-Proof Forms in Excel - Part 6 - View Saved Data in the Form Idiot-Proof Forms in Excel - Part 7 - Update Data Idiot-Proof Forms in Excel - Part 8 - Delete Data test tutorial 1 test tutorial 1 test vid 1 Big Video Test Big Video Test Big Boy File Upload Test Big File Upload and View Test 1 Consistent Button Formatting Different Button Styles Hide Entire Excel Interface Stop Buttons from Resizing Limit ID Field to a Number (Advanced Methods) Require Leading Zeros for an ID Data Entry Hints using Input Messages Custom Error Display Name Cells for Easier Macro Reference Additional Worksheet References in the Macro Hide Data Columns Password Protect the Entire Workbook Secure Helper Worksheets Hide and Protect the Data Worksheet Keep Formatting when Saving Data Keep Leading Zeros when Saving Data Name Form Ranges for Better Macro Use and Readability Password Protect the Data Worksheet Prevent Duplicate Entries Use Form Field Range Variables Case Sensitive Search Partial Match Search Return the Last Record - Bottom-to-Top Search Request Update Confirmation Require a Password to Update a Record Update only Certain Fields from the Form Delete Data without Using a Popup Window Request Delete Confirmation Require a Password to Delete a Record Reset Form Validation after Deleting Data Add or Remove Password Protection for the Macros and VBA Project Better VBA for Clearing the Form Clear Form Button Ensure ID Values are Stored and Retrieved Correctly Remove Auto-Password Protect Option in VBA Rename VBA Modules for Better Readability Formatting the Form Adding Validation to the Form Add Error Display and Macro Functionality to the Form Protect the Form Save Form Data View Saved Data Update Data Delete Data Import Series - Import CSV TXT File into Excel Import Series - Power Query - Overview Import Series - 5 Tricks to Copy Excel Data to Other Workbooks Easy Excel Web Import VBA Macro to Import Web Data into Excel Access to Excel Data Import Excel Tricks to Clean Data Little-Known Printing Tricks for Excel Reusable Cover Page for Printing The Best Tips for Recording Macros in Excel Excel VBA Tip - Stop Selecting Cells! Force a User to Enable Macros in Excel - Advanced Version The Best Find & Replace Tricks for Excel Convert Excel Dates into Text 3 Amazing Tricks to Add Alternate Row Colors in Excel Transpose Every X Number of Rows in Excel - Advanced Transpose Technique Simple Excel Function to Combine Values in All Versions of Excel - UDF Easy Excel Formulas Every N Rows - Not an Array 3 Simple Tips for Quickly Understanding Large Spreadsheets in Excel Ignore Zeros with MIN() & Other Functions in Excel Filter Data as you Type in Excel Make a UDF with Variable Number of Arguments in Excel Lookup to Return the 2nd, 3rd, or Nth Matching Result in Excel - VLOOKUP & INDEX How to Use INDEX MATCH Lookups in Excel - Step-by-Step Guide 5 Awesome Tips to Save Time Working with Huge Worksheets in Excel Send Emails from Excel - Automatically and by Hand Extract Text Before or After the 1st, 2nd, 3rd, Nth Delimiter in Excel Convert Month Names to Numbers and Numbers to Names in Excel Use Macros on Password Protected Worksheets in Excel Advanced Data Filters in Excel - Introduction Run a Macro when a User Changes a Specific Cell Range or Any Cell in Excel INDIRECT Function in Excel - Powerful Range References SUMPRODUCT in Excel - Introduction The Power of TRUE FALSE in Excel Check Multiple Conditions in Excel - 5 Awesome Tips and Tricks Data Sensitivity Analysis in Excel - What If Data Tables Advanced Decision Making using CHOOSE in Excel Exclude Cells that are Filtered, Hidden or Grouped from Formulas Advanced Worksheet Controls in Excel using a Checkbox Link Worksheet Form Controls with Cells on Protected Worksheets without VBA Macros in Excel Prevent Duplicate Values in a Range 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 5 Tips for Evaluating Complex Formulas in Excel Top Tips for Using Named Ranges in Excel 6 Must Know Text Manipulation Extraction Functions in Excel Amazing 3D Formulas in Excel Run Macros at Set Intervals in Excel Deconstructing Complex Formulas in Excel 3 Ways to Automatically Update Drop Down Lists in Excel - Data Validation Calculate Days Between Dates Excluding Weekends and Holidays Coronavirus Stats Analysis in Excel Analyze Dynamically Sized Data Sets in Excel Activate vs Select vs Selection vs ActiveCell Goal Seek in Excel - 2 Methods - Automated and By Hand Get, Input, Clear, and Move Values Around a Worksheet Storing Data in the Macro Copy and Paste Data Working with Formulas Insert/Delete Cells, Ranges, Rows & Columns Additional Ways to Get/Input Data into the Worksheet Excel Input Form with Macros and VBA Reference Cells and Ranges Advanced Range Selection Reference Rows and Columns Activate vs. Select - The Important Difference User Selected Cells and Ranges Offset Ranges Select Cells, Ranges, Rows and Columns within Other Ranges Never Select Cells Again Reference Worksheets Additional Method to Reference Worksheets Navigate to and Select Worksheets Work on the Currently Visible Worksheet Reference Cells and Ranges on Other Worksheets Adding and Removing Worksheets Work on New Worksheets - Rename, Add Data, etc. Move and Copy Worksheets Common Worksheet Properties Reverse FIND Formula in Excel - Easily Get the Last Words from Cells Division Me Crazy - 2 Ways to Divide Numbers in Excel VBA IF Statement - The Foundation of Decision Making IF Statement Advanced Select Case Statement - Make More Readable Decisions With Statement - Easier Code Writing GoTo Statement - The correct way to use this! Simplify Complex IF Statements Case Insensitive Checks - Control How VBA Compares Text Arithmetic Operators - Let's Do Math! Comparison Operators Logical Operators - Allow Multiple Conditional Checks Operator Precedence - Control What Occurs When WILDCARD Vlookup to Return All Matches VBA File Selection Window to Open Files in Excel Regular Expression Search Formula in Excel - Regex Make Better IF Statements in Excel - Learn to Convert Complex Formulas into True False Values Create an Index / Table of Contents worksheet SEARCH() vs FIND() Function in Excel PI() Function in Excel - Math not Food Fastest Way to Remove Formatting in Excel How to Make Macros Run Automatically Workbook Automation Events - Opening, Closing, Saving and Navigating Worksheets Worksheet Automation Events - Activating, Selecting, Changing Data and Navigating Worksheets ME to the Rescue - Making Life Easier Run a Macro When a Specific Cell, Range, Row or Column Changes Prevent Endless Loops with Error Handling in Events - The Better Way Force the User to Enable Macros to use the Workbook Highlight the Selected Cell Verify User Input or Undo It Don't Let the User Leave a Worksheet Until They Complete a Task What is an Array in VBA and How to Make Your First Array Static Arrays - You Decide the Size Dynamic Arrays Part 1 - Increased Flexibility Dynamic Arrays Part 2 - Dynamic Resizing Multi-Dimensional Arrays - First Step to Working with Ranges in Arrays Arrays & Ranges Part 1 - Super Fast Range Evaluation Arrays & Ranges Part 2 - Dynamic Ranges & Single Cell Selection Easy Array Looping - Look but Don't Touch Helpful Array Features - Clearing, Checking, Splitting, Joining and Option Base 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 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