Mastering 2013 Excel Functions and Formulas 2015

Topics

• Converting formulas to values
• Displaying and highlighting formulas
• Understanding the hierarchy of operations in formulas
• Creating 3D formulas to gather data from multiple sheets
• Creating and expanding the use of nested IF statements
• Using absolute and relative references
• Using the power functions: COUNTIF, SUMIF, and AVERAGEIF
• Looking up information with VLOOKUP, MATCH, and INDEX
• Performing basic math
• Analyzing data with the statistical functions
• Editing text with functions
• Calculating dates and times
• Checking for errors with formulas

Who should Attend

• Finance
• Banking
• Sales
• Marketing
• Pharmacy
• Investments
• Audit
• Accounts
• Credit Unions