5 Default Pivot Table Settings You Should Reset

You know that annoying bit when every time you’ve refreshed your pivot table, you also need to re-size your columns?  This is how you can prevent it from happening Do you see #DIV/0! errors in your pivot tables? No worries, Excel is just reminding you that you cannot divide by 0 Tip: You can also type the value/text you … Continue reading 5 Default Pivot Table Settings You Should Reset

How Do I Quickly Get Rid of Unused Range with VBA?

What is unused range? The best way to explain it would probably be "a residual redundant space" - Excel simply remembers the last cell in which you ever had data even after that data is long gone. How do I check if my workbook has unused ranges? Click on a random cell in your sheet … Continue reading How Do I Quickly Get Rid of Unused Range with VBA?

7 most common data integrity problems

I still very vividly remember my first ever lecture as an MSc student - it was a "Business Intelligence and Data Management" class and the teacher was explaining about the major discrepancies in data formats that can emerge in large-scale organizations... Wow! I've actually seen each one of them when I was working as an … Continue reading 7 most common data integrity problems

How Do I Quickly Enclose String in Quotes?

Can you give me a list of all the product information that we hold for these products? As a Business Analyst, that is a fairy simple question to answer - just a matter of a couple of joins and a where-clause. What could make it annoying and unnecessarily time-consuming, however, is the necessity to use … Continue reading How Do I Quickly Enclose String in Quotes?