Pivot tables can be used for many things however their best function is served by collating data for you. This is easier to create when the data is presented in log format. What we mean by this is that you should log each transaction individually and not auto-sum or total anything as it will be done by the Pivot table for us.
an example of a log entry with sales data could be:
Captions are useful for providing context to images, charts, and other illustrations in your document. A table of figures helps readers navigate these elements quickly by creating a table with all 'captions' in it as well as their page number. Captions can also be used to create a table of tables or a table of equations too, by changing the 'label' when inserting a caption, or inserting the table.
Page numbering happens in the headers or footer of the document, making use of section breaks to indicate where page numbering will and will not be present. This guide will focus on adding page numbers from the beginning but will cover their usage afterwards.
Word has a feature that allows users to automatically generate an automatic table of contents, assuming that heading styles have been used. This table of contents supports different levels of indentation to highlight chapters and sub-chapters of the document itself.
Styles can be quickly used to apply a formatting choice over a large area of a document. All text is initially created under the Normal style and will remain in this style unless Word is told otherwise. You can modify any existing style or create your own if there is not a pre-existing option similar to what you require. Creating or modifying a Style allows you to choose all formatting; The font, size, colour and paragraph settings.
Create a chart
Select the data for which you want to create a chart.
If functions are used when we want to specify a criteria to limit our function to. For instance, if we were interested in values above a certain amount we could use =countIf in order to count the number of the values in a range, that are above a certain value. There are multiple different functions that can use IF's. These include:
=SumIF
=CountIF
=averageIF
A sparkline is a small graphic designed to give a quick representation of numerical or statistical information within a piece of text, taking the form of a graph without axes. This is displayed within a single cell and can be used to visualise data when you don't have enough room or it isn't suitable for a full size chart.
Page & Section breaks have multiple uses. They are most notably used to create different sections within the same document, so that you can apply a different page orientation, affect page numbers and different headers/footers per section.
This guide will show you how you can create hanging indents that you may need to use in your referencing or simply to format your paragraphs throughout your document.
