Inserting text into a text box is one cool trick, but being able to have that text update when your data changes without you having to lift a finger is another. Here’s an example below. You can see when the selection in the PivotTable is changed the labels on the chart automatically update too. Watch [...]
I thought we’d take a break from the office and visit the beach to learn Excel’s OFFSET function.
We just arrived back from two weeks travelling around New Zealand with 3 other families. While there we managed to see some of the Rugby World Cup matches and do quite a bit of site seeing around the North Island. Our adventure started in Auckland where each family picked up a campervan which were to [...]