Excel 2016 Essentials – Formulas and Functions

Overview

Microsoft Excel 2016 allows you to perform complex calculations in the workbook data. The ability to use formulas to complete calculations not only simplifies your work, but also helps you reduce the number of errors that can occur in those complex tasks. In this course, you will learn about the basics and terminology associated with formulas and functions. You will learn about the various ways to refer to cells and cell ranges and how you can use basic functions including logical and IF functions.

Objectives

• Create basic formulas in Microsoft Excel 2016
• Recognize formula operators in Microsoft Excel 2016
• Recognize the order of operations in Microsoft Excel 2016
• Create cell ranges named in Microsoft Excel 2016
• Use cell ranges named in formulas in Microsoft Excel 2016
• use the SUM function to calculate totals in Microsoft Excel 2016
• calculate the AVERAGE, COUNT, MIN and MAX value 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 function IF in Microsoft Excel 2016
• Manage errors using IF ERROR in Microsoft Excel 2016