- Cart is empty!
Lynda.com Excel 2013: Advanced Formulas and Functions
Size : 763.90Mb
Product ID : 1758
Skill Level: Advanced
Duration: 5h 26m
Author: Dennis Taylor
Topics include:
- Displaying and highlighting formulas
- Converting formulas to values
- Creating 3D formulas to gather data from multiple sheets
- Understanding the hierarchy of operations in formulas
- Using absolute and relative references
- Creating and expanding the use of nested IF statements
- Looking up information with VLOOKUP, MATCH, and INDEX
- Using the power functions: COUNTIF, SUMIF, and AVERAGEIF
- Analyzing data with the statistical functions
- Performing basic math
- Calculating dates and times
- Editing text with functions
- Checking for errors with formulas