Using pivot tables to analyze survey data is not a bad idea, especially if you’re an expert with Excel and you’re comfortable using pivot tables. However, your data may not be in Excel format – you may have an SPSS file or a SAS file or a Triple-S file, in which case, using Excel will be challenging.
A better approach would be to use MarketSight, which was designed specifically for analyzing survey data and sharing results online. Of course, it also works very well on Excel datasets and is seamlessly integrated with PowerPoint. Why not give it a try? It’s free for 30 days.