Formula Friday – Generate Random Interview Name Lists No Repeats In Excel
I love Friday, as it is time to share more Formula Fun. Today let's look at generating some random names against times slots which are going to use to schedule interview times for potential...
Formula Friday – Using Keyboard Shortcuts To See Precedent or Dependent Cells In Excel
Today let's look at how to use Excel keyboard shortcuts to see Precedent or Dependent Excel cells in an Excel workbook. I use these two commands to easily audit my Excel formulas. Cells that are...
Formula Friday – 3 Ways To Remove Days From A Date In Excel To Leave Just The Month And Year
Hello again Exellers, today let's look at 3 ways to remove the Days portion from a date in Excel. This was an issue one of my collgeaues came across this week. Let's take a look at the...
Have you come across a data set that looks a bit like this?. The source data in your Pivot Table is not as clean as it should be with a slight variation in spelling that is a right pain in the...
Formula Friday – Easily Spot Excel Formula Errors In A Large Excel Worksheet
It's Friday yet again, time for some Formula Fun.....Let's take a look at finding formula errors today. If you have a really large worksheet you may not be able to look at it all at once...