Chandoo takes the Excel Expert Live Challenge

Next in the series of Excel Expert Live Challenges we have world renowned Chandoo!
The challenge: Identify the palindromes (ignoring spaces and punctuation)

This is a fascinating experience as Chandoo shows some Excel mastery and mixes it with real world decisions about what’s worth chasing down and what’s not. It opens an important discussion about when it’s ok to be lazy when the alternative is spending time over-engineering a solution.

0:00 Introduction
1:04 Opening the challenge
2:00 Thoughts about language: Telugu vs. English
6:26 He’s done a challenge like this before
7:39 A benefit of being a content creator
8:43 Starting the challenge
9:30 Start with an easy one
16:06 Removing spaces and punctuation
27:23 Real world vs. hypothetical spreadsheet world
27:55 VICTORY!
28:50 Real world project
30:53 Wrap-up discussion

For a list of my Excel courses at Lynda/LinkedIn:
https://www.linkedin.com/learning/instructors/oz-du-soleil
There are courses on Power Query, Good spreadsheet habits, and a weekly Excel challenge that comes out every Friday.

My book co-written with Mr. Excel, Bill Jelen: Guerrilla Data Analysis 3rd Edition
https://www.mrexcel.com/products/guerrilla-data-analysis-3rd-edition/
Website: https://ozdusoleil.com
My old blog: http://datascopic.net/blog-2-2