Microsoft Excel - Power Query
COURSE DESCRIPTION
So you’ve impressed your coworkers with your encyclopedic memory of formulae, become a Pivot pro, and started working IF statements into regular conversation. Now what? We say, Power Query. In a world where data is king, you should know how to work with and understand it – and this tool helps you do just that.
In this Power Query online course Ken Puls has designed and built with a company
GoSkills, you will learn the BI (Business Intelligence) process of importing data, appending and merging tables, conditional logic, data transformation, and organization. The course starts with the basics of Power Query, and works its way up. This means that you’ll be a pro in no time, even if you’re a beginner with the tool.
...
Get a table from each Excel file in folder | speed up the process
I have now tested this with a directory containing more than 1,000 workbooks. When I create a list of contents with the command "Excel.Workbook",...
pinarello Today, 09:25 AM