Excerpts from Range by David Epstein and financial modeling

Range: Why Generalists Triumph In A Specialized World by David Epstein came on my radar after listening to another podcast. Thought the premise was interesting in that people who “dabble” in various interests and hobbies end up excelling (no pun intended) in life and have a more rewarding career. I read a few excerpts that […]

Dear Analyst Episode 17: Excel introduces new feature XLOOKUP

New Excel feature alert! Probably one of the biggest announcements in a long time from the Excel world: a new function to supplant VLOOKUP and HLOOKUP. What is it you ask? The XLOOKUP function. Summary of XLOOKUP benefits I discuss some of the benefits, implications for new and existing users of Excel, and also some […]

Dear Analyst Episode 16: The New York Times’ data bootcamp

A few months ago, The New York Times’ Digital Transition team headed by Lindsey Cook published a blog post about a data bootcamp they led for their reporters and editors. The New York Times frequently publishes amazing data visualizations, and it’s awesome to see this newsroom pushing their reporters into the world of “data journalism.” […]

How Destiny’s Child put Excel on the map and syncing data between Coda docs

This is probably the most click-baity title for a blog post/podcast about Excel, but we don’t get many of these in the Excel world, right? It all started in 2002 with the Dilemma music video by Nelly featuring Kelly Rowland, and Kelly decided to send a text using Excel. The most important text in the […]

How to sync data using Google Apps Script in Google Sheets

In episode 12, I talked about how you can use the IMPORTRANGE() function in Google Sheets to import data form a source Google Sheet to a target Google Sheet. In this episode, I get a little more technical and discuss how you can import data using Google Apps Script. If you want to read the […]

How to import data from one Google Sheet to another

Have you ever wanted to share data from one Google Sheet with another Google Sheet? Maybe you are a freelancer and have multiple clients, and keep all the payment data in one Google Sheet but need to send updates to your clients without sharing all your clients’ data. In this scenario, setting up one individual […]

Should you ditch Microsoft Excel for Google Sheets?

Google Sheets or Microsoft Excel? An age-old question since Google Sheets came onto the scene in 2006. Many saw Google Sheets just as a copycat of Excel that lacked most of Excel’s features. Over the years, Google Sheets has caught up with Excel’s many features including the number of formulas, PivotTables, and even macros. To […]