Objectives 1. To apply a range of functions which allow ore-off questions to be asked of the data Functions you must use include sum, average. max, min. count. counta, countif, countifs. sum, surnifs. Other calculalionallormulae should be included like calculation of percentages and use of +J.( operators. 2. To generale a number of pivot tables Mich summarise the delaset. Apply a range of pivot table functionality to demonstrate your ability to generate a wide variety of insights from the dataset 3. To apply the logic of if statements to show how you can generate new fields of intormation which enable you to Wither categorise your data. 4. To use a variety of charts ensuring the charts used arc suitable for the data you arc analysing. Charts cleated must be meaningful and be easy to understand and interpret. The charts created should work towards identifying trends and other noteworthy points of informatKin.
The post Generate a number of pivot tables appeared first on My Assignment Online.