Monday 6 December 2010

Excel tutorial: How to tabulate single criterion totals | lynda.com

Title:
Excel tutorial: How to tabulate single criterion totals | lynda.com


Video:


Description:This Excel tutorial shows how to tabulate single criterion totals using the COUNTIF, SUMIF, and AVERAGEIF functions. Watch more at www.lynda.com This specific tutorial is just a single movie from chapter five of the Excel 2010: Advanced Formulas and Functions course presented by lynda.com author Dennis Taylor. The complete Excel 2010: Advanced Formulas and Functions course has a total duration of 5 hours and reviews the building-block functions, along with critical keyboard shortcuts that will speed up working with Excel data. Excel 2010: Advanced Formulas and Functions table of contents: Introduction 1. Formula and Function Tips and Shortcuts 2. Formula and Function Tools 3. IF and Related Functions 4. Lookup and Reference Functions 5. Power Functions 6. Statistical Functions 7. Data Functions 8. Math Functions 9. Array Formulas and Functions 10. Text Functions 11. Financial Functions 12. Informational Functions 13. Reference Functions Conclusion

Published:
06/Dec/2010

No comments:

Post a Comment