★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/'>https://exceloffthegrid.com/academy'>https://exceloffthegrid.com/'>https://exceloffthegrid.com/academy

★ Get the example file ★
Sign up for our free Insiders program and get the example file:
https://exceloffthegrid.com/'>https://exceloffthegrid.com/insiders...
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) nonstandard calendar dates.

INCLUDES:
0:00 Introduction
0:27 Basic calendar table
3:28 Dynamic dates
4:33 Financial periods
6:22 Nonstandard calendars
8:19 Wrapup

★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/'>https://exceloffthegrid.com/

★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter:   / exceloffthegrid  

#MsExcel