Import data from text files, other Excel files, databases, web pages, Facebook, even entire folders of files using Power Query.Excel is the most accessible program for data analysis. Power Query (also known as Get & Transform) takes that one step further. The first step of any data analysis project is importing the data. Related to that, you must clean and standardize the data (aka ETL: Extract, Transform and Load)Power Query has all...