Power Query – Pobieranie i przekształcanie

Discover an Excel course that will make your work with Excel:fasterautomatedless tiringSee what you will find in this course1. What is Power Query2. Powe rQuery in your Excel3. Import from files and folders4. Import from the Internet5. Import from databases (Mysql, SQL, etc)6. Data processing7. Introduction to the M languageAnd much more, see the table of contents for over 4 hours of material 34 lessons and 6 tricks!Get feedback about the courseI have been running training courses all over Poland for over 10 years. I've been to over 300 companies and only one thing has always terrified me: how employees at all levels waste their time working with Excel . Not knowing pivot tables, they do analyzes, try to solve the problem, knowing only one IF function, knowledge of tools from the time of early Excel 1997… And where are the macros? New solutions like Power Query? Automation of work in the form of mail merge? And tricks? Not to mention array formulas. This is why I developed this course. Thoughts, the plan and the course itself took three months to develop. Thanks to this, today you have the opportunity to buy knowledge that will significantly accelerate your work on Excel. The expense will pay off during the first day of work ... And what you will find in this course:Import - you will see how easy it is to import data from multiple sources. You can really import data from many sources, including Facebook….Transforming - this is the 'brain' of all PQ. You can easily manipulate data, use functions, change formats etc.

• Obsługa Power Query