Miscellaneous lessons from the Expert Skills course. - 09-06 Use Excel CheckBox values in formulas without VBA

The Excel CheckBox form control enables you to create elegant interactive Excel worksheets. You can use the CheckBox selection within Excel formulas without using any VBA code. In this lesson you'll create formulas that update worksheet values based upon CheckBox selections. As with all video lessons from The Smart Method®, there's a sample file download link at the beginning of the video to enable you to work along with the lesson. You may, however, get more from this lesson if you first work through lessons 09-01, 09-02, 09-03, 09-04 and 09-05. These are the lessons where best-practice techniques was used to add the controls and functionality you see to the sample file workbook. ⌚ Timestamps 0:00​ Sample file download instructions, download link, and discussion of sample file. 0:54 Discuss formula that is calculating the monthly payment (using PMT function). 1:20 PMT function's FV argument (future value) explained. 2:40 Use an IF function for the FV argument to make the Interest Only checkbox work. 4:37 Test the form to confirm that it is working correctly. 5:10 Correct the Total Interest Paid result cell so that it also works for interest only loans. 7:00 Test the form to confirm that Total Interest Paid is being calculated correctly. 7:40 Test information to enable you to confirm that your worksheet is working correctly. 9:35 Link to next lesson, course session playlist and to download sample file set.