Excel is my database, Python is my brain.

Excel is full of answers. They’re just not always easy to see. You open a spreadsheet and there it is: rows of numbers, dates, categories, totals. You know there’s something useful there. A trend. A ...

NOTE: This post was written before Data Explorer was renamed as Power Query. All of the content is still relevant to Power Query. One of the first questions I get asked after showing someone ...