https://wiki.isikhnas.com/index.php?action=history&feed=atom&title=Translations%3ABasic_Excel_Trainer%2F50%2Fen 2026-09-05T23:40:21Z Revision history for this page on the wiki MediaWiki 1.31.16 https://wiki.isikhnas.com/index.php?title=Translations:Basic_Excel_Trainer/50/en&diff=9319&oldid=prev 2014-08-25T04:48:19Z

<p>Importing a new version from external source</p> <p><b>Halaman baru</b></p><div>==== Pivot table requirements ====<br /> Ask the participants to suggest how data must be managed/structured for pivot tables:<br /> * data must be organised in a table format - in rows and columns<br /> * there must be a header row<br /> * each heading entry must be unique<br /> * if the dataset is to be uploaded elsewhere, there may be restrictions on the format of the header entries<br /> ** for example, no spaces, and there may be a maximum length<br /> * there must be no completely blank rows or columns<br /> * no merged cells<br /> * each record should be on a single row<br /> * each column should contain the same type of data<br /> ** for example, all dates should be expressed the same way<br /> * single piece of information per column<br /> ** separate column for each piece of data that will be analysed<br /> * source data must be separated from other data<br /> ** preferably on its own worksheet<br /> ** at the very least, separated by a row and a column from anything else<br /> * no hidden rows (they probably won't suggest this; could be left for advanced course)<br /> * no totals or subtotals rows or columns<br /> * no columns that are calculated based on other columns<br /> ** can lead to errors in pivot table calculations<br /> ** best to let pivot tables do any required calculations</div>

FuzzyBot