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”

#excel #power-query