Working with Formulas

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
    3m 19s
    UP NEXT
  • Playable
    2. 
    Simulating a loan
    4m 22s
  • Locked
    3. 
    Reaching a target value
    4m 38s
  • Locked
    4. 
    Solving a problem
    6m 3s
  • Locked
    5. 
    Using the forecast tool
    5m 18s
  • Locked
    6. 
    Creating automatic reports
    4m 22s
  • Locked
    7. 
    Finding identical values in your spreadsheet
    2m 47s
  • Locked
    8. 
    Finding duplicates in your document
    3m 6s
  • Locked
    9. 
    Visualizing your duplicate values
    3m 51s
  • Locked
    10. 
    Preventing duplicate values
    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 of this course, which can be shared on any social network or business platform

Digital badges are yours to keep, forever.

YOU MIGHT ALSO LIKE

COURSE Managing Data
Likes 112 Likes 112  
Likes 255 Likes 255  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Likes 41 Likes 41  
Likes 282 Likes 282  
Likes 809 Likes 809