SISHUPAL eclassroom

      All Formula of MS Excel       1- Total = SUM(Range)   2- Average = Average (Range)   3- Percentage = Part/Whole      1- Count (Number) = count(range)   2- Count ( Number and texts) = counta(range)  3- Count (Blank cells) = countblank (range)  4- Count (condition) = countif(range,criteria)          1-VLOOKUP - Vertical lookup  = vlookup(lookup value, table array, column index number, range lookup)

  What is Pivot Table ?       Pivot table is a systematic table which counts all data like sum, average, counts and many more.     We can change row date to column and also column dates to row.     We can summarise large mount of dates into small spce.     Steps to create a pivot table  --> Open WPS office app + Ss Bs  --> Write some datas  --> Now select all datas  --> Then go to insert tab  --> Then click pivot table  --> Then click ( done ) option  --> Now new window will open  --> You can see 3 fields  --> Then click and drag one by one field according to our recruitment  --> Finally click Export option