One of the best feelings is knowing you've streamlined and automated a report such that your colleague doesn't have to spend hours creating the report every week. Whether you automate the report through a bunch of Excel formulas or setting up some sort...

In this episode, I had the pleasure of speaking with John Napoleon-Kuofie, a senior business intelligence analyst at Farfetch. In this conversation, we talked about how John's career led him to Farfetch, a traffic dashboard he's built for his stakehold...

This is a super simple formula in Google Sheets, and I don't want to understate its utility. You can literally translate text from any language into another language. This formula came out on Google Sheets in early 2019 I believe.

With the last episode for 2020, I wanted to take a look back and pull out some of the main themes and topics from the podcast. As people rushed to pick up new data skills to adapt to our changing environment this year,

When I worked in FP&A, I discovered that VBA could automate a lot of tedious tasks I was doing in Excel. From creating charts to formatting data, I realized that there possibilities with VBA were endless. As I started using Google Sheets more,

Sometimes you have a long list of data in a column and you want to pull out a specific string of characters in the cell and put the output in another column. I've done this countless times and was reminded of this task after watching this meetup on Pow...

To much fanfare, custom data types in Excel were released late last month (October 2020). This feature started off as a way to see "rich data" relating to stocks and geography in a cell, and now Microsoft is letting you define your own data types.

This little podcast/newsletter started as a little experiment last year. I never thought I would make it to episode number 50, but here we are! Thank you to the few of you out there who listen/read my ramblings about spreadsheets.

I've been posting quite a few episodes about spreadsheet errors as of late. The two Harvard professors and their faulty economic policies, the JPMorgan whale trader, and the EuSpRIG community who tries to catch all these errors.

For spreadsheet newbies, number formatting may seem like a pretty innocuous matter. As you become more familiar with Excel or Google Sheets, you'll find that improper number formats will lead to formulas that don't output what you expect or formulas th...