|
Week - 1 |
Learns the importance of Basic Office Programs in the context of logistics activities. |
|
Week - 2 |
Understands the concept of raw data and organizes it effectively. |
|
Week - 3 |
Table Creation: Cell, row and column operations |
|
Week - 4 |
Data Types: Cell formatting, Table design |
|
Week - 5 |
Basic Formulas and Calculations |
|
Week - 6 |
IF Function: Scenario evaluations |
|
Week - 7 |
Data Management Tools: Conditional formatting, Marking delayed orders, Creating critical stock level alerts |
|
Week - 8 |
Data Management Tools: Converting text to columns, Filtering, Sorting, Data validation |
|
Week - 9 |
Data Query Operations: Data querying with VLOOKUP, HLOOKUP, INDEX-MATCH functions related to stock and ahipment |
|
Week - 10 |
Stock Tracking and Shipment Planning Applications |
|
Week - 11 |
Data Analysis and Summarization: Pivot table, Data summarization, Analysis |
|
Week - 12 |
Logistics Data Visualization with Charts and Dashboards |
|
Week - 13 |
Reporting: Report writing, Presentation Preparation |
|
Week - 14 |
Reporting: Report writing, Presentation Preparation |