Iain (JRA)
Administrator
Posts: 7
Offline
|
If you have copied tables from your online reports into Excel (just change the view of your data to "Table", then click on the Copy button), here are a couple of tips for working with the data. You can quickly identify the highest or lowest rated questions by going to the menu bar in Excel, select Data > Sort, and select the column you wish to “Sort by” from the dropdown box. Indicate whether you would like to sort the data in ascending (lowest to highest) or descending (highest to lowest) order. Click the OK button. If you created a table with a number of demographics in it, you can distinguish high and low scoring groups by automatically highlighting the highest and lowest scores using Conditional Formatting. Conditional formatting allows you to stipulate the formatting you would like applied to cells based on their contents. For example, you could have the cells with scores of less than 65% turn red. To use conditional formatting highlight the cells you wish to apply the formatting to, then go to the menu bar and select Format > Conditional Formatting. Make your selections from the dropdown boxes and enter the numbers so that the condition reads “Cell value is…less than…65%”. Now click on the ‘Format’ button, and you can select a font colour or cell background colour that will be used on cells meeting the above criteria. Click OK. Now the cells with scores of less than 65% will be highlighted using the formatting you specified. Note that you can have more than one condition applied to the same cell or group of cells. For example, you could have all the scores below 65% in red as well as all the cells above 80% in blue. For more advanced users of Excel I have created a Macro which highlights the highest and lowest numbers in a table automatically. Post a message here or contact me on iain@jra.co.nz if you would like the code for this.
|