Excel Power Query Tips and Techniques 预览

Excel Power Query Tips and Techniques

讲师: Oz du Soleil 1,795 位用户赞了
时长: 51 分钟 技能水平: 中级 发布日期: 2019/10/14

课程详情

Learn timesaving tips on using Power Query, also called Get & Transform, a data connection technology that simplifies gathering, connecting, combining, and refining data in Microsoft Excel and Power BI Desktop. Power Query is simple to use but can be especially powerful when you learn a few techniques. In this course, instructor Oz du Soleil demonstrates customizing your Excel environment, then dives into organizing your work. He offers strategies for working with queries including referencing, duplicating, and renaming queries. Finally, Oz shows how to approach tasks where Power Query works differently from Excel.

您将获得的技能

了解讲师

学员评价

4.8 分,最高 5 分

740 条评分
  • 5 星
    当前数据: 614 83%
  • 4 星
    当前数据: 101 14%
  • 3 星
    当前数据: 16 2%
  • 2 星
    当前数据: 5 1%
  • 1 星
    当前数据: 4 1%

内容

课程内容

  • 边学边练 2 个练习文件
  • 知识测验 3 个测验
  • 随时随地学习 可在平板电脑和手机上访问
  • 了解最新知识 继续教育单元

相似课程

下载课程

使用 iOS 或安卓版领英学习 APP,即可在移动设备上离线观看课程。