Power Query doesn't have any lookup functions. But this doesn't mean we can't get values from another table; the Power Query alternative is the merge transformation. Find out more here: youtu.be/9d2bICnGap8

It promises to be a fascinating debate! To view our full agenda, go to globalexcelsummit.com/agenda. #excel #microsoftexcel #globalexcelsummit

No matter what date format your source data has, Power Query gives us many options for converting it into a date we can use. Find out more here: youtu.be/K3MQBjgy_sY

Excel formulas not calculating correctly? See if one of the solutions in this video help: youtu.be/OCyiHRy9wfs

Absolute and relative references for Tables in Excel | Excel Off The Grid youtu.be/CdAdaApvFcM

How to make an Excel worksheet Very Hidden youtu.be/qfdlAmrNiQs

Group By in Power Query is a simple yet powerful transformation. Learn how to use it here: youtu.be/XVQLBksQXag

How to fix the Formula.Firewall error in #PowerQuery (2 ways) via Excel Off The Grid buff.ly/3RtPCQg

Interviewer: Can you write VBA Macros? Candidate #1: I’ve got a friend who can Candidate #2: I can use Chat-GPT Conclusion - these two are the same. It’s not your intelligence!!! Use Chat-GPT to improve your intelligence, not for proving you ignorance.

Use dynamic data labels to improve Excel charts: youtu.be/E9tJkC62iXA

We can't use wildcards directly inside the FILTER function... so what can we do? Say hello to the FILTER / ISNUMBER / SEARCH combination. youtu.be/tB-f7BuSZfI

We're running a free webinar to help more people start saving time with Power Query. Title: Getting started with Power Query When: Tuesday 28th February 5pm GMT Register here: exceloffthegrid.mykajabi.com/pl/2147627214

Power Query: Get data from SharePoint lists | Excel Off The Grid youtu.be/ZPe7wn91J9w

One button to rule them. 🪄 How to run any macro from one button. 🤯 youtu.be/I2zdhAHD_Ck

Power Query problem: How to get data from an Excel workbook when the sheet or Table names change. Find the solution here: youtu.be/7xIeBf4wwIE

In this special FP&A Today episode, Paul is joined by three Excel experts whom Microsoft has recognized as ⭐Most Valuable Professionals (MVPs)⭐ Catch the full episode at bit.ly/3EFQD2H #fpna #excel #exceltips #microsoftexcel

A lovely comment by Mark at Excel Off The Grid for chapter 1 of my #advancedexcelformulas book. Get your copy - amzn.to/3R0JInY #excel