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
Modified on: Tue, 12 Sep, 2017 at 1:14 PM
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.