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...
Hello Excellers. Welcome to another article in my #macromonday series of blog posts. Are you looking for a way to update your pivot tables without having go into each table individually?. If so,...
Hello, Excellers and welcome back to another #FormulaFriday #Excel blog post in my Excel series. Today I want to answer a question that a subscriber sent to me. If you want to ask any...
Hello Excellers, welcome back to another #macromonday blog post in my 2019 series of Excel tips. I want to share with you an easy Excel macro which hopefully will save you some time when preparing...