Vlookup returns only 1 value, right? Well…normally yes but there are some tricks to return multiple values (numbers) and add them up. Continue reading
Video 00137 Vlookup_Returns Multiple Values
Author Archives → Kevin Lehrbass
Why I Enjoy Watching excel.tv
My Initial Reaction
I can’t remember how I discovered Excel.TV but I watched the episode 1 trailer and my initial reaction was something like this: “WHAT???” followed by “Who are these guys?” and “I’ve got to check this out!“. Continue reading
How Can I Improve My Excel Skills?
I have been asked this question many times so I thought I would write this post as a reference that I could share with anyone who wants to improve their Excel skills.
Download the Excel file from my OneDrive (file 00126) Continue reading
Video 00121_Crazy String Manipulation!
Look carefully at the picture below for a few seconds…
If you extract all numbers, from left to right, you can create a Date/Time value of Nov 28, 2014 5:08pm (and 51 seconds) in Microsoft Excel.
Continue reading
Video 00120 Is the solution benefit worth the cost
Is the solution benefit worth the cost?
With any product there is a balance between the number of features versus the cost/performance. Race cars and stretch limos have different features and different purposes. Continue reading
My Favorite Excel Tips From Other Sites Part 2.
As much as I enjoy sharing my knowledge I have found that this series is just as beneficial for me as it is for others. I sometimes ask myself or others “Do you remember that Excel thing that does….” Continue reading
Video 00119 Excel Helps to Determine the Closest Super Bowls
How do we define a close Super Bowl game?
I was thinking about this on Friday…. It’s got to be more than just the final score point difference.
Sure, an exciting finish like the 1991 Giants vs Bills game is a classic. Continue reading
Video 00114_Cleanup Data From Internet
Have you copied data from the internet and pasted it in Excel?
It can be very frustrating when the data is messy!
Sometimes there are data quality issues and you should examine the data before adding formulas and formatting.
Free Excel Template: Birthday and Anniversary Tracker
This template allows you to keep track of events like birthdays and anniversaries. You can also create more events in the ‘Settings’ sheet. In the ‘Input’ sheet you walk through the steps of selecting the event type, adding the individual’s name and date, etc.
My Favorite Excel Tips From Other Sites Part 1.
I work full time as a Data Analyst currently specializing in Microsoft Excel and Microsoft Access. To keep up to date I watch a fair amount of YouTube videos and follow several websites. Continue reading