Beyond the Basics: Power Query Tricks for Modellers

By popular demand, we’re hearing from Excel and PowerBI YouTuber, Chandeep Chhabra. If you need to get data to build your models, Power Query has become an essential tool, but most modellers barely scratch the surface. Chandeep will be demonstrating his very best Power Query tricks for financial modellers! ★ Follow Chandeep Chhabra on LinkedIn ►   / chandeepchhabra   ★ Follow Chandeep Chhabra on YouTube ►   / @goodlychandeep   ★ Follow Danielle Stein Fairhurst on LinkedIn ►  / daniellesteinfairhurst   ★ Register for another Virtual Meetup ► https://plumsolutions.com.au/meetup/

Join Today
I don't use VLOOKUP or XLOOKUP in Excel anymore, I do this instead
▶︎

I don't use VLOOKUP or XLOOKUP in Excel anymore, I do this instead

Review your model: self-checking tips and tricks
▶︎

Review your model: self-checking tips and tricks

How to use Microsoft Power Query
▶︎

How to use Microsoft Power Query

RFM Analysis in Power BI: Segment Customers Like a Pro
▶︎

RFM Analysis in Power BI: Segment Customers Like a Pro

Power Query Secrets - Simple tweaks is all it takes.
▶︎

Power Query Secrets - Simple tweaks is all it takes.

Use Excel Like a PRO | Learn Power Query, Power Pivot & DAX in 15 MINUTES (project files included!)
▶︎

Use Excel Like a PRO | Learn Power Query, Power Pivot & DAX in 15 MINUTES (project files included!)

Power BI DAX Tutorial for Beginners (2025): Master DAX in ONE Course!
▶︎

Power BI DAX Tutorial for Beginners (2025): Master DAX in ONE Course!

The New Power BI Authoring Skills Change Everything
▶︎

The New Power BI Authoring Skills Change Everything

Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)
▶︎

Database Normalization for Beginners | How to Normalize Data w/ Power Query (full tutorial!)

Power Query Masterclass for Power BI | Complete 2 Hour Tutorial
▶︎

Power Query Masterclass for Power BI | Complete 2 Hour Tutorial

CHOSEN ONE!! THEY'RE BEGGING HIM TO WARN YOU... BUT HE JUST GRINNED AND SAID "TOO LATE"
▶︎

CHOSEN ONE!! THEY'RE BEGGING HIM TO WARN YOU... BUT HE JUST GRINNED AND SAID "TOO LATE"

The Excel Pagination Trick That Makes Reports Unlimited
▶︎

The Excel Pagination Trick That Makes Reports Unlimited

Data Modeling for Power BI [Full Course] 📊
▶︎

Data Modeling for Power BI [Full Course] 📊

Google & AWS Veteran: What Top Tier Software Architects Do Differently
▶︎

Google & AWS Veteran: What Top Tier Software Architects Do Differently

This Chinese Phone Company Is Quietly Killing Apple
▶︎

This Chinese Phone Company Is Quietly Killing Apple

Master Yourself | Brian Tracy | The Power of Self-Control and Discipline
▶︎

Master Yourself | Brian Tracy | The Power of Self-Control and Discipline

Excel vs Power BI vs SQL vs Python | Grouping 37,000 Marathon Finish Times
▶︎

Excel vs Power BI vs SQL vs Python | Grouping 37,000 Marathon Finish Times

Excel vs Power BI vs SQL vs Python | Restaurant Price History Lookup
▶︎

Excel vs Power BI vs SQL vs Python | Restaurant Price History Lookup

Excel Power Query Course: Power Query Tutorial for Beginners
▶︎

Excel Power Query Course: Power Query Tutorial for Beginners

13 Mind Blowing Power Query Features to Automate Your Excel Work (Beginners Tutorial Part II)
▶︎

13 Mind Blowing Power Query Features to Automate Your Excel Work (Beginners Tutorial Part II)