During five years’ experience in business consulting work, I developed several excel spreadsheets, KPI’s managing, cost control and FTE calculation sheets.
To do so, I use formulas combos, such as, INDEX;MATCH;MATCH or OFFSET;COUNTIF;MATCH, and others, like, VLOOKUP, SUMIFS, and others as it’s needed.
I do have some knowledge in VBA to improve the formulas and also the layout.
Along with this, I created several power points presentations, to present the excel spreadsheets results. The audience were: board members to specialist employees.
The clue is creating a robust presentation standard to sustain a good and clean layout and presentation.