Difference between revisions of "Simplified datasheet"
| (2 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | mTAB's feature list also includes a new shortcut for copying and pasting data from mTAB's spreadsheet view into Powerpoint. A new spreadsheet menu item Simplified Datasheet displays a condensed spreadsheet view, which is suitable for cut-and-pasting into a Powerpoint chart datasheet. | |
| − | + | The mTAB spreadsheet view shown consists of a few aggregated brand columns and rating row questions from an inspection survey. The row questions are formatted to Top 2 Box which effectively displays the "% satisfied". Note that the simplified data sheet can work with any type of row or column question format, but to cut-and-paste in a single operation, all row or column questions must have the same question format. | |
| + | In the '''Spreadsheet''' ribbon, select '''Simplified Datasheet'''. | ||
| − | + | [[File:Spreadsheet simplified-datasheet simplified-datasheet.jpg|thumb|center|x400px]] | |
| + | mTAB will prompt you to confirm the type or format of data that you wish to display in the simplified datasheet. The simplified view is now presented as a new spreadsheet. | ||
| − | |||
| + | If you wished to create a chart that requires the opposite row and column perspective, go to '''Invert Data''' located in the '''Spreadsheet''' ribbon to swap the row and column questions within the simplified datasheet. | ||
| − | + | [[File:Spreadsheet simplified-datasheet invert-data.jpg|thumb|center|x400px]] | |
| + | Now it is just a matter of cut-and-paste between the simplified datasheet and Powerpoint's datasheet. Start by selecting the data block from the mTAB simplified datasheet, then use the mTAB menu command '''Copy''' to copy the datasheet results to the clipboard as shown. This can also be done by right-clicking on the highlighted data and selecting '''Copy'''. | ||
| − | + | [[File:Spreadsheet simplified-datasheet copy.jpg|thumb|center|x250px]] | |
| − | + | ||
| + | Finally, after creating a new chart within Powerpoint and clearing the default datasheet values, paste to populate the Powerpoint datasheet. | ||
| − | + | [[File:Spreadsheet simplified-datasheet powerpoint.jpg|thumb|center|x400px]] | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | Note: the simplified datasheet view additionally supports exporting to an Excel XLS file by using mTAB's File Export menu item. | + | '''Note:''' the simplified datasheet view additionally supports exporting to an Excel XLS file by using mTAB's File Export menu item. |
Latest revision as of 14:06, 11 August 2017
mTAB's feature list also includes a new shortcut for copying and pasting data from mTAB's spreadsheet view into Powerpoint. A new spreadsheet menu item Simplified Datasheet displays a condensed spreadsheet view, which is suitable for cut-and-pasting into a Powerpoint chart datasheet.
The mTAB spreadsheet view shown consists of a few aggregated brand columns and rating row questions from an inspection survey. The row questions are formatted to Top 2 Box which effectively displays the "% satisfied". Note that the simplified data sheet can work with any type of row or column question format, but to cut-and-paste in a single operation, all row or column questions must have the same question format.
In the Spreadsheet ribbon, select Simplified Datasheet.
mTAB will prompt you to confirm the type or format of data that you wish to display in the simplified datasheet. The simplified view is now presented as a new spreadsheet.
If you wished to create a chart that requires the opposite row and column perspective, go to Invert Data located in the Spreadsheet ribbon to swap the row and column questions within the simplified datasheet.
Now it is just a matter of cut-and-paste between the simplified datasheet and Powerpoint's datasheet. Start by selecting the data block from the mTAB simplified datasheet, then use the mTAB menu command Copy to copy the datasheet results to the clipboard as shown. This can also be done by right-clicking on the highlighted data and selecting Copy.
Finally, after creating a new chart within Powerpoint and clearing the default datasheet values, paste to populate the Powerpoint datasheet.
Note: the simplified datasheet view additionally supports exporting to an Excel XLS file by using mTAB's File Export menu item.
