UNSTRUCTURED
In many workplaces, tables, bar charts and run charts abound. The tools used are mostly common spreadsheet systems such as Microsoft Excel.
These systems are used for different kinds of tasks. They are flexible and powerful, but there are also drawbacks. Many of these lie on a general level and result mostly in waste of time and resources, but other issues can definitely result in severe errors.
There are still valid reasons to use spreadsheets for statistical purposes: licenses are available at low costs and some statistical functions are present. Despite their shortcomings, spreadsheets will not be replaced in any foreseeable future. They are used both for administrative and "analytical" purposes. In research, spreadsheets are also commonly used to share data.
The goal is to point at some simple routines in common spreadsheets which still are not that commonly known, specifically those called pivot tables in Microsoft Excel.
Better spreadsheet skills and knowledge of how to set up pivot tables could make it possible for both experienced analysts and staff with less statistical training to make everyday basic calculations with little effort and without specialized software.
Moreover, since these routines require data to be set up in way in line with how data must be organized in statistical software, future use of such systems software is simplified. Furthermore, the necessary training can be achieved with limited resources. So _everyone_ should have pivot tables as part of their everyday skills.