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 ]