Excel Forum
Similar Content
Shade Every Other Row in Excel Quickly
Tutorial: How to shade every other row in Excel quickly without using the Table feature. This method...
Run a Macro when a User Does Something in the Workbook in Excel
Tutorial: How to run a macro when a user does something within the Workbook in Excel, such as openi...
Excel VBA Check if a Cell is in a Range
Tutorial: VBA that checks if a cell is in a range, named range, or any kind of range, in Excel. Sec...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



Excel Magic Trick 407: Amortization Table W Variable Rate


See how to create a Amortization Schedule / Table with a variable interest rate. See the PMT function, finance tricks and a cell range in a function that will shrink as we copy it down a column.
See the Shrinking range trick for functions.





Got a Question? Ask it Here in the Forum.