Blog & Excel Tips
Free Tips & Tricks Newsletter Please fill in your details below to get regular Excel tips and tricks and a free Quick Reference Download!
Blog entries covering the latest Excel tricks and tips based on queries from clients and practical knowledge from our consultants.
Occasionally you may want to filter a pivot table based on values in other cells. This is to avoid having to check so many items. You can use VBA but an alternate is to create a helper column in the underlying data.
How to change Excel's Group and Ungroup setting so that the plus and minus appear at the bottom
How to find the 'Show Report Filter Pages' option in Excel 2011 on the Apple
A spreadsheet download that will show the updated tax tables for the 2013/ 2014 and the 2014/ 2015 years for South Africa with an optimisation calculation for dividends
We aim to provide the ultimate, one stop shop for all Excel users requirements, within South Africa and worldwide.
"Recently we had a most successful in-house training session at our company. I would like to extend my thanks and gratitude."