excell skills

 today i have lear excel tips
to replace id with name in excell

change date formate

replace 1,0 with yes or no

1.for change operation id to operation name we first add new sheet sheet2 in the operation column add the formula to convert data from sheet2 here then drag till end it will update

2.change date formate select top on colun headr under number change date formate.

3.changed budgeted yes or no from 1,0 same way apply the formula in new column in  that give this column and drag it will generate later delete the old column.

4.total sum of amount for that below the excel column data =SUM(),inside give first and last column
by selecting first column i will auto populuate column number same inko user also same way doing.