How do I create a Sample Excel analytic work. Something to show case my strength in Excel. I am fairly decent in excel and using it for report, great with navigating around it but my use of excel has been basic formula, Match/Index, pivot table/chart, H/V-Lookup, rare use of macro of which I usually get help with on these so I cannot say am independently a VBA coder. I need help with showcasing all of this in excel sample somehow.

Any assistance that will help channel my thought to the best way of showcasing this Excel analytic sample will be great.

Help me please!!!