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) 國際標準時間
主題: 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"