1. Avenue to Jane's Data Processing tool (Power Query)

If you do not want to learn complex functions, if you do not want to learn more difficult VBA. But you want to do a good job of data disposal analysis. Well, come on! This course will be the best choice for you. Away from the complex, return to simple and intelligent.

Let's take a look at what power query does. Let's show them first.

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/83/5C/wKioL1dxRy2hFYCeAAFhbIJWicA077.png "title=" 4. Data source Workbook (Smart extract Rollup for workbook data under a specified folder). png "alt=" Wkiol1dxry2hfyceaafhbijwica077.png "/>

650) this.width=650; "src=" Http://s2.51cto.com/wyfs02/M00/83/5D/wKiom1dxRy7T5slsAAJrZLdgcrc068.png "title=" 5. Data source Web page data (crawl Web data to make beautiful charts). png "alt=" Wkiom1dxry7t5slsaajrzldgcrc068.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/83/5D/wKiom1dxRy6zt36KAACceazKYXk871.png "title=" 6. ODBC of data sources (combination of SQL and PQ Technology). png "alt=" Wkiom1dxry6zt36kaacceazkyxk871.png "/>

650) this.width=650; "src=" Http://s4.51cto.com/wyfs02/M01/83/5C/wKioL1dxRy_SgOdUAAExe_xMN9U795.png "title=" 7. The magical work of the table head and the first line (intelligent wage strip making). png "alt=" Wkiol1dxry_sgoduaaexe_xmn9u795.png "/>

This article is from the "Vaufesse Training" blog, so be sure to keep this source http://ofeisi.blog.51cto.com/9291278/1793467

1. Avenue to Jane's Data Processing tool (Power Query)