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
Beacon FinTrain prioritizes excellence in every service, ensuring top-notch, reliable, and consistent outcomes that meet and exceed client expectations.
We focus on finance, offering expert knowledge and bespoke solutions that cater to the unique needs of finance professionals in the Middle East and Africa.
Time is money. We respect deadlines, delivering precise and timely results to help our clients stay ahead in the fast-paced financial world.
Beacon FinTrain is a guiding light in finance, providing insightful advice and support to navigate the complexities of financial markets and regulations.
We uphold the highest ethical standards, fostering trust and transparency in all our dealings to build lasting relationships with clients.
Adapting to the dynamic finance sector, we offer versatile services and solutions that align with the evolving needs of our clients.