Have you ever received an awkward data set? In my life as a Data Analyst this has happened to me many times in different shapes and forms. Continue reading
Date Archives → 2015
Trump Excel: Get the List of File Names from a Folder in Excel
When you want to get a list of Excel file names from a folder and display it in an Excel sheet most people would think about using VBA (Excel’s programming language). But what if you don’t know VBA? Continue reading
Video 00137 Vlookup_Returns Multiple Values
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
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.