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.

Here are the links to the various Mr.SpreadSheet resources available to you.
Please help support our channel by subscribing.
Many thanks

Free Cash Book Spreadsheet Template - https://www.MrSpreadsheet.com/product...

You can also visit our websites at:

USA & Canada & World - https://www.MrSpreadSheet.com
UK & Europe - https://www.MrSpreadSheet.co.uk

Or our Social channels:

FaceBook -   / mrspreadsheets  
Instagram -   / mrspreadsheet  
Twitter -   / mr_spreadsheet  

#MrSpreadSheet #Excel #spreadsheet #exceltutorial #msexcel #Accounting