How to work out how much money my business made last month in Excel? Along with how can I work out how much I spent on something in Excel? With how do I work out how much money I made in a quarter? Are 3 questions that we answer in this 5th in the series easy accounts tutorial using Excel.
Download the starting exercise file (https://www.computertutoring.co.uk/ex...) and follow along so that you fully understand all the different tools you can use in Excel to create this amazing spreadsheet in which you can summarize your accounts.
You will see how to apply filters in Excel sheet by adding the little triangles at the top in Excel. Armed with this knowledge you will see how to select only certain customers in Excel. Or if you want to only view customers that have spent over a certain amount in Excel, knowing how to add the little arrows at the top in Excel will let you do this.
Say you want to know how to add multiple filters in Excel then this tutorial is for you and of course you will see how to clear more than one filter at the same time in Excel.

Timings
00:00 Intro
00:28 Beginning and download exercise file
01:50 How to apply filters in Excel sheet (Little Arrows at the top)
02:20 Select only certain customers in Excel
02:51 Only view customers that have spent over a certain amount in Excel
03:40 How to add multiple filters in Excel
04:35 How to clear more than one filter at the same time in Excel
04:58 How to work out how much money my business made last month in Excel
08:54 How do I work out how much money I made in a quarter
09:47 Summary and next Excel tutorial

So by using the SUBTOTAL function in Excel, you know how to add totals so that they change when data is filtered. You can use this knowledge to answer the how to work out how much I spent on something in Excel as well as the how do I work out how much money I made in a quarter questions.

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 i...  
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...  
Part 5 – Work out how much money my business made last month:    • How to Work Out How Much Money my Bus...  
Part 6 How to use a Pivot Table to display accounts?:    • How to use a Pivot Table to view Acco...  

#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/