 |
|
|
|
| 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 Converting Cells to Proper Case [Excel: Macros]
Summary: How to create an Excel Macro to change cells from uppercase to lowercase. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
Auto Combining Columns [Excel: Macros]
Summary: How to automatically combined three columns together into the first column of each row. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
Magnifying Only the Current Cell [Excel: Macros]
Summary: How to use the zoom feature of excel to magnify what Excel shows of your selected cell. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
Paste Special a Formula [Excel: Macros]
Summary: For example, you may have the value of 10 in cell A3 to A 10, and you want to increase it by 20%. Using Paste Special you can easily change it to 120, but you may instead want to replace the value with the formula =100*1.2. Works with Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007
Sort By Colors [Excel: Excel Templates, Macros]
Excel allows you to sort the data in your worksheets by any number of attributes. One of the things that you cannot intrinsically sort by, however, is the color of cells. For some applications this could be a very handy feature. The following macro template, will sort a table based on the color with which a cell is formatted.
Download Template
|
|
|
|
|
|