This task is to use VLOOKUP and PivotTable features in Excel. It's explained in the video. Please download the data set $($Sample Data Set for students $-$ VLookup & PivotTable Day $4.$xls $)$

which is given with todays task.

Please watch the video tutorial carefully before completing the following tasks:

$1.$ Display "Program Name" and "Fee" for each row in the data set, using VLOOKUP function

$2.$ Create following PivotTables $($you can choose to add those in separate or the same worksheet$)$

$$a$.$ Total number of Students based on their "Gender"

$$b$.$ Total number of students grouped by their status i$.$e$.$ How many Graduated, Cancelled, Withdrawn etc.

$$c$.$ Total number of Graduates in each program give me an example of it