Pivot Tables | Using an Excel pivot table to analyse tender applications

Published: Fri, 05/16/14


The Excel Expert
Learn to love Excel - one cell at a time. Tutorials for beginners, tips for experienced users


Pivot Tables | Using an Excel pivot table to analyse tender applications- 2014-05-12 03:33:13-04

Recently I was asked to help a manager score a series of tenders. The scenario was as follows: He had 10 questions for each tender application. Some questions were deemed essential. Others less so.  He had 15 applications He needed to find some way to be able to quickly stay on top of  the tenders [...]
Read more...