All the software mentioned below are available free of cost and there are no restriction of any features except for Tableau. You can check their site for more details.
Power Query Training – Click here.
Use Coupon code – PQYT80 for discount if there are no promotion on Udemy.
You just need to download software from above links in local drive, install it and activate it to start using it.
To activate Power Query and Power Pivot in Excel 2010 / 2013 go to File > Options > Add-ins > COM Add-ins > check box for Power Query and Power Pivot > Click Ok.