Excel Pivot Table: Multi Currency Sales Report (using Power Query)

Опубликовано: 22 Февраль 2017
на канале: ExactProBi

8,717

Today I will be showing you how to prepare a multi currency report using Power Query and Pivot Tables

Suppose you have sales and profit data in a pivot table with your home currencies as values, but you want to see equivalent values in other currencies as well. with my trick, you will be able to see your home currencies converted to various other currencies with exchange rate live from the web

To do this I will be using Power Query.

Warning: This is not a basic Power Query or Pivot table tutorial, you are expected to know how to work with Power Query and Pivot tables...

Links for Basics of Power Query
   • Introduction to Power Query
   • Excel 2013 Power BI Tools Part 2 - Ge...
   • Excel 2013 Power Query #02: Transform...

Link to the awesome Power Query Book http://a.co/h9BJSkh

Link to Download Power Query from MS Website https://www.microsoft.com/en-us/downl...

Link to my course on Udemy.com https://www.udemy.com/masterdepreciat...

Please leave a LIKE to the video, and share with your friends and colleagues who might find it useful

Also, subscribe to my channel for advanced excel/VBA tips and tricks

Cheers
=================================================================================
Subscribe to my Channel here http://bit.ly/SubToExAC
Like My Facebook Page here   / exaccounting