Excel, Accelerated: Track a two-way loan balance Time: 3:20 | Would you like to know how to track a balance of a loan whose balance switches between two parties? To learn how, watch the video and download the Excel template. Techniques: Force a table to have different formulas in a column, SUMIF Buy $4.99