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)