How to create a Cash Book in Excel - Step by Step Guide [2021]

Create your own Cash Book to record your business or personal bank and cash transactions.

This easy to use spreadsheet uses Excels superb TABLE Creator tool to create the basic template for you to record your financial data.

In the course of the tutorial I will use and demonstrate a simple IF Statement, I will introduce the VLOOKUP function for easy analysis and use the DSUM command to quantify totals.

The video is designed for you to 'follow' at an easy pace, and once completed you should have a very useful tool, and hopefully you will pick up a few tips on the use of some of Excels powerful commands.

Видео How to create a Cash Book in Excel - Step by Step Guide [2021] канала Mr.SpreadSheet