Working with Formulas in Excel 2016 for Windows

Excel 2016 (Windows)    |    Intermediate
  • 10 videos | 40m 3s
  • Includes Assessment
  • Earns a Badge
Likes 116 Likes 116
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.

WHAT YOU WILL LEARN

  • 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

IN THIS COURSE

  • Playable
    1. 
    Calculating the interest on a loan in Excel 2016 for Windows
    3m 19s
    UP NEXT
  • Playable
    2. 
    Simulating a loan in Excel 2016 for Windows
    4m 22s
  • Locked
    3. 
    Reaching a target value in Excel 2016 for Windows
    4m 38s
  • Locked
    4. 
    Solving a problem in Excel 2016 for Windows
    6m 3s
  • Locked
    5. 
    Using the forecast tool in Excel 2016 for Windows
    5m 18s
  • Locked
    6. 
    Creating automatic reports in Excel 2016 for Windows
    4m 22s
  • Locked
    7. 
    Finding identical values in your spreadsheet in Excel 2016 for Windows
    2m 47s
  • Locked
    8. 
    Finding duplicates in your document in Excel 2016 for Windows
    3m 6s
  • Locked
    9. 
    Visualizing your duplicate values in Excel 2016 for Windows
    3m 51s
  • Locked
    10. 
    Preventing duplicate values in Excel 2016 for Windows
    2m 18s

EARN A DIGITAL BADGE WHEN YOU COMPLETE THIS COURSE

Skillsoft is providing you the opportunity to earn a digital badge upon successful completion on some of our courses, which can be shared on any social network or business platform.

Digital badges are yours to keep, forever.

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 231 Likes 231  
Likes 100 Likes 100