Microsoft Excel Advanced Course 309 – Goal Seek, Data Consolidation, Solver and Macros

Description

• Find out how much you can afford to pay for a house using goal seek and financial functions,
• Consolidate the information from several sheets,
• Understanding the grouping of data,
• Use solver to explore possible outcomes depending on input variables.
• Understand how to forecast future income
• Internal rate of return
• Net present value and other financial functions
• Reasons to use macros
• Creating, editing a macro
• Creating a button for a macro

Case Studies included in this workbook:

The Granny Flat investment spreadsheet will take you through the various costs involved in developing a granny flat in your backyard. It will clearly demonstrate the costs and enable you to forecast your future earnings and return on investment. Read more about Investing in a granny flat

Based on purchasing an investment property in Newcastle NSW we’ve created a number of spreadsheets to help students discover how much they can borrow, how to compare property investment options and make decisions to help them prepare financially for their life.