Microsoft Excel 2016 Essentials: Formulas and Functions

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


Expected Duration
68 minutes

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.



  • 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





Multi-license discounts available for Annual and Monthly subscriptions.