Excel Forum
Tutorials: Tips and Tricks in Excel


Remove #N/A Error Result from Empty VLOOKUP() Formulas  (Intermediate)
- This video tutorial will show you how to remove the #N/A error that results in a
Assign Keyboard Shortcuts to Macros  (Easy)
- How to assign a keyboard shortcut to a macro after is has been recorded. Good if
Printing Multiple Worksheets and Workbooks  (Easy)
- You will learn how to print multiple worksheets at one time, part of one workshe
How to 'Protect' a Worksheet and Workbook  (Easy)
- You can make it so that no one, or only a certain person or group of people, can
Password Protect Excel Workbook Files  (Easy)
- You can password protect your excel files and make it so that only one person or
Hide Rows & Columns in Excel  (Easy)
- Here, you will learn how to protect data in your worksheets by hiding it. You ca
Dynamically Update a Drop Down Menu/List  (Intermediate)
- This Excel video tutorial shows you how to create a dynamically updating drop-do
Create a Drop Down Menu with Data Validation in Microsoft Excel  (Easy)
- The Excel video tutorial shows you how to create a drop-down list/menu in excel.
Quickly Copy/Paste Data, Formulas, Text in Excel Using the Quick Fill Handle  (Easy)
- This Excel video tutorial shows you how to quickly copy and paste data and formu
Allow only values contained in a list to be entered into a cell - Data Validation  (Intermediate)
- This Excel video tutorial shows you how to use Data Validation to prevent a user
Dynamically Updated Vlookup Table in Microsoft Excel  (Intermediate)
- This Microsoft Excel tutorial shows you how to make a dynamically updating vlook
Prevent Duplicate Values being entered in a List in Excel - Allow only unique values to be entered.  (Intermediate)
- This Microsoft Excel video tutorial shows you how to make a list in excel where
Generate Random Numbers (Integers) in Microsoft Excel  (Easy)
- This Excel video tutorial shows you how to generate random numbers (integers) in
Insert Macros into an Excel Workbook or File and Delete Macros from Excel  (Intermediate)
- This video tutorial shows you how to insert a macro you may find on the internet
Generate Random Numbers with Decimals in Microsoft Excel  (Intermediate)
- This tutorial shows you how to generate random numbers which have decimals in ex
Change Columns from Letters to Numbers in Excel 2007  (Easy)
- This free excel video tutorial shows you how to change the columns in excel 2007
Combine/Merge Cells in Microsoft Excel - Make Better Headers  (Easy)
- This Microsoft Excel video tutorial shows you how to merge a cell in Excel. Thi
Count Cells That Only Contain Text in Microsoft Excel  (Easy)
- This Excel video tutorial shows you how to write a formula which will count the