 |
|
|
|
| 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:
|
|
Shading a Cell Until Something is Entered [Excel: Conditional Formatting]
Goal: Creating a worksheet in which information must be entered into specific cells, it's helpful to shade the cells if they are blank, but have the shading removed if something is entered into the cell. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003
Coloring Rows with Conditional Formatting [Excel: Conditional Formatting]
Goal: Coloring every other rows with conditional formatting to make it easier to read on screen or printout. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003
Creating Ledger Shading [Excel: Conditional Formatting]
Goal: Ledger shading is formatting in which rows alternate cell shading between a light color and a slightly darker color. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
|
|
|
|
|
|