Formula Friday – Find The Missing Values In My Columns Of Data
Hello it's #formulafriday. Time to have some #formulafun with a couple of functions to help me find values that are listed in one column of data and not the other. We are going to use the IF,...
Formula Friday – How About A Date…Converting Text To A Real Date With DATEVALUE
Hello Excellers time for some more #formulafridayfun. How about today we look at using the DATEVALUE function to convert text values in our Excel worksheets to a REAL Date value. First let's...
Macro Mondays – Copy Excel Rows From One Worksheet To Another Worksheet Based On Criteria Using VBA
Hello Excellers, time for some more #MacroMonday fun. Today's Macro will allow you to quickly copy rows of data from one worksheet to another. This can be really useful if you carry out the same...
Excel Tip – Identify All Cells In A Worksheet With Conditional Formatting
Don't forget to sign up to the Excel at Excel Newsletter for 3 FREE Excel tips the first Wednesday of the month. Just click on the Sign Up Form to the right or use the link below. You will also...
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...