★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy
★ Get the example file ★
Sign up for our free Insiders program and get the example file:
https://exceloffthegrid.com/insiders-signup/
File Reference for this video: 0215 PQ Calendar Table.zip
★ About this video ★
Calendar tables are commonly used in Excel and Power BI. We can generate them using Power Query.
In this video we create a basic table, then take it too the next level with (a) dynamic dates (b) financial periods (c) non-standard calendar dates.
INCLUDES:
0:00 Introduction
0:27 Basic calendar table
3:28 Dynamic dates
4:33 Financial periods
6:22 Non-standard calendars
8:19 Wrap-up
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: https://twitter.com/exceloffthegrid
#MsExcel