How to create a linked dashboard (or landing page) for your Excel workbook

Have you ever had the pleasure (or displeasure) of working with an extra large Excel workbook with many, many different sheets? This happens frequently, especially if you are working with a large amount of data that needs to be analyzed periodically. This may be due to multiple tables, lookups, references, charts, graphs etc. This has […]

Continue reading


Using Wildcards to make finding or replacing data in Excel quicker and easier

This tip is useful when you want to replace or find text using Wildcards, e.g. if you have a column where you would like to replace everything after the space character with text. What are Wildcards? Wildcards are characters that are used to represent one or more characters. The following wildcard characters can be used […]

Continue reading


5 Reasons solo-entrepreneurs should use business intelligence

Even though most solo-entrepreneurs understand the benefits of business intelligence, they will probably never take advantage of it. They will assume they have neither the time nor the money to make use of business intelligence. But the field of business intelligence has changed over the years. It’s now cheaper and easier than ever for freelancers, […]

Continue reading