课程详情
Power Query is a feature in Excel that allows you to quickly import data from multiple sources and easily clean, transform, and reshape it to suit your needs. Follow along with Excel MVP Oz du Soleil as he shows you how to use this powerful, time-saving tool. Oz demonstrates how to import, merge, rearrange, and clean data, as well as how to repeat the process with one click if the data changes. Discover how to split columns, unpivot data, and use joins to merge, segment, and compare datasets. Oz offers dozens of techniques and tips in this comprehensive training.
您将获得的技能
获取证书,展示成果
分享学到的内容,成为理想行业的达人,获取证书,展示您在课程中所学的知识。
领英学习
结业证书
-
在领英档案中的“资格认证”版块下展示
-
下载或打印为 PDF,与他人分享
-
以图片形式在线分享,展现您的技能
了解讲师
学员评价
-
Kartikeya Behl
Kartikeya Behl
MBA | Christ University Bangalore | EFA Intern @Deloitte USI
-
Riley Alden
Riley Alden
Military Veteran
-
Lesley Richardson CF
Lesley Richardson CF
BEd,GradCertPubPol,Churchill Fellow, Educator, Researcher, Policy and Project Manager
内容
课程内容
- 边学边练 1 个练习文件
- 知识测验 9 个测验
- 随时随地学习 可在平板电脑和手机上访问