I want to show you today how to easily insert a YouTube video into Excel.  Why would I want to do that you may ask?.  ..... Maybe you need to send a user a video on how to use the Excel...

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...

Hello Excellers, Friday again and I have a really quick, easy and really useful way to use  named ranges you have already created into  your formulas.  If you need more details on creating named...

Welcome, Excellers. Almost everyone who has used Excel has had to work with Pivot Tables at some stage. I will show you how to list all the calculated fields and items in your Pivot table in today's...

Today's #formulafriday Excel tip will show you how to identify the the highest or lowest value in a row of data and return the column heading or title.  So let's say you have some data set out as...

I have used this formula on a regular basis to return the last value in my rows of data, handy if you add in new values every month to an Excel spreadsheet but always want to return the most recent...