How to use a Pivot Table to view Accounts?
Channel: Computer Tutoring
Date: 2021-03-22

How to use a Pivot Table to view accounts in Excel? You may have asked: "Can I use a Pivot Table to display accounts?" Or want to know how to easily view monthly received and expenses in Excel. This tutorial will show you how. 

To follow along you are welcome to download the exercise file at the following site: https://www.computertutoring.co.uk/excel-tutorials/accounts-excel/pivot-tables-for-beginners/

00:00 - Start
00:36 - Download "How to use Pivot Tables to display Accounts" file.
00:56 - Know how to create tables in Excel
01:49 - Why give your table a name in Excel?
02:29 - Do tables speed up your data in Excel?
02:49 - Use Tables to create Pivot Tables
03:31 - How to easily view monthly received and expenses in Excel?
05:09 - Easily see a summary of expenses in Excel
06:09 - Pivot Table filter less than
06:50 - Change the currency format of Pivot Tables
07:52 - How to filter two Pivot Tables at the same time?
09:35 - Select multiple values in a Slicer

Other Excel Accounts Tutorials:

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


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