Hello Excellers, time for another Formula Friday. Today let's look at calculating the percentage of the year that is completed and that is remaining really easily using the YEARFRAC function in...
Category: Formulas
Formula Friday – Sum Formula Not The Best Solution? Try Subtotal!
Today's Formula Friday will be looking at the Sum Function vs the Subtotal Function. If you want to download the Formuala Friday examples you can so so here [wpdm_package id='10703'] Even...
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...
It's Friday so that means some more Formula Fun. Today let's look at calculating the percentage of cells in a range that contain a specific string. I have used this to as an alternative to a...
Formula Friday – 2 Ways to Switch First And Last Names In Cells In Excel
Today's blog post was actually a question from one of my colleagues at work earlier this week, they had a list of first and surnames of employees, separated by a comma, with the surname first and the...
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...