• 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  
  • How to use the 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  
  • Reference 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  
  • How to Use the IF Function in Excel  
  • 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 Text 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  
  • 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 and Sort 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  
  • 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  
  • 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  
  • 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 Day Name 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