Analyzing Data Using Formulas

As you have learned,formulas and functions help you to analyze worksheet data. As you learn how to use different types of formulas and functions,you will discover more valuable uses for Excel.In this unit, you will gain a deeper understanding of Excel formulas and learn how to use several Excel functions.

MICROSOFT EXCEL 2007 TRAINING

Analyzing Data Using Formulas







Topic:-

1. Formatting data using text functions.
2. Sum a data range based on conditions
3. Consolidate data using a formula
4. Check formulas for errors
5. Construct formulas using named ranges
6. Build a logical formula with IF function
7. Build a logical formula with AND function
8. Calculate payments with the PMT function
Analyzing Data Using Formulas A

Analyzing Data Using Formulas B