How to keep a Sales Day Book with Analysis in Excel - [2021]

In this video we show you how to keep your Sales data in a Sales Day Book Excel template and then how to perform some useful Sales Analysis routines.

You can follow the Excel methodology throughout the tutorial and work at your own pace.

Our Sales Analysis spreadsheet includes sections on:
Sales Tax calculations
performing arithmetic data checks
using Excels ROUND() function
inserting filters and using the SUBTOTAL(9) routine
creating a customer list using the Data Validation tool
and using the SUMIF command to perform analysis at the customer level

As usual, if you would like a copy of the completed file, then please Subscribe to our channel or contact us on either Facebook, Instagram or Twitter.

Thank you for your attention.

Видео How to keep a Sales Day Book with Analysis in Excel - [2021] канала Mr.SpreadSheet