Published on 18 May 2013 | over 3 years ago

If you're trying to tabulate data from large lists, you'll want to use either the COUNTIF, SUMIF, or AVERAGEIF functions in Excel. Find out how to use these functions in this tutorial. Watch more at www.lynda.com/Excel-tutorials/Excel-2013-Advanced-Formulas-Functions/126129-2.html .

This tutorial is a single movie from the Excel 2013: Advanced Formulas and Functions course presented by lynda.com author Dennis Taylor. The complete course duration is 5 hours and 26 minutes long and demystifies some of the most challenging of the 300+ formulas and functions in Excel and shows how to put them to their best use.

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. Math Functions
8. Date and Time Functions
9. Array Formulas and Functions
10. Reference Functions
11. Text Functions
12. Information Functions
Conclusion

Loading related videos...