How do I add DIFFERENT VAT rates into the same spreadsheet?

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/ex...

Excel Accounts Series:
Part 1 - Creating the Accounts Sheet:    • How to do Super Easy Accounts in Excel?  
Part 2 – Making your accounts look good:    • How to Make Your Accounts Look Good in Excel?  
Part 3 – Calculate VAT in Excel:    • How to Calculate VAT in Excel?  
Part 4 – Add different VAT rates into the same spreadsheet:    • How do I add DIFFERENT VAT rates into the ...  
Part 5 – Work out how much money my business made last month:    • How to Work Out How Much Money my Business...  
Part 6 - How to use a Pivot Table to display accounts?:    • How to use a Pivot Table to view Accounts?  

#computertutoring #supereasyaccounts


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

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

📽   / thecomptutor   📽

👨‍👩‍👧‍👦   / computertutoring.co.uk   👨‍👩‍👧‍👦

🦉   / ct_tutoring   🦉

📷  / computer_tutoring   📷

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