Gross Profit - Calculated and explained using Excel

Опубликовано: 25 Февраль 2026
на канале: Mr.SpreadSheet
8,439
79

Hello and WELCOME to the Mr.SpreadSheet YouTube Channel.

In this video we examine and incorporate the Gross Profit metric into our design work.

Gross Profit is one of the KEY performance indicators for all businesses, so, it is essential that we include this as a vital component in our Basic Bookkeeping Spreadsheet.

This is the 5th Video in our Basic Bookkeeping Spreadsheet series and together with the Gross Profit metric, we also use Excels VLOOKUP function and we use IF Statements.

We hope that you enjoy watching.

The eight videos in this series can all be found in our Basic Bookkeeping Spreadsheet Playlist.

This resource is available Free of Charge enabling you to work through the various design stages at your own pace.

The eight videos comprise:

1. Bookkeeping Basics
2. Cash Accounting
3. Chart of Accounts
4. Bank Balances
5. Gross Profit
6. Error Handling
7. Income Statement
8. The Final Spreadsheet Template

As usual we are offering viewers a FREE copy of the completed template.

Details on how to get this are shown during the course of the video presentation.

We hope you enjoy watching.

.............................................................................................................................

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


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

Our Social channels:-

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

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