Power Query’s Advanced Tools & Hidden Essential Tools

Power Query advanced options actually hide essential everyday tools. Stop avoiding menus like the Group By tool for multiple ...
note

I wanted to use kintone data in Excel, but it was surprisingly troublesome

kintone is easy and very convenient, but in actual work, there are times when you think, 'I want to quickly check kintone data in Excel' or 'I want to perform aggregation and processing in Excel.' Of ...

Excel’s Hidden N Function Lets You Add Comments Inside Formulas

Embed Excel formula comments directly into your math using the N and REPT functions to keep your spreadsheet documentation ...
MUO on MSN

I built my own Excel function without touching VBA, and now I use it daily

If you can write an Excel formula, you can build your own function.
GitHub

hadoop-file-system.md

Connect to Hadoop Files (HDFS) from Power Query Desktop Power Query desktop includes Excel and Power BI as experiences. To make the connection to Hadoop File (HDFS), follow these steps: From Get Data, ...
Microsoft

Data platforms and analytics

Garnet: an open-source, next-generation, faster cache-store for accelerating applications and services ...