Most Viewed Tips

• Create User Forms in Microsoft Excel (650708 views)
  
  
• Using Loops in VBA in Microsoft Excel (609339 views)
  
  
• The Best Shortcut Keys in Microsoft Excel (373239 views)
  
  
• Writing Your First VBA Function in Excel (338796 views)
  
  
• Add Combo Box to a Sheet in Microsoft Excel (253202 views)
  
  
• Formulas to calculate Loan payments in Microsoft Excel (241447 views)
  
  
• Array variables using VBA in Microsoft Excel (221785 views)
  
  
• Create an Amortization Schedule in Microsoft Excel (194678 views)
  
  
• Find duplicates items in combine columns in Microsoft Excel (173428 views)
  
  
• Vlookup Formula – Organizing the Data Table (161537 views)
  
  
• Combine the VLookup and Match formulas in Microsoft Excel (155966 views)
  
  
• Converting Time to Decimal Values (150927 views)
  
  
• Import data from Access to Excel (ADO) using VBA in Microsoft Excel (145142 views)
  
  
• Working Out a Person's Age in Microsoft Excel (135839 views)
  
  
• Calculate number of minutes between dates - time in Microsoft Excel (131091 views)
  
  
• Deleting Empty Rows (126331 views)
  
  
• Calculating the Difference Between Hours (122038 views)
  
  
• Creating a PivotTable Report (118328 views)
  
  
• Use messageboxes using VBA in Microsoft Excel (117937 views)
  
  
• Fill a ListBox-control with values from another workbook using VBA in Microsoft Excel (115635 views)
  
  
• Calculate Years, Months, Days elapsed from a certain date in Microsoft Excel (112184 views)
  
  
• Delete rows and columns using VBA in Microsoft Excel (112156 views)
  
  
• Calculating Differences Between Dates (105009 views)
  
  
• Export data from Excel to Access (ADO) using VBA in Microsoft Excel (99361 views)
  
  
• Square root and cube root in Microsoft Excel (97581 views)
  
  

By Version

Recommended Tips

1. Calculating the Week Number
2. Changing a Numeric Heading to Text
3. Preventing Moving to the Next Cell After Typing
4. Counting the Number of Excel Files in a List According to File Type and Date Criteria
5. Printing a Chart in Microsoft Excel

By Category

	Excel General
	Excel Text, Editing and Format
	Excel Date and Time
	Excel Formula and Function
	Excel Data
	Excel Macros and VBA