This workshop is an introduction to Excel Power Query. The course will be extended to include data analysis, reporting, and presentation using Excel Tables, Pivot Tables and Pivot Charts. At the end of the workshop, participants will be able to use Power Query to extract data from various sources, perform required transformation, and summarize and present data in useful reports /dashboards. Participants will also be able to automate recurring and routine work, in addition, building on Power Query capabilities, they will be able to design their reports once, then refresh and update new data with a click of a button
Extract data from various sources using Power Query
Apply complicated data cleansing and transformation techniques using Power Query
Present the output on Excel Pivot Tables and Pivot Charts.
Design automated reports which can be updated automatically with a click of a button
Head of Internal Audit= Internal Audit Mangers= Internal auditors= Finance professionals.
