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
    FREE ACCESS
  • Locked
    4. 
    Solving a problem in Excel 2016 for Windows
    6m 3s
    FREE ACCESS
  • Locked
    5. 
    Using the forecast tool in Excel 2016 for Windows
    5m 18s
    FREE ACCESS
  • Locked
    6. 
    Creating automatic reports in Excel 2016 for Windows
    4m 22s
    FREE ACCESS
  • Locked
    7. 
    Finding identical values in your spreadsheet in Excel 2016 for Windows
    2m 47s
    FREE ACCESS
  • Locked
    8. 
    Finding duplicates in your document in Excel 2016 for Windows
    3m 6s
    FREE ACCESS
  • Locked
    9. 
    Visualizing your duplicate values in Excel 2016 for Windows
    3m 51s
    FREE ACCESS
  • Locked
    10. 
    Preventing duplicate values in Excel 2016 for Windows
    2m 18s
    FREE ACCESS

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.

YOU MIGHT ALSO LIKE

Book Excel Functions & Formulas in Easy Steps
Course Using Formulas to Calculate & Manage Data in Google Sheets 2020
Likes 10 Likes 10  
Course Using Basic Formulas in Excel 2019 for Windows
Likes 266 Likes 266  

PEOPLE WHO VIEWED THIS ALSO VIEWED THESE

Course Formatting Data in Excel 2016 for Windows
Likes 231 Likes 231  
Course Referencing Data in Excel 2016 for Windows
Likes 100 Likes 100  
Course Configuring Options & Settings in Excel 2016 for Windows
Likes 60 Likes 60