Formulas
Training and Tutorial Resources:
Advanced Formulas in Excel
Topics in this MS Excel tutorial are: Using a List Box to Change Data Displayed on a Worksheet; IRR, XIRR, NPV, XNPV Functions; Maximum Sustainable Growth, and Four Methods of Adding Totals to a List
Review It Rate It Bookmark It
Using Excel Formulas and Functions
Formulas and functions in Excel give the user a powerful method to calculate and solve numeric problems and build what-if type scenarios. This tutorial shows how to begin a formula, tells about the parts of a formula, the structure of a formula, functions, nested functions, operators, names and labels in formulas and much, much more. (pdf, 17 pages, 137kb)
Review It Rate It Bookmark It
Using Formulas in Excel
This MS Excel tutorial covers the following: Use SUMIF instead of D... Functions, Comparative Ratio Analysis, Indicator Lights, Create a Year to Date Total, Use F9 to Look Inside a Formula, and Take a Shortcut with SUMIF.
Review It Rate It Bookmark It
Topics in this MS Excel tutorial are: Using a List Box to Change Data Displayed on a Worksheet; IRR, XIRR, NPV, XNPV Functions; Maximum Sustainable Growth, and Four Methods of Adding Totals to a List
Review It Rate It Bookmark It
Using Excel Formulas and Functions
Formulas and functions in Excel give the user a powerful method to calculate and solve numeric problems and build what-if type scenarios. This tutorial shows how to begin a formula, tells about the parts of a formula, the structure of a formula, functions, nested functions, operators, names and labels in formulas and much, much more. (pdf, 17 pages, 137kb)
Review It Rate It Bookmark It
Using Formulas in Excel
This MS Excel tutorial covers the following: Use SUMIF instead of D... Functions, Comparative Ratio Analysis, Indicator Lights, Create a Year to Date Total, Use F9 to Look Inside a Formula, and Take a Shortcut with SUMIF.
Review It Rate It Bookmark It
Free Microsoft Office Training and Tutorial Resources blog
Free Training for Photoshop, Flash, Dreamweaver, FrontPage, and other Adobe Macromedia Apps blog
Free Web Design, Development and Programming Training and Tutorial Resources blog
Free Programming and Technical Computer Training and Tutorials blogs
Also Visit our New Free Training site, "Training By Email", and our new "Learn More About" section
If you have any questions or comments please me. I'd love to hear from you.