DIPLOMA IN STORE KEEPER ( S-DSK041 )

Diploma in Store Keeper – Excel Focused Syllabus (4 Months)

1. Store Management Basics

- Role of a Store Keeper

- Types of stores and inventory

- Importance of store records

2. Excel Basics for Store Work

- Introduction to Excel interface

- Workbook, worksheet, rows and columns

- Data entry techniques

- Cell formatting (text, number, colors, borders)

3. Excel Formulas for Inventory

- Basic formulas: SUM, AVERAGE, MIN, MAX

- Logical formulas: IF, AND, OR

- Lookup formulas: VLOOKUP, HLOOKUP, XLOOKUP

- Date & Time formulas for stock tracking

4. Inventory Register in Excel

- Stock In & Stock Out sheet design

- Daily stock entry system

- Opening & closing stock calculation

- Reorder level setup

5. Reports & Dashboard Creation

- Pivot tables for inventory summary

- Inventory charts (bar, pie, line)

- Conditional formatting for alerts

- Printable report design

6. Excel Data Protection & Printing

- Data validation (dropdowns for item list)

- Sheet protection and password setup

- Print layout, page setup, headers/footers

7. Real-Life Project in Excel

- Complete inventory system in Excel

- GRN, MRN, Issue slip templates

- Daily, weekly & monthly report sheets

CLASS 10TH