Hmm...seems strange to me. If you need to use pivot tables just use them, if you can use Excel you can use pivot tables. Perhaps you need more general training in Excel if you are unsure.
They are a great tool for manipulating small Excel databases but if you need to work with a database you are generally better working with a real database program...not Excel.