 |
|
|
|
| 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 Create Formulas Comparing Lists for Duplicates [Excel: Formulas]
Summary: How to Create Formulas Comparing Lists for Duplicates to see if there is duplicate information. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
Finding The First Non-Digit Position [Excel: Formulas]
Summary: How to find out where the digits stop and the non-digits begin in a string of text that is composed of digits and non-digits. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
How to Determining "Highest Since" or "Lowest Since" [Excel: Formulas]
Summary: Analyzes the latest houses sold data, and needs to write a report about the data. For example "The number of houses sold was the lowest since Jan 1989". Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
ISTEXT(A1) - Find Any Text Function [Excel: Formulas]
Summary: Use the ISTEXT Function to check if a cell has any text in it. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
Calculate the Average of Numbers, Ignoring zero (0) Values [Excel: Formulas]
Summary: Averages the numbers in the list except those that contain zero, such as cell A6 (11.4). Works with Microsoft Excel versions: 2007
[ Prev 1 2 3 4 5 6 7 8 Next ] |
|
|
|
|
|