RT @Computergaga1: A lovely comment by Mark at @exceloffthegrid for chapter 1 of my #advancedexcelformulas book. Get your copy - https://t.….

RT @datarails: In this special FP&A Today episode, Paul is joined by three Excel experts whom Microsoft has recognized as ⭐Most Valuable Pr….

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

One button to rule them. 🪄. How to run any macro from one button. 🤯.

Power Query: Get data from SharePoint lists | Excel Off The Grid.

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:

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

Use dynamic data labels to improve Excel charts:.

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.

RT @PSpreadsheets: How to fix the Formula.Firewall error in #PowerQuery (2 ways) via @exceloffthegrid. https://t.co/….

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

How to make an Excel worksheet Very Hidden.

Absolute and relative references for Tables in Excel | Excel Off The Grid.

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

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:.

RT @ExcelSummit: It promises to be a fascinating debate! . To view our full agenda, go to #excel #microsoftexcel….

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:

As I look ahead to the next 12 months, I’m incredibly excited about everything in the pipeline. Bring it on. 3/3.

Everything that I thought would happen didn’t. But things I couldn’t possibly have imagined did. I still remain committed to the original goal: Setting finance people free to do the jobs they were hired to do by automating the work they don’t need to do. 2/3.

Today is the one-year anniversary of setting out on my own. I had a plan and the ‘confidence of ignorance’… what could possibly go wrong?!?. Well… the plans quickly went out the window, leaving just confidence (or just ignorance, depending on how you look at it). 1/3.