Training to advanced level is the vital first step in mastering your Excel analysis and reporting. But it is the next step: applying what you've learnt to your industry-specific spreadsheets, that makes the difference.
We are planning a series of blogs and courses that will help people learn to apply advanced functions and do the kind of analysis most people need at some point. Some of the material may include VBA code. But often, if maths is not your strong point, you need to figure out more simple calculations like gross profit and margins etc.
Corné van Heerden, one of our specialist Excel trainers, has put together a useful article on calculating commissions based on GP that may just be what you're looking for.
Corné is a developer and business analyst, who trains for us in customised super-advanced Excel, VBA programming, BI, PowerPivot etc.