October 2011
There’s a handful of mistakes almost everyone makes when they first use Excel. I know I did. In fact some of us are still making these mistakes. Are you? The good news is they’re easily fixed. Mistake 1. Create reports that take a long time to update. I’ve done it before. I’ve I imported the [...]
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 [...]
![Post image for Learn Excel OFFSET Function at the Beach, Seriously [VIDEO]](http://www.myonlinetraininghub.com/wp-content/uploads/2011/10/offset_video_thumb_sm.jpg)
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 [...]
... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses
