Analytics & AI for Modern Excel
.tsv file in Excel Power QueryThis post will show you how to load .tsv (tab-separated values) files into Excel Power Query. To get started, place the below download file into your Downloads folder. Data source: …
Continue Reading about How to read from a .tsv file in Excel Power Query →
I love the "Modern Excel" suite of tools and wish more spreadsheet users would adopt them. But I can understand the slow adoption... it's confusing! For example, you may be interested to start using …
Continue Reading about What’s the difference between Get & Transform and Power Query in Excel? →
[Note: This guest post is from Aprajita Sharma at ExcelChamps.com. I am a friend of ExcelChamps co-founder, Puneet, and look forward to learning from Aprajita as well. Today she shares how to perform …
Continue Reading about Guest Post: Three Things You’ll Love Doing in Power Query →
