ExcelGuru Challenge #3: Parsing Text & Own Your Excel Style

Ken Puls of ExcelGuru presented a 3rd Excel Challenge and here’s my solution.

The challenge is to take a word, assign values to each letter and generate a total for each word.

A = 1
a = 1
.
.
Z = 26
z = 26

The word ‘Attitude’ gets 100 points.

As I started thinking about a solution I started thinking too hard about it. I wanted something more crafty or sophisticated, but then I realized that I saw a path toward success and that’s what mattered.

So, this video is really about understanding your strengths and style and not apologizing. My Excel style is akin to the style of Jerome Bettis, the former runningback for the Pittsburgh Steelers. He was big and powerful … also kinda slow and not elegant.

But what’s the bottom line? The bottom line is to get the job done–however you can responsibly get the job done.

The ExcelGuru Challenge No. 3 solutions are here:

Jerome Bettis Highlights

#ExcelChallenge
#PowerQuery
ExcelGuruChallenge

For an intro to Get & Transform (Power Query) try my Lynda/LinkedIn course:
https://www.linkedin.com/learning/instructors/oz-du-soleil?trk=insiders_28299411_learning
Download the workbook: http://datascopic.net/EGC3

Website: https://ozdusoleil.com

My book: Guerrilla Data Analysis 2nd Edition
http://www.amazon.com/Guerrilla-Analysis-Using-Microsoft-Excel/dp/1615470336
My old blog: http://datascopic.net/blog-2-2