Excel 2016: Working with Formulas


Overview/Description
Expected Duration
Lesson Objectives
Course Number
Expertise Level



Overview/Description

In addition to simple formulas, Excel 2016 has the power to solve more complex calculations. Explore how to calculate loan interest and payments, use the Goal Seek and forecast tools, and find and prevent duplicate values.



Expected Duration (hours)
0.7

Lesson Objectives

Excel 2016: Working with Formulas

  • Calculating the interest on a loan
  • Simulating a loan
  • Reaching a target value
  • Solving a problem
  • Using the forecast tool
  • Creating automatic reports
  • Finding identical values in your spreadsheet
  • Finding duplicates in your document
  • Visualizing your duplicate values
  • Preventing duplicate values
  • Course Number:
    ds_msex2016_10_enus

    Expertise Level
    Intermediate