Cat retweeted
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
Cat retweeted
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
Cat retweeted
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! 😊👩💻
Cat retweeted
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…
Cat retweeted
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
Cat retweeted
Elegant no-code solution.
Create an #Excel hyperlink that takes you to the next empty cell for data entry.
contexturesblog.com/archives…
Cat retweeted
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!
Cat retweeted
Just head from the #Excel team that the new XLOOKUP() function is now available to all #Office365 users on the Monthly channel. Fantastic news!
Cat retweeted
Replying to @HydrxFids @matloff
Excel now supports JSON natively, even :-)
Data -> Get Data -> From File -> From JSON
Cat retweeted
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
Cat retweeted
Excel for iPhone now lets you take a picture of a spreadsheet and import it theverge.com/2019/5/29/18644…
Cat retweeted
Lots and lots of confetti is #HowWeExcel-ebrate on #SpreadsheetDay! Why do you love Excel? Share below!
Cat retweeted
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…
Cat retweeted
Today at #MSIgnite we announced #Excel dynamic arrays. Dynamic arrays will change the way we build and think about spreadsheets. Combine it with the new SORT, UNIQUE & FILTER functions to supercharge your spreadsheets! microsoft.com/en-us/microsof…
Cat retweeted
Converting Dates to Quarters for Usual or Custom Fiscal Year using #Excel #PowerQuery
https://nitter.gq/t.co/vMeYSiTVVL
Cat retweeted
New #PowerQuery updates released today, including enhancements to Add Column From Examples, Always Use Connection File feature and various connector updates: https://nitter.gq/t.co/K7X4mfiyAs
Cat retweeted
#Excel Podcast episode No.8: Inside The Microsoft Excel Offices With John Campbell
myexcelonline.com/podcast/00…

























