Formula Friday- Excel Tip- Generate Random Numbers With Excel.
Do you need to generate random numbers for a project? Excel can help. This guide will show you how to use the RAND and RANDBETWEEN functions to create random numbers in Excel. You can also learn some...
Macro Mondays – Limit The Scroll Area Or Range Movement In An Excel Worksheet
It's Macro Mondays time again. Have you ever been working on an Excel spreadsheet and had the scroll bar just go crazy, making it hard to navigate to the cells you need? Well, there is a way to...
Hey All, it's Formula Friday again. Today let's look at a handy little formula called DATEDIF. DATEDIF is a function in Excel that calculates the difference between two dates. It can be used to...
Excel Tip- Formula Friday -How To Create a drop down list for your hyperlinks in Excel
Adding a drop down list to your Excel sheet is a really great and convenient way to allow data entry to your Excel worksheets whilst maintaining good quality consistent data and reducing the amount...
Macro Mondays – A Very Useful Excel Macro To Convert All Cells To Values.
Hello Excellers and Welcome to another #macromonday. I want to share with you a Macro that will convert all the cells in a your active workbook to values only. This is the same as using the copy...
Formula Friday – Let’s Use TEXTJOIN To Join Text Strings Without The CONCATENATE Complexity
Happy Friday Excellers. Welcome back to another #FormulaFriday #Excel blog post in my Excel series. I will compare TEXTJOIN and CONCATENATE. If you have Excel 2016 then you may be...