Excel Filter Trick

Post author:Neale Blackwood
Post published:30/03/2017
Post category:Data Excel Blog Tips & Tricks
Post comments:2 Comments

Do you use the “Filter by Selected Cell’s Value” option? If you do then you will be pleased to know there is a Quick Access Toolbar icon that applies it in one click. (more…)

Excel and Ctrl + A

Post author:Neale Blackwood
Post published:27/03/2017
Post category:Data Tips & Tricks
Post comments:0 Comments

This Excel keyboard shortcut is powerful, but it has a few quirks you need to be aware of. Its quick to use because the A and Ctrl keys are so close together. (more…)

How Many Fortnights in a Month

Post author:Neale Blackwood
Post published:07/03/2017
Post category:Functions
Post comments:0 Comments

I had a question during one of my Date and Times Webinars in February. It was about months and fortnights. I couldn’t answer it during the webinar, but I did follow up with an email with the solution. The answer follows.

(more…)