1. Basic Introduction to Excel

• What is Excel and why it is used in stores
• Workbook vs Worksheet
• Rows, Columns, Cells
• Saving, Opening & Managing Files

2. Data Entry Skills for Store Work

• Entering item names, codes, categories
• Entering quantities, rates, stock values
• Using AutoFill, AutoComplete
• Formatting text, numbers, dates

3. Formatting for Store Records

• Column width, row height
• Borders, shading, alignment
• Number formatting (units, decimals, currency)
• Conditional formatting (low stock highlighting)

4. Basic Formulas Used in Stores

• SUM (Total Quantity)
• AVERAGE (Average Consumption)
• MAX / MIN (Highest & Lowest Stock)
• COUNT, COUNTA
• Percentage formulas (damage %, wastage %)
• Basic arithmetic (+ – × ÷)

5. Inventory Management Sheets

• Item master sheet creation
• Stock register format
• Purchase register
• Issue register
• Opening & Closing stock sheet
• Damage/Return register

6. Data Sorting & Filtering

• Sort by item name, code, category
• Filter for stock less than minimum level
• Filter by supplier
• Advanced filters for store reports

7. Stock Calculation & Daily Reports

• Opening stock calculation
• Inward entry (Purchased / Received)
• Outward entry (Issued / Delivered)
• Closing stock formula (Opening + In – Out)
• Daily & monthly stock summary

8. Excel Tables for Store Records

• Creating structured tables
• Table formatting for large store data
• Using table filters & slicers
• Advantages of tables in stock management

9. Important Functions for Store Keepers

• IF (Checking stock level, reorder alerts)
• VLOOKUP (Item search from master list)
• HLOOKUP
• XLOOKUP (Advance searching)
• CONCAT / TEXTJOIN (Item code creation)
• ROUND / ROUNDUP

10. Store Billing Using Excel

• Creating simple invoices
• Bill format with formulas
• Auto-calculation of totals
• GST calculation (if required)

11. Charts & Visual Stock Reports

• Bar charts (Stock comparison)
• Line charts (Consumption trends)
• Pie charts (Category-wise stock share)
• Dashboard basics for store management

12. Data Validation for Store Accuracy

• Prevent wrong quantity entries
• Allow only numerical values
• Create dropdown lists (Item category, supplier)

13. Printing & Page Setup

• Print area selection
• Page layout for stock sheets
• Header & footer (Store name, date)
• Printing stock registers cleanly

14. Protection & Security

• Locking formulas
• Sheet protection
• Password protection for stock sheets

15. Real-Life Store Projects

• Prepare a full inventory register
• Maintain daily inward/outward records
• Make reorder alert system
• Create monthly store report
• Prepare consumption analysis dashboard