 |
|
|
|
| ThinkTutor.com - Sign up a free ThinkTutor.com account and enroll our free Excel course! |
|
|
|
|
|
|
|
|
|
|
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. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Add-Ins, Charts, Conditional Formatting, Custom Views, Customizing Excel, Data Entry, Editing, Financial Accounting, Financial Formulas, Files, Filtering, Find and Replace, Formatting, Formulas, General, Graphic, Macros, Online Data and Web, Page Setup, Pivot Tables, Shortcut Keys, Sorting, Subtotals, Others.. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| New Excel Formulas:
|
|
How to Coloring Cells with Formulas [Excel: Formatting]
Summary: How to quickly find out where all the formulas are in a worksheet. 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
Applying a Style [Excel: Formatting]
Goal: Apply a defined style throughout the worksheet. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003
Color a cell's Background [Excel: Formatting]
Goal: Color a cell's Background based on the result of the formula. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003
Highlighting Cells Containing Specific Text [Excel: Formatting]
Goal: Using conditional formatting feature in Excel to draw attention to cells that contain specific text in which you are interested. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003
|
|
|
|
|
|