How do I add DIFFERENT VAT rates into the same spreadsheet?
Channel: Computer Tutoring
Date: 2021-02-17

How do I add different VAT rates into the same spreadsheet? This Excel accounts tutorial will show you how to add predetermined figures in Excel. You will also see how to make a formula apply to a whole column in a spreadsheet. Finally you will see how to work out how much of an amount is VAT, in other words how do I know how much VAT I have paid on a product?

00:00 - Intro
00:35 - Download Excel VAT Formula spreadsheet. (To follow along).
01:00 - Insert column for the different VAT rates.
01:38 - How to add predetermined figures in Excel.
04:40 - How to work out how much of an amount is VAT?
05:16 - Net from Gross
05:40 - Make a formula apply to a whole column in a spreadsheet
07:14 - How do I know how much VAT I have paid on a product?
09:15 - SUM different VAT amounts
11:24 - Make a running total in Excel
13:35 - White and grey alternate rows

Want to follow along? You can download the starter and completed files from:
https://www.computertutoring.co.uk/excel-tutorials/accounts-excel/excel-vat-formula/

Excel Accounts Series:
Part 1 - Creating the Accounts Sheet: https://youtu.be/YKQSXSFaiC0
Part 2 – Making your accounts look good: https://youtu.be/qWkXvOdochA
Part 3 – Calculate VAT in Excel: https://youtu.be/PRpw-ZM4_Ww
Part 4 – Add different VAT rates into the same spreadsheet: https://youtu.be/dBocyTZH5CI
Part 5 – Work out how much money my business made last month: https://youtu.be/aPTmkV_Rl18
Part 6 - How to use a Pivot Table to display accounts?: https://youtu.be/ADKqUVY5Rjw

#computertutoring #supereasyaccounts


😊 Check out my website and social media to keep up to date - enjoy learning 😊

 📱 http://www.computertutoring.co.uk/ 📱

 📽 https://www.tiktok.com/@thecomptutor 📽

👨‍👩‍👧‍👦  https://www.facebook.com/ComputerTutoring.co.uk/ 👨‍👩‍👧‍👦

 🦉 https://twitter.com/CT_Tutoring 🦉

  📷https://www.instagram.com/computer_tutoring/ 📷

  📌https://www.pinterest.co.uk/CT_Training/ 📌