In today's post, there is a nice Power Query trick to transform multiline record data into a table in Excel. I intend to use this trick quite soon on my next...
(Originally published here) The demo I will share with you today is something that I was itching to try for a while. Before I joined Microsoft and Excel team,...
In this walkthrough we will show step-by-step how to turn web traffic logs (W3C Extended Log File Format) into a powerful security analytics workbook. To watch...
I have updated the Calendar Template to include Categories and better calculation of recurring meetings. Note: This is no longer the official template...
This week we have announced on Office Blogs the release of 3 new Excel templates that harness advanced data analytics technologies in Excel 2016: Power Query...
This is my first blogpost on DataChant. My still-secret place to chant about data analytics. My name is Gil Raviv. I am a senior program manager in Microsoft...