Excel Forum
Tutorials: Data Analysis in Excel


Goal Seek Feature in Excel  (Intermediate)
- The goal seek tool in Microsoft Excel allows you to use excel to figure out what
Extract Text from cells in Excel - How to get any word from a cell in Excel  (Intermediate)
- This Excel video tutorial shows you how to extract text from cells. Specificall
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
Create Dynamic Named Ranges in Excel Across Rows Going Up/Down  (Intermediate)
- This is a great tutorial which shows you how to make a named range within Excel