Ditch the trial and error. See payment figures at a glance.
This video shows you how to build a reference table in Excel to show the mortgage repayment amounts based on 3 variables - the amount borrowed, the interest rate and the length of your loan. It uses absolute cell referencing and a couple of neat propagation tricks.
Add your questions and comments below. I read and respond to every comment personally.
And don't forget to subscribe and hit that bell to be the first to get notified when new videos are dropped.
USEFUL LINKS:
DOWNLOAD the demo spreadsheet
officemastery.com/example/mor...
SHARE this video:
• Build a Mortgage Refer...
SUBSCRIBE if you want to see more content like this
ru-vid.com...
HIRE JASON to fix your broken spreadsheets or to get private 1-on-1 Zoom coaching
trst.com.au/microsoft-trouble...
ABOUT THE PRESENTER:
Jason Morrell helps people of all levels to leverage the power of Microsoft Office. Delivering training since 2002, he loves to simplify the hard stuff and provide helpful, actionable advice that has been proven to slash hours from daily computer tasks. Jason lives with his wife and 4 kids on the beautiful Gold Coast in Queensland, Australia.
LET'S CONNECT!
officemastery.com (free training on the blog)
/ officemastery
/ jkmorrell
/ jasonmorrell
Have a fantastic day!
24 июн 2020
