Yes, most of the above and much more can be achieved in Microsoft Excel if you understand some basic concepts of budgets and budgeting.
This book was written to help any users wanting to have a clear understanding of how Excel can help to perform some aspects of budgeting using some of its built-in financial and logical functions. It starts off by explaining the concepts of budget and budgeting, moving on to variances in budgets, budgeting process, why budgets fail, limitations and characteristics of budgeting, cash budget, static budget, flexible budget and finally, how to prepare a master budget.
Many books have been written on budgets but this book focuses on the use of Excel in budgeting. It explains the more important facts on master budgets and flexible budgeting. Anyone new to budgets or budgeting will find this book handy.