Excel

Basic structured references for tables ( Link )

How to create absolute structured references ( Link )

Working with tables in Excel VBA: ( Link )

Power Query

Interesting Power Query Videos from TechEd Conference

• Using the Power Query interface

 

 

• Power Query formula language (M Programming)

 

Power Query Functions Reference: Link

Power Pivot

Power Pivot Frequently Asked Questions: Link

Reference of DAX Functions Link

Applications of the VALUES function: Link

New features in PowerPivot for Excel 2016: Link

Using SWITCH for several types of conditions: Link

Other resources

Learning how to learn – Google Talk (Dr. Barbara Oakley):

Download Power BI Desktop: Download Link