SharePoint-Creating Calculations with Financial Functions

SharePoint Spotlight Series!

This short video introduces financial functions that are similar to Excel’s financial functions. Several use cases are examined along with examples within SharePoint lists.

What you’ll learn

  • Basic Formula and Function Syntax.
  • An introduction to financial functions.
  • The FV, PV, and NPV functions.
  • The PMT, PPMT, and IPMT functions.

Course Content

  • Introduction –> 1 lecture • 2min.
  • Creating Financial Functions –> 8 lectures • 38min.
  • Conclusion –> 1 lecture • 2min.

Auto Draft

Requirements

This short video introduces financial functions that are similar to Excel’s financial functions. Several use cases are examined along with examples within SharePoint lists.

 

In this course you will learn more about the following topics:

 

· Basic Formula and Function Syntax

· An introduction to financial functions

· Understanding when to use a spreadsheet

· Reviewing the limitations of spreadsheets

· Knowing the guidelines

· Introducing financial requirements

· Introducing financial functions

· Examining 3 use cases

· The FV function

· The PV function

· The NPV function

· The PMT function

· The PPMT function

· The IPMT function

· Reviewing issues with financial functions

· Understanding correct usage

With nearly 10,000 training videos available for desktop applications, technical concepts, and business skills that comprise hundreds of courses, Intellezy has many of the videos and courses you and your workforce needs to stay relevant and take your skills to the next level. Our video content is engaging and offers assessments that can be used to test knowledge levels pre and/or post course. Our training content is also frequently refreshed to keep current with changes in the software. This ensures you and your employees get the most up-to-date information and techniques for success. And, because our video development is in-house, we can adapt quickly and create custom content for a more exclusive approach to software and computer system roll-outs.

 

 

 

Get Tutorial