Excel Forum
Similar Content
Slicer Power Analysis in Excel - Pivot Tables + Pivot Charts + Tables + Slicers
Tutorial: Powerful Excel data visualization and analysis that uses a combination of techniques, whi...
Excel Data Validation - Limit What a User Can Enter into a Cell
Tutorial: Data Validation is a tool in Excel that you can use to limit what a user can enter into a...
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 510: Amortization Table That Changes When Year Input Is Changed


See how to create an Amortization table that can handle variable year inputs. See the functions: PMT, IF, and ROWS.





Got a Question? Ask it Here in the Forum.