Get straightforward instruction on the most common and most powerful functions in Excel in this 4-hour intensive workshop. 

Learning Objectives

By the end of this course, students will be able to:

• Apply logical functions such as IF, AND, and OR to create decision-based formulas.
• Use conditional counting and summing with COUNTIF, COUNTIFS, SUMIF, and SUMIFS to analyze datasets.
• Perform lookup operations using VLOOKUP, HLOOKUP, and INDEX/MATCH to retrieve data from tables.
• Combine multiple functions to solve practical spreadsheet problems efficiently.
• Demonstrate best practices for structuring formulas, handling errors, and ensuring data integrity.
• Interpret and analyze real-world datasets using these functions to answer business and research questions.

Contact Hours/CEUs

4.0 / 0.4

Instructors

Behrooz Mansouri

James Quinlan