跳到主要內容
擴音器圖示

GitHub Universe on the Road

GitHub Universe is going on the road. Find a stop near you and join the experience.

Power Query – The best Excel tool you don’t know about

5月 18, 2021 | 2:00 - 3:00 上午 (UTC) 國際標準時間

準備好開始使用 AI 和最新技術嗎? Microsoft Reactor 提供活動、訓練和社群資源,協助開發人員、企業家和初創公司建置 AI 技術等等。 加入我們!

Power Query – The best Excel tool you don’t know about

5月 18, 2021 | 2:00 - 3:00 上午 (UTC) 國際標準時間

準備好開始使用 AI 和最新技術嗎? Microsoft Reactor 提供活動、訓練和社群資源,協助開發人員、企業家和初創公司建置 AI 技術等等。 加入我們!

返回

Power Query – The best Excel tool you don’t know about

5月 18, 2021 | 2:00 - 3:00 上午 (UTC) 國際標準時間

  • 格式:
  • alt##Livestream線上直播

主題: DevSecOps 和開發人員工具

語言: 英文

Power Query was released for Microsoft Excel way back in 2013. In this session I cover the basics of Power Query and how it is used in Power BI before quickly moving on to demonstrate how you can use Power Query in Excel to solve everyday problems.
• Combining multiple data files together
• Using Power Query as an auditing and exception management tool
• Streamline the collection of (budget) data from across the organisation
• Importing data from a PDF into Excel
• Loading and refreshing data from a website

Bio:
Matt Allington is a career expert in BI and Excel, and has had more than 35 years’ experience in using data to deliver business value. Matt is a Microsoft MVP that specialises in Power BI, Power Query and Power Pivot for Excel. He combines his business and IT experience together to deliver training, consulting and general business data problem solving to clients worldwide. Matt is the author of the best-selling book "Supercharge Power BI - Power BI is Better When You Learn to Write DAX"

相關活動

下列活動也可能對您感興趣。 務必造訪我們的 Reactor 首頁 以查看所有可用的活動。

本頁面的一部分可能是機器翻譯或人工智能翻譯的.