How to create a financial year in Excel? If you want to know how to generate a financial year in Excel or if you've wondered can I use a Pivot Table with a Financial Year then tutorial video is for you.
If you want to follow along you can download the exercise files at the following website:
https://www.computertutoring.co.uk/ex...

Chapters:
00:00 Start
00:31 Financial Year Template
01:10 Financial Year Formula
04:55 Pivot Table Financial Year
06:45 How Can I Create a Custom List in Excel?
08:20 How to Sort a Financial Year in Excel?
10:10 Financial Quarter Calculation
15:29 Next Excel Accounts Tutorial

Knowing how to analyse a financial year in Excel is a key skill. Of course it involves a Financial Year calculation but you also need other skills.
For example, once you have mastered how to calculate a financial year in Excel you will need to know how to create a custom list. Along with that, after you have created the Pivot Table, you will then need to sort by financial year or more importantly sorting by the months in a financial year.

The financial year formula used in the above tutorial is using April 1st as financial year. However, should the financial year in the country your living in start from April 6th, as it does in the UK? Then you can use the formula available from

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

Other Tutorials available in the following Excel Accounts playlist:
   • How to do Super Easy Accounts in Excel?  

Excel Accounts Quiz Test your Excel skills: https://www.computertutoring.co.uk/ex...

#computertutoring #supereasyaccounts

You know, an in person training course could be just what you need: https://www.computertutoring.co.uk/mi...

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/