Get =FLEX(). On-demand data from any API in Excel and Google Sheets. 🚀

Chicago
Joined June 2014
Replying to @flexiodata
@flexiodata FYI, Flex.io was posted on @ProductHunt producthunt.com/posts/flex-i… — Invite your teammates to join as Makers 🙌
1
1
Thanks for featuring us @ProductHunt! Join the conversation here: producthunt.com/posts/flex-i…
I'm excited to announce that Dynamic Arrays is now generally available in the #Excel monthly channel.🚀 #SORT #UNIQUE #FILTER
6
22
8
66
Seven advanced features in @msexcel - including #xlookup & #dynamicarrays - nice write-up by @puneetism bit.ly/2pG3bnx
1
10
If you could get any data into @msexcel with a click, what would it be? Hot-off-the-press vid below showing how we're using #dynamicarrays to pull in data from web services like @Intercom and @FullContact - #NoCode required (but feel free). youtu.be/7EhPEBFmvQI
3
Flex.io retweeted
Dynamic Arrays becoming Generally Available this week, starting with Excel on the Web! sumproduct.com/news/article/… #Excel #arrays #MicrosoftIgnite2019
1
3
4
Flex.io retweeted
I've been interested in low-code and no-code so I did a little bit of writing about what I've learned: thisisacomputer.com/lab/arti… #nocode #lowcode
6
2
15
"[One hedge fund shows each new developer a particular @msexcel spreadsheet that makes $100M+ per year as part of orientation... to remove hubris]" A fun, informative read comparing enterprise financial #dataviz with #datajournalism @tophtucker bit.ly/2MoaVBL
1
A great primer on statistical fallacies including real-world examples -- Common Data Mistakes to Avoid @geckoboard bit.ly/31Utnsv
1
Nice look at the history and utility of different types of databases: Comparing Database Types -- How Database Types Evolved to Meet Different Needs @jmellingwood bit.ly/2OCtFAv
Fun read - #AI learns to play hide-and-seek; develops lots of clever strategies and counter-strategies. How about a nice game of chess? bit.ly/31FDgdq #MachineLearning @KelseyTuoc
Microsoft #Excel is doing some really slick things with their calculation engine. Check out this tutorial on the brand new #XLOOKUP Function (available in 365 Insiders channel) @msexcel @howtogeek bit.ly/2QsA0Rc
1
1
1
16
Build super quick @msexcel and @googlesheets lookups from remote files and share auto-documented functions with your team; no coding needed (unless, of course, you want to). #dynamicarrays
1
1
HOLY XLOOKUP: Because the new XLOOKUP returns a range, not a value like VLOOKUP, you can say "Sum all lookups from Cherry to Kiwi". =SUM(XLOOKUP(D4,A2:A19,B2:B19):XLOOKUP(D6,A2:A19,B2:B19)) #BadAss #Excel mrexcel.com/excel-tips/the-v…
11
79
17
257
I’m excited to announce XLOOKUP -- the successor to VLOOKUP, the most iconic spreadsheet function of all time. techcommunity.microsoft.com/…
32
416
314
1,140
Dynamic Arrays for #Excel @Office365 is a game-changer that *should* be available to the public soon (but, apparently, not in today's release ☹️). Great primer here nonetheless via @DTomoffCPA bit.ly/2MtLsc1
1
2
How hard can it be? Why it took 4 years to build that tiny link preview on @Wikipedia bit.ly/2Lg2sSJ
1
1
Execute a custom #Python function against an #OAuth service in about a minute. flex.io/ #serverless #faas
1
4
Quick serverless tutorial -- Building a twitterbot using @aws and #lambda bit.ly/2uH1fK1
1
1
The seven steps to getting traction for an internal data product. bit.ly/2pv7aiw #DataScience
1
2