Mastering Microsoft Power Query and Power Pivot

Take Your Excel Skills to the Next Level with Power Query and Power Pivot!

If you are ready to take your Excel skills to new heights and game to change the way you use Excel for data analysis, this course is for you. This course introduces Excel’s powerful data modeling and business intelligence tools: Power Query and Power Pivot.

Excel Power Query is one of the most powerful features and the easiest to learn & use within Microsoft Excel You can use Power Query to consolidate several files with the same format, clean & transform your data that you download from your company’s database system and display it in a report for Excel to work with. Power Query a great alternative to Excel VBA as it enables you to process your tables simply by clicking on buttons without coding, visualize the operations step by step without running a single macro and edit the steps order of different steps easily through dragging-and-dropping.

Excel Power Pivot is often associated with Power Query to ease data analysis and time-related calculations. Power Pivot enables you to analyse databases of several million lines by extracting aggregated information according to the rules set by your business. It is simply the next step of data transformation and it allows users to create data models from tables previously cleaned by Power Query.

This course is designed for learners who are proficient with PivotTable and PivotChart butt only has little experience or no experience in using Power Query and Power Pivot. 

This workshop aims to equip you with the skills to set Excel’s data modelling and business intelligence tools using Power Query and Power Pivot, learners will learn how to:

• Use Power Query to import and combine multiple files from a folder
• Use Merge Query to merge tables into One 
• Use Power Query to filter data and remove columns
• Use Power Pivot to import and create relationships between tables
• Create a calculated column with DAX functions 
• Create Measures and KPI
• Create Power PivotTables and Pivot Charts
• Add Slicer and Timeline to multiple charts

• Microsoft Excel 2016 / 365 / 2019 / 2021 users who do not have experience in using Power Query and Power Pivot.
• Learners must be proficient in using Excel Table, PivotTable and PivotChart.
• This intermediate-level course is NOT for beginners who only have basic knowledge in Excel and seldom use Excel program.

Note: This workshop is only for Windows version Microsoft Excel users. Learners are required to bring a laptop equipped with Windows version Microsoft Excel 2016/ 2019/ 365 version.

Click here to find out more on our Pivot Table for Microsoft Excel: Basic to Intermediate Workshop

“Trainer was patient in listening and explaining to all queries. The trainer provided a detailed explanation. The course will be helpful in data entry and formulating.” – Nicole Wong, Brainy Moves Pte Ltd

“Valene made learning Excel enjoyable. Lessons learned are commonly used at work.” – Chan Yoke Fan, Singapore Art Museum

“Trainer is very friendly and helpful. The course is very informative” – Muhd Abdul Hadi Mansor, Muslim Converts’ Association of Singapore

"Very knowledgeable and understand students abilities in comprehending the module"

"Very knowledgeable. Able to answer all the questions asked during class. Experience trainer."

Valene Ang is a Microsoft Certified Trainer and Master Instructor of Microsoft Office Specialist (MOS). She brings with her 20 years’ experience in corporate training and consultancy.

Valene has a broad experience in customizing Microsoft Office training programs, developing customized course outline and course material, assisting corporate clients in business data analysis and providing dynamic report solutions. She had conducted many Microsoft Office workshops in Singapore and Malaysia. Her training focuses on providing practical solutions to real life Excel problems.

As a Certified Trainer, Ms Ang has trained hundreds of executives, managers and directors from across medium sized organisations, government offices and multinational companies. Some of her high profile clients including PSA International, DFS Galleria Singapore, Neptune Orient Lines Limited (NOL), National Environment Agency (NEA), Inland Revenue Authority of Singapore (IRAS), CPF Board, Public Utility Board (PUB), Canadian High Commission, British High Commission, Temasek Polytechnic, Republic Polytechnic, Baxter Healthcare Pte. Ltd, and many more.