As a business liaison for the Wyoming Commerce Department, Pedro Suarez works to attract businesses to the state of Wyoming. He is developing an Excel workbook that compares population, income, and education data in Wyoming counties to identify places he can promote to businesses wanting to expand their operations. He asks for your help

Shelly Cashman Excel $2019|$ Module $10$: End of Module Project $1$

in analyzing the data.

Go to the Education and Age worksheet, where Pedro wants to include educational information about Wyoming counties. He has another workbook that already contains this data. Use Power Query to connect to and import data from the

Support$\_$EX$19\_$EOM$10-1\_$Education.xIsx workbook. Transform the data in the Education table to remove the top two rows and the column containing state data. Use the first row as headers. Close and load the transformed data to a table in cell A$2$ of the existing worksheet.