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