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...
Happy #formulafriday Excellers. Today we are going a little left of field, and looking at the really useful LEFT Function in Excel. This a a really useful function to have in your Excel toolbox...
Formula Friday – Shhhhh…Want To Hide Your Excel Formulas?????….
Hello Excellers, and welcome back to another blog post in my #Excel series. So, something a little different for today's #formulafriday blog. Instead of showing our Excel formulas, I...