Power Query – Pobieranie i przekształcanie

Discover an Excel course that will make your work with Excel:

• faster

• automated

• less tiring

See what you will find in this course

• 1. What is Power Query

• 2. Powe rQuery in your Excel

• 3. Import from files and folders

• 4. Import from the Internet

• 5. Import from databases (Mysql, SQL, etc)

• 6. Data processing

• 7. Introduction to the M language

And much more, see the table of contents for over 4 hours of material 34 lessons and 6 tricks!

Get feedback about the course

I 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.

• M language - thanks to it you can easily share the "import code" with friends or colleagues