# Course Details

### Microsoft Excel 2016 Essentials: Formulas and Functions

Overview/Description
Target Audience
Prerequisites
Expected Duration
Lesson Objectives
Course Number
Expertise Level

Overview/Description
Microsoft Excel 2016 allows you to perform complex calculations on your workbook data. Being able to use formulas to complete calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. In this course, you will learn about the basic concepts and terminology associated with formulas and functions. You will learn about the various ways of referring to cells and cell ranges, and how to use basic functions including logical and IF-type functions.

Target Audience
Personnel at all levels of the enterprise; end users seeking to attain competency in Microsoft Excel 2016; end users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2016; end users seeking a basic IT certification

Prerequisites
None

Expected Duration (hours)
1.1

Lesson Objectives

Microsoft Excel 2016 Essentials: Formulas and Functions

• start the course
• create basic formulas in Microsoft Excel 2016
• recognize Microsoft Excel 2016 formula operators
• recognize the order of operations in Microsoft Excel 2016
• create named cell ranges in Microsoft Excel 2016
• use named cell ranges in formulas in Microsoft Excel 2016
• use the SUM function to calculate totals in Microsoft Excel 2016
• calculate the AVERAGE, COUNT, MIN, and MAX of a column or row of numbers in Microsoft Excel 2016
• use the AND, OR, and NOT functions in Microsoft Excel 2016
• apply conditional logic using the IF function in Microsoft Excel 2016
• handle errors using IFERROR in Microsoft Excel 2016
• create a formula and named cell range and use functions to perform calculations in Microsoft Excel 2016
• Course Number:
mo_beel_a04_dt_enus

Expertise Level
Everyone