Calculating Present Value in Excel 2016 скачать в хорошем качестве

Calculating Present Value in Excel 2016

Check out the full course at https://www.knowledgecity.com/en/libr.... Calculating the present value of your loan can be a snap as long as you know the annual rate, term of the loan, and the monthly payment that you want to make. The rate is the interest rate of the loan. The term of the loan (Nper) is how many payments per month, or more commonly, per year. The payment (pmt) is the combined monthly payment including the interest rate. This video will show you how easy it is to calculate present value in Excel 2016 Advanced. Course Lessons Welcome Introduction Overview Working with Functions Overview Using Statistical Functions Calculating Loan Payments Calculating Present Value Calculating Loan Payoff Calculating Interest Rate Calculating Principle & Interest Work with Logical Functions Work with Text Functions Work with Ranges Using Date and Time Functions Controlling Automatic Calculations Copying Formula Values IF, VLOOKUP, and Power Functions Overview Testing Conditions with IF Using IF functions with relational operators Using the IFS function Using VLOOKUP Getting approximate table data with VLOOKUP Getting exact table data with VLOOKUP Using INDEX/MATCH functions Using the COUNTIF family of functions Data Analysis Tools Overview Using Goal Seek Using Solver Using Scenario Manager Using data tables Data Management Features Overview Sorting data Using filters Splitting data into multiple columns Using Flash Fill Removing duplicate records Using validation tools Working with Lists Overview Query Data with Database Functions Outline and Subtotal Data Pivot Tables Overview Creating PivotTables Manipulating PivotTable data Grouping by date and time Grouping by other factors Using slicers to clarify and manipulate fields Using PivotCharts Introduction to Macros Overview Understanding and creating Macros Running and editing a macro Security and Sharing Overview Unlocking cells and protecting worksheets Protecting workbooks Assigning passwords to workbooks Sharing workbooks Tracking changes Conclusion https://www.knowledgecity.com | Online Employee Training Platform. KnowledgeCity offers 12,000+ online video tutorials in Business, Computer, Safety, Compliance, and Finance. Subscribe to our YouTube Channel: https://www.youtube.com/user/knowledg... Check our Blog: https://goo.gl/q47XKK Connect with KnowledgeCity! Twitter: https://goo.gl/wToC6s Facebook: https://goo.gl/3eMEq9 LinkedIn: https://goo.gl/vg1aXt Google+: https://goo.gl/Gjkffm