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...
Are you trying to figure out percentage change or variance? You're in luck! In this blog post, we'll show you how to do it step-by-step using Excel. Whether you're looking for the variance between...