Tips & Tricks

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