February 18

What Makes a Great Analyst? – Excel Gurus Discuss


How Do You Solve Problems?

What are the intangibles?


Learning a foreign language?

Being a retired football coach?

In short, what makes you a problem solver?  What gives you the skills necessary to analyze a problem regardless of the tool?

Kevin’s Superbowl video –>2015-02-17_22-25-25

Our special guest was Kevin Lehrbass of MySpreadsheetLab.com.

In the video, you will hear several references to one of Kevin’s videos where he discusses close Superbowl Games.  For our international audience, this is the championship of American professional football.  Its easy to just look at a final score to gauge a close game.

But does that really gauge “closeness“?

Kevin walks you through his thought process on how he identified “closeness”.  This is critical, as its an analytical problem solving skill most people don’t use.

So How Does an Analyst Think?

They ask questions.  They define problems.  They have the presence of mind of an analyst.  They have confidence in themselves.  They never stop thinking about how to solve a problem.

Its not just about Excel.  Its not just about a tool.

The Grammar Book?

So this was out of left field for me.  How does a grammar book make me a better analyst?

But Kevin explains how the breaking down of language is an analytical exercise.  Then I was reminded of some graduate school entrance exams I took at one point when I was going to try to be smart for a living.  And guess what?  Several of the questions in a law school entrance exam were related to you attempting to figure out an unknown language (sentence, etc) based on a ton of unknowns.  Basically, its logic.  Also found in many IQ exams.  Interesting.

So Where Does This Leave Us?

Watch the entire discussion to find out.

What do you think makes a great analyst?

Leave your comments below.


You may also like

February 17, 2022

Edit Excel Formulas in WORD – Spreadsheet Tips and Tricks

February 8, 2021

51: Oz du Soleil & the Global Excel Summit 2021

January 29, 2021

Global Excel Summit 2021

January 22, 2021

50: Randy Austin – Excel for Freelancers

January 8, 2021

49: Theresa Estrada – Microsoft Principal Program Manager Lead

May 26, 2020

All Excel LOOKUPs Explained
{"email":"Email address invalid","url":"Website address invalid","required":"Required field missing"}

Free Power User Quick Guide

Discover The BEST Ways To Use Lookups And Conditional Calculations Quickly And Easily With This Reference Guide -- You Won’t Want This To Leave Your Side

With so many ways to use Excel, it can be difficult to memorize all of the key functions, calculations, and techniques you can employ to meet your goal: simply get the job done.