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
Beginner