this isthe firstof three in a video series about Power Query and Power Pivot. In my opinion, it is the right time to get to know Excel "outside the usual environment" and use its capabilities in the maximum version.

​

Excel Power Query and Power Pivot add power and power to Excel. It is an option:

• get data from external files, databases, web pages, etc. resources

• automate data processing processes

• work with large amounts of data

• perform dynamic calculations

• visualize data in Pivot Tables, creating unified information panels or Dashboards

• learn to analyze data like an expert!