Data Analysis (MS Excel):

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

0 0 votes
Article Rating
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x