|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/power-query/
课程评论：没有评论
**Coursera 课程总结：Power Query - 数据获取与转换** 本课程是针对 Excel 用户设计的，旨在帮助您**提升工作效率、实现自动化，并减少繁琐操作**。 **课程亮点：** * **Power Query 基础：** 深入了解 Power Query 是什么，以及它如何在 Excel 中应用。 * **多元数据导入：** 学习从各种来源导入数据，包括文件、文件夹、互联网，甚至是数据库（如 MySQL、SQL）。 * **强大的数据处理：** 掌握数据转换的强大功能，包括数据操控、函数应用、格式更改等。 * **M 语言入门：** 了解 M 语言，方便您与同事或朋友分享数据导入的代码。 **课程内容涵盖：** * Power Query 详解 * Excel 中的 Power Query 应用 * 从文件和文件夹导入数据 * 从互联网导入数据 * 从数据库（MySQL, SQL 等）导入数据 * 数据处理技巧 * M 语言入门 **课程特色：** * **超过 4 小时的内容**，包含 34 个课时和 6 个实用技巧。 * 讲师拥有 **10 多年**的 Poland 培训经验，深刻理解 Excel 用户在工作中浪费时间的问题。 * 课程开发历时 **3 个月**，旨在帮助您显著**加速 Excel 工作流程**，投资回报率高。 * 讲师强调 **自动化** 的重要性，并介绍 Power Query 等新工具，如宏和邮件合并。 本课程将帮助您告别低效的 Excel 操作，掌握现代化的数据处理技能。
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.M language - thanks to it you can easily share the "import code" with friends or colleagues
