Data Analysis (MS Excel):

Spread the love

Assignment:

  • Data Available in Raw Shape

  • To make analysis

  • use of Pivot Table

 

Use of Formulation & Function:

  • Date = Date()

  • Sum = Sum ()

  • Condition/Check = If()

  • Conditional Sum =  Sumif()

  • Absolute Cell Reference

  • Length = LEN()

  • Left = Left()

  • Error = Iferror()

  • Null Valve

  • Chart

  • Pivot Table

 

Additional:

  • Day, Month, Year

  • Right, Mid

  • Sumif with multiple condition

Author: wehelpf9

Leave a Reply