Tag Archives: kaggle

Dear Analyst #55: Using Google Translate to quickly translate text with Le Grand Débat National data

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. You basically don’t have to copy and paste into Google Translate anymore to get the […]

Dear Analyst #52: Extracting text from the middle of a cell using World Happiness data

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 Power Query vs. Excel formulas from Danielle […]

Dear Analyst #48: Working with numbers formatted as text with avocado sales

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 that straight up don’t work. This episode explores what happens when you unknowingly have numbers […]

Join our community of 5,000+ Excel and data analysis enthusiasts!

  • Learn Excel techniques and shortcuts
  • Episode updates from the Dear Analyst podcast about Excel
  • Updates on online and offline data workshops

Enter your e-mail and hit the blue button!