ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Project Title: Inventory Management System
2
Objective:
3
To monitor inventory levels and identify items that require restocking.
4
5
Tools Used:
6
Google Sheets
7
8
Key Skills Applied:
9
- IF
10
- IFERROR
11
- COUNTIF
12
- Conditional formatting
13
14
Key Insights:
15
- 4 items required urgent restocking.
16
- Equipment category had the highest stock usage.
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100