Excel Formulas

TradingRothIRA.com - IRA Investment Ideas, News and Stock Analysis Excel Templates!

Excel is a powerful program. However, Excel's powerful features are only as good as the person who can use it.

Now, you can make it more powerful by learning new Excel Formulas. Excel formulas for basic number crunching, as

well as more complex calculations such as payroll deductions, accounting or financial analysis.

New Excel Formulas:

How to Create Data Validation

Summary: How to Create Data Validation. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

1. Input the following in "Option Tab"

Bull

Bear

Stock

Market

Margin of Safety

2. Highlight them > Define Name > Name it "Stock"

3. Go to "Data Tab" and highlight Column A

4. Go to Data > Data Validation

5. Settings > Allow: List > Source: =Stock

Click Ok