HOW TO CREATE PIVOT TABLE AND CHART
*CREATE A TABEL WITH THE REQUIRED INFORMATION.
*GO TO INSERT , CLICK ON PIVOT TABLE OR CHART.
*A PIVOT TABLE RANGE WILL BE PRESENTED.
*FILL IN THE NECESSARY DATA REQUIRED THEN CLICK ON ENTER.
*THE PIVOT TABL WILL BE SHOWN DEPENDING WETHER YOU CHOSE IT TO BE ON THE SAME SHEET OR ANOTHER SHEET.
Data validation
DATA VALIDATION is a feature in excel that allows you to control the data entered into your worksheet.It also means checking the accuracy and quality of data before entering and using the data.
It can also be used for many instances and situation E.G THE DATE FEATURE which only allows you to input only specific dates in a particular cell,rows or column………..E.T.C..
Look up function
LOOK UP function in excel means referencing a cell to match a value in another row or column against the cell and thereby retrieving the corresponding rsults from the respective rows and columns…..
