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.
(more…)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 books. He has included ratings and notes of the books he has read. You can sort the list by Title, Newest or Best. Link to Sivers
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.
(more…)
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.
(more…)