Excel Tip- How Insert A Blank Column After Every Data Column In Your Excel Sheet
Hello Excellers, in this blog post today lets look at insert blank column or blank columns after every data column in your Excel worksheet. This blog post is in answer to a lot of questions from...
Hello fellow Excellers, I hope you are well and thanks for joining me on another macro Monday blog post. I want to share with you today how to protect and or hide your Macros from prying eyes. ...
Your Data Is In Access But You Need To Create An Excel Report – Create An External Data Connection
If you have data stored outside of Excel, such as an Access Database, SQL Server or and OLAP Cube then you can still use a Pivot Table to analyse this data, yes all you need to do is connect to this...
Formula Friday – Do You Want A FAST and FUN Way To Learn Excel Formulas?
Excel formulas can be daunting, I know that - even if you have been been using excel for years, the formula part can be scary. The many text books on offer or courses really do get complicated...
Macro Mondays – How To Display One Excel VBA Procedure At A Time
Hello Excellers and in today's #macromondays blog post, let's look at something a little different that may help you if you have multiple procedures or macros in the one Module. Normally your code...
Formula Friday – Which Range Does My Value Fit Into – A Perfect Job For The LOOKUP Function.
Hello Excellers and welcome to another #formulafriday. Today let's look at a an Excel function that can return a value from a range (a row or a column). LOOKUP is one of Excel's lookup and...