Excel Magic Trick 1127

Automatically Track Budget Start, Change & Ending Balances In Excel

DESCRIPTION

See how to automate the tracking of and the Current and Ending Amounts for Budget Categories using The Excel Table feature, Data Validation drop-down list, the SUMIFS function, and Page Setup for printing.
(00:08) Overview
(01:11) The Excel Table feature
(02:29) Data Validation list
(09:28) SUMIFS function and Current Balance Formula
(15:27) Page Setup

WORKBOOKS