KnowledgeCenters     Microsoft Office 2013 KnowledgeCenter     Microsoft Office 2013 Courses

---

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.

---

---

Objectives

Formulas 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 Logical and IF-type Functions 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 Practice: Formulas and Functions create a formula and named cell range and use functions to perform calculations in Microsoft Excel 2016