Using the Pivot table function in Excel, you can do an analysis on the Excel report. For example, the percentage of the reviews who talk about a certain topic, like the staff, can be broken down by meta data like the 1-5 score of the reviews. Thus, allowing you to figure out the percentage of the reviews broken by score category.
How To Use Pivot Tables in the Excel Report Print
Modified on: Tue, 12 Sep, 2017 at 1:14 PM
Did you find it helpful?Send feedback
Sorry we couldn't be helpful. Help us improve this article with your feedback.