Excel formulas and functions are helpful in all types of spreadsheet applications. They are essential for manipulating data and obtaining valuable information.

This course will expand your understanding and use of Excel by focusing on the techniques that help you build helpful worksheet formulas and enhance spreadsheet functionality. Learn to create formulas, import, export, and validate data, and more. Understand how to adjust values to be able to calculate how to reach outcome goals, as well as how time-related functions work in Excel.

Topics Include:

• Operators
• How to use built-in Excel functions
• How to use the Insert Function tool
• SUMIF, SUMIFS, AVERAGEIF, AVERAGEIFS
• Relative, Absolute, and Mixed Cell References, Formulas with Tables
• Named Cells and Ranges
• Time formatting and functions
• Using logical functions to create conditional results, including IF statements
• Using powerful lookup functions, such as VLOOKUP and XLOOKUP
• Troubleshooting Formulas and Functions
• Data Validation

CEUs are awarded based on the number of scheduled contact hours.