I wrote an article years ago explaining how to use a related table to handle financial years in Excel Pivot Tables. You can read the article here. If you only want the months in financial year order you can just add an extra column to your table.
Monthly Archives: January 2022
Good reading resource
If you are after a good book to read, this is a great resource with over 300 books listed, and ranked.
Derek Sivers has had an amazing life and I am a fan of his own books.
He has included ratings and notes of the books he has read.
You can sort the list by Title, Newest or Best.
Extracting Time from Date and Time in Excel
Another MOD function solution
I had a recent query regarding checking time in a column that had both date and time. There is an easy way to extract time from a date-time combination.
Excel Chart Label Line Break
When adding labels to a chart sometimes you need a line break. Well it is possible.
Handling Multiple Columns in Power Query
Choose Columns drop down
In general, you should reduce the number of columns you import via Power Query to the minimum you require. Here is a quick technique to make that a bit easier.