From the course: Excel VBA: Managing Files and Data
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Calculate data using Excel worksheet functions - Microsoft Excel Tutorial
From the course: Excel VBA: Managing Files and Data
Calculate data using Excel worksheet functions
- [Instructor] Excel VBA is a powerful tool but you don't need to create all of your own calculations. Instead for the most part, you can call on existing worksheet functions that are available as part of the calculation engine that powers Excel. In this movie, I will show you how to call existing worksheet functions using Excel VBA. My sample file is 04_03 worksheet functions and that's a macro-enabled workbook you can find in the chapter four folder of your exercise files collection. We're going to be recreating the calculation that you see here in the workbook that I've displayed. We're calculating the monthly payment. And the given facts for this loan are that it has a 6% rate and the number of periods is 12. Let's assume that's 12 monthly payments over a year. And the amount of the loan or the present value is 18,000. In Excel you can use the PMT function to calculate the payment that will fully pay off the loan using…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.