Cat (@ExcelCat) header
Cat (@ExcelCat) profile picture

Excel enthusiast, slowly making the move from troubleshooter/magician to credible programmer.

Joined April 2010
Photo by Cat (@ExcelCat)Photo by Cat (@ExcelCat)Photo by Cat (@ExcelCat)
Join us on October 29 for the 'More new data types in Excel' LinkedIn Live event. We’ll share demos and show you how to transform organization data into rich data types in #Excel. Learn more: msft.it/6017TL3Jv
88
140
123
807
When I first heard that cases were missing I thought “can’t be an Excel problem, the rows run out at 1,048,576 which is bigger than even total cases”. I never thought they’d have a case per COLUMN. Unbelievable. And yes: Excel columns end at 16,384 aka “XFD”.
1
I see a lot of #Vlookup vs #IndexMatch ... I’m a fan of #Xlookup instead
1
2
It’s shameless self promotion time ! Read to find out a bit more about me and my role with @EnergiseLtd
This quoted post is unavailable.
Run Script with #Excel in #PowerAutomate https://nitter.gq/t.co/O89rlZYri2 by @PieterVeenstra
8
16
Nice!
I'm lovin' the new indicator icon in Power Query (#PowerBIDesktop) that alerts me to a note stored as part of an applied step. This gives me a lot more confidence to make notes against a step as I know I will find it again later when I need it. Great job @PowerQuery team
1
1
3
Ever needed to move one of your windows over to another monitor? WIN + Shift + Left/Right Arrow will do this for you without having to reach for your mouse, and it's our #FeatureOfTheWeek! 😊👩‍💻
7
56
19
269
FREE 10 HOUR EXCEL PIVOT TABLE COURSE! I have just released my comprehensive Pivot Table course with 230 video tutorials over at YouTube so you can finally get better at Excel and get the promotions & pay rises that YOU deserve... 👉youtube.com/watch?v=vA2NiYiG…
2
3
2
18
WOW! The #Excel team slipped the LET function into Insiders Fast yesterday!!! Finally - storing a variable inside an Excel formula. First look here: youtu.be/xSTBNta65ns
5
18
4
44
Elegant no-code solution.
Create an #Excel hyperlink that takes you to the next empty cell for data entry. contexturesblog.com/archives…
1
1
3
Delighted to have won :) Looking forward to meeting lots of others !
Replying to @ExcelSummit
...and we have a winner 🥳 Congratulations to Catherine Parkinson!
2
Replying to @wynhopkins
In Power Query, List.Contains works with query folding, so instead of having to do joins all the time, just Table.SelectRows(Table, each List.Contains(LookupList, [Column Name])). The list goes right into the T-SQL! Parameters, baby!
1
5
Just head from the #Excel team that the new XLOOKUP() function is now available to all #Office365 users on the Monthly channel. Fantastic news!
5
2
19
Replying to @HydrxFids @matloff
Excel now supports JSON natively, even :-) Data -> Get Data -> From File -> From JSON
2
7
21
Do you want to force #Excel to open every workbook in a new instance of Excel? File, Options, Advanced, General, Ignore Other Applications that Use DDE. #JustLearnedThis #BizarreName
3
9
1
38
Excel for iPhone now lets you take a picture of a spreadsheet and import it theverge.com/2019/5/29/18644…
32
407
148
1,520
Lots and lots of confetti is #HowWeExcel-ebrate on #SpreadsheetDay! Why do you love Excel? Share below!
44
112
40
385
Our #PowerQuery Recipe cards are now available! These handy reference cards lead you step-by-step through some of our favorite data transformation and techniques. Get yours today at powerquery.training/shop/pow…
3
8
I always get asked about training materials for #PowerBI... @chass has an awesome one stop shop for 90% of you here:
3
7
1
24