Excel Formula Home
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:
Using Angled Text and Borders in Excel
[Excel: Custom Views]
Summary: Use the Wrap text option (Format menu, Cells command, Alignment tab) to make a multiple-word label narrower, but sometimes that's not enough. Vertical text is an option, but it can be difficult to read and takes a lot of vertical space. You may want to try using rotated text and cell borders instead, as shown in the following picture. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
Text Formula
[Excel: Formatting]
Summary: Create a grammatically correct sentence from several columns of data for a mass mailing or format dates with text without affecting formulas that use those dates. To combine text with a date or time, use the TEXT function and the & (ampersand) operator. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
WEEKDAY Formula
[Excel: Excel Formulas]
Summary: Using the WEEKDAY(serial_number,return_type) returns the day of the week corresponding to a date. The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday), by default. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
Straight Line Depreciation Excel Formula
[Excel: Excel Formulas]
Summary: Using the SLN Function to returns the straight-line depreciation of an asset for one period. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
How to use the Future Value of Money Formula
[Excel: Financial Formulas]
Summary: Using the FVM(AnnPmt, PresentValue, InterestAER, TermYrs, PmtsPerYear) Formula. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

[ Prev 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 Next ]