Excel Forum
Excel VBA Course

(35% Sale Ends Jan. 26)

Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course (35% Discount)



  • Make Column Headings Numbers instead of Letters - Make R1C1 Style References in Excel 2007  
  • Set a Photo/Image as an Excel Worksheet Background  
  • No more #DIV/0!  
  • Display Comments (without hunting for them) - Excel 2003  
  • Quickly Find All Comments in a Spreadsheet in Excel  
  • Error Values in Excel - Full Explanation  
  • 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  
  • Convert Numbers Stored as Text to Numbers in Excel  
  • Mark an Excel File as Complete and Final Version  
  • Add Notes and Comments to Cells in Excel  
  • Prevent a User from Changing Any Data in Excel  
  • Stop Formula Calculation in Excel - Increase Worksheet Performance  
  • Excel Formatting for Zip Codes and Phone Numbers  
  • Quickly Combine a List of Values and Put a Delimiter Between Each Value in Excel  
  • Store Large Numbers in Excel  
  • Quickly Create a Huge List of Numbers in Excel  
  • Hide Data Within a Worksheet in Excel  
  • Delete All Empty Rows or Blank Cells from a Range in Excel  
  • Generate Random Numbers within a Range in Excel  
  • Top Excel Keyboard Shortcuts to Increase Productivity  
  • Quickly Resize Multiple Columns or Rows at Once in Excel  
  • Enable the Analysis ToolPak in Excel  
  • Install Solver Add-In for Excel  
  • Easily Enter Fractions into Excel  
  • How to Get a Free Excel Trial  
  • Easy Way to Manage Names in Excel  
  • Add Formatting to Comments in Excel  
  • Increment a Date By X Days for Each Row in Excel  
  • Link to a Location Within the Spreadsheet in Excel  
  • Turn Off the Formatting Window Popup in Excel  
  • Excel Prank - Automatically Change User-Entered Text  
  • Excel Prank - Prevent Closing a Workbook  
  • Average Non-Contiguous Cells in Excel  
  • Convert Column Number to Letter Using a Formula in Excel  
  • Input Really Long Numbers into Excel  
  • Wildcards in Excel  
  • Manually Calculate Formulas and Functions in Excel  
  • Excel Formulas Won't Update  
  • Convert Numbers into True and False in Excel  
  • Sum Values from Every X Number of Rows in Excel  
  • Sum a Range with Errors 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  
  • Count the Occurrences of the Largest or Smallest Value in a Range  
  • Edit Multiple Worksheets at Once in Excel  
  • View Separate Parts of a Worksheet at Once in Excel  
  • View Separate Worksheets at Once in Excel  
  • Excel Prank - Random Cell Selection  
  • Excel Prank - Random Pop-up Window  
  • Excel Prank - Hide Text on Cell Selection  
  • 10 Excel Tricks for Formulas  
  • 15 MUST KNOW Excel Keyboard Shortcuts  
  • Instantly Fill Thousands of Rows with Numbers, Dates, or Formulas  
  • The Best Find & Replace Tricks for Excel  
  • Keep Leading Zeros in Numbers in Excel - 2 Ways  
  • Link Worksheet Form Controls with Cells on Protected Worksheets without VBA Macros in Excel  
  • Sparkling Christmas Tree in Excel  
  • Top Tips for Using Named Ranges in Excel  
  • Run Macros at Set Intervals in Excel  
  • Division Me Crazy - 2 Ways to Divide Numbers in Excel VBA  
  • Use Colors to Organize Excel Tabs  
  • Find the Most Frequently Occurring Number in a List  
  • Excel 365 Wildcard Vlookup to Return All Partial Matches  
  • Excel Prank - Sheet Jumping  
  • Excel Formula Formatting Trick to Make Life Easier  
  • Show the Current Date Every Day in Excel (or Time)  
  • Better Edit Excel Formulas in the Conditional Formatting Window or Name Manager  
  • Open PDF from Excel  
  • Excel ToolTips on Mouse Hover for Buttons and Shapes  
  • 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  
  • TEXTJOIN with Different Delimiters at Once in Excel  
  • Easily Tab/Enter Through Input Forms in Excel - Faster/Better Forms in Excel  
  • Text to Number Format Formula in Excel  
  • Require a Password to View Hidden Worksheets in Excel - VBA Tutorial  
  • Excel Date Filter Magic - Last Month, This Month, YTD & More + Awesome Interface  
  • 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  
  • Get the Decimal Part of a Number in Excel  
  • Get the Integer Part of a Number in Excel  
  • Toggle Visible Items in Excel Using a Button  
  • 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  
  • Custom Data Views Controlled by a Drop Down Menu 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  
  • Add Check Marks to Cells by Double-Clicking or Typing  
  • Simple Checkbox Control in Excel  
  • Easier Table References in Excel  
  • Use Pivot Tables and Slicers on Protected Worksheets  
  • Option Buttons with Formulas in Excel  
  • Make Quick Lists for Drop Down Menus - Save A LOT of Time  
  • Hide Formulas in Excel  
  • Convert Scientific Notation to Numbers in Excel  
  • The Running Turkey in Excel - Happy Thanksgiving :)  
  • Turkey Takeover in Excel - Turkeys Everywhere Edition