 |
|
|
|
| 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 Add a Formula to the Pivot Table [Excel: Pivot Tables]
Summary: How to add a formula to the Budget vs. Actual Expense Pivot Table. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
Disable Automatic GETPIVOT Function [Excel: Pivot Tables]
Summary: Create formulas outside of a pivot table yet still reference the data within the pivot table. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
GETPIVOTDATA Formula [Excel: Pivot Tables]
Goal: Use the GETPIVOTDATA formula allows the retrieval of data from a PivotTable report while its structure is being changed. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003
How to Add a Running Balance Calculation Column [Excel: Pivot Tables]
Goal: How to Add a Running Balance Calculation Column. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003
|
|
|
|
|
|