Our new friend Kevin Lehrbass, the host at mySpreadsheetLab.com joins us from Toronto, Canada.
Kevin is the Team Leader of Analytic Help Desk team for a consulting firm. His team answers questions related to Excel and Access. As a result, tons of questions come into the help line asking all types of Excel questions.
In this interview Kevin discusses how problems are assessed, differing limitations of the Excel product, and how he got involved in Excel.
How Do You Solve Problems with Excel?
Learning a foreign language? Passion? Necessity? Being able to explain a concept clearly? What are the additional things that make you an effective problem solver?
Oz mentions a Superbowl Analysis video by Kevin. This begins an entire conversation on how “closeness” can be defined. See Kevin’s video here.
Do you have an analytical mind? if so, what does that mean? Do you need to have confidence in your own work? Technical skills are probably less important having confidence in your ability to answer. Ultimately, you should have both.
Where to find Kevin
- My Spreadsheet Lab Website
- Kevin on Facebook
- Kevin’s Youtube Channel – Lots of Tips
- Kevin on Facebook
- He is even on Twitter
- Google Plus
- And check him out on LinkedIN
Do you have something to share?
What do you think makes an analyst? What makes you think of a problem differently? Share it with us and we’ll read it allowed on a future episode. And don’t forget to subscribe to our mailing list to get Excel trips, tricks, updates, and news directly to your inbox. What could be better?
- The Comprehensive Guide to the Excel Ribbon: Making the Most of Your Data - January 31, 2023
- 51: Oz du Soleil & the Global Excel Summit 2021 - February 8, 2021
- 50: Randy Austin – Excel for Freelancers - January 22, 2021
When Designing complex worksheets for clients here are some points that i think are important:-
1) Being able to understand the problem, asking the right questions but i also thing building a understanding of the client how they think and operate, also good communications , i find more and more and information comes out every time i comunicate with them . There for building module by module.
2)People find in hard to take in lots of information at a time, therefore feed in small chunks.
3) planning skills and being flexible
Hey there, ExcelTV Gang!
You are all fantastic! Episode 23 was excellent as I’d anticipated it would be. Although it’s great to get Excel ‘how to’ tips it was also is exhilarating to listen to your individual personal life’s experiences with Excel over these past thirty years of Excel’s inception, per the question for this episode…’How many years has Excel been around?’. It’s was neat to hear about each of the host’s and the guest speaker Kevin Lehrbass from Canada’s, life’s experiences with Excel, e.g. not just how he uses it in his current career but how he came upon ‘Excel’ and the key moment or turning point where he was found himself ‘hooked’ on Excel. And, as always, over the past episodes of Excel TV, Rick Grantham does a superb job of orchestrating, hosting and keeping the momentum ‘alive’ throughout the entire broadcast.
I do have a very interesting true life story regarding a position that I worked up until about a week ago that was just like Kevin is doing that I’d like your personal opinion on. I would like to e-mail you (e.g. Rick and the group) so you could provide me you input and/or advice about the position that I happened to stumble upon on the Internet and found myself performing life, enqueue phone assistance to clients with Excel questions.
Your ExcelTV is AWESOME! Keep up the good work! I will try to spread the word to everyone I know who may utilize Excel in their career or otherwise and are just eager learn about Excel!
Hey Patti. You can connect with me at [email protected] Look forward to catching up with you.