Excel Off The Grid

@DamoBird365 is one of my favourite Power Automate creators on YouTube. It is definitely worth subscribing to his channel. @DamoBird365" target="_blank" rel="nofollow noopener">youtube.com/@DamoBird365

@wynhopkins @Guernicus @jkpieterse @Guernicus - I’ve got some other Office Script resources here: exceloffthegrid.com/category/offic… But you’re right, a lot of the TypeScript functionality is not supported or not relevant for Office Scripts.

Anybody got good resources for doing deeper dives into Office Scripts? The MS pages aren't very helpful and going straight to TypeScript tutorials seems incomplete (missing the office object model) and potentially irrelevant (things unsupported in office). @wynhopkins ?

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

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

@VicmoExcel @celia_excel @AhmedOyelowo @OzExcel @wynhopkins @ObboatB Until a larger population are using XLOOKUP then it doesn't help much. VLOOKUP shows a basic understanding of relationships. PivotTables shows a basic understanding of needing structured data. If I get somebody who says... "I use XLOOKUP", that is always a good sign.

@exceloffthegrid @celia_excel @AhmedOyelowo @OzExcel @wynhopkins @ObboatB @exceloffthegrid : Looks like for M365, we may have to re-jig your list. VLOOKUP to XLOOKUP, SUMPRODUCT to SUM 😁 But yes, that does touch on some core functions and features

Do we trainers still ask people to rate themselves in Excel before commencing training? Just want to hear your thoughts and "interesting" responses you have received to this question before I retire it!! @AhmedOyelowo @OzExcel @wynhopkins @ObboatB @celia_excel @exceloffthegrid

@ruralwai @VicmoExcel @celia_excel @AhmedOyelowo @OzExcel @wynhopkins @ObboatB That is a typical trend - starts high and gets lower. If the pattern starts low and stays low; then maybe Power Query isn't the right course at the current time. So, it's good to see that @ruralwai is already a PQ master.

@VicmoExcel @celia_excel @AhmedOyelowo @OzExcel @wynhopkins @ObboatB I ask people to rate on the following: - VLOOKUP - PivotTables - Charts - SUMPRODUCT - VBA I’m primarily teaching Power Query. So, I’m really trying to assess who will struggle with the basic concepts.

@celia_excel @AhmedOyelowo @OzExcel @wynhopkins @ObboatB @exceloffthegrid That's absolutely right. I guess our task would also be to help guide those expectations in cases where they may not be aware what skills would exactly take them to the next level. Can't help but reference VLOOKUP, where people think it's the only function to know for mastery.

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

@kirstywilcox2 @ONS Good work. 👍

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

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

@Crisp_EXCEL @automation254 @themissexcel @VicmoExcel @ExcelMaestro @wynhopkins Safe to say I have never used it. Everyday is a school day.

When was the last time you used GESTEP Function? For what purpose? When is it necessary to use it? This is a rare function for me...seeking insights? @automation254 @themissexcel @VicmoExcel @exceloffthegrid @ExcelMaestro @wynhopkins #excel #programming

@mattbdevaney I’m hoping for at least Power Query in Excel Online. Then using the Office Scripts connector we can get the data back out to Power Automate.

Wouldn't it be great if we could use #PowerQuery in a #PowerAutomate flow for data prep? It would be better than using flow actions to transform data. And then all data need not live in #Dataverse.

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

@gjmount Based on this, I think we need to go through every Wikipedia page and start making up dates.

Narrator: "He isn't."

@gjmount The most disappointing thing about this is that the author accepted the answer from Chat-GPT about creating a PivotTable from multiple sources, but it’s wrong, it doesn’t create a PivotTable.

Using ChatGPT with Excel - Journal of Accountancy journalofaccountancy.com/news/2023/jan/…

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

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

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.

How to fix the Formula.Firewall error in #PowerQuery (2 ways) via @exceloffthegrid buff.ly/3RtPCQg