Tag Archives: jason calacanis

Dear Analyst Episode 24: Finding and ranking percentiles

I discuss how to calculate percentiles in Excel or Google Sheets using the PERCENTILE function. With the PERCENTILE function, you can calculate the value that would represent nth percentile in your list of values. This is not exactly the calculation I was looking for. Instead, what if you wanted to know what the rank percentile […]

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 […]

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!