Translations:Basic Excel/144/en

Introduction

You may at times be asked to provide summary outputs or perform analyses based on data provided by someone else. This data will almost certainly not have been prepared for these purposes, and may not be in a format suitable for your needs. In this exercise, we will focus on manipulating existing data into a form that is appropriate for pivot table and chart creation. Pivot tables and charts are useful in their own right, but they also provide a good way to inspect the integrity of the underpinning data.