আপনি কি এক্সেলের উপর দক্ষতা বৃদ্ধি করতে চান? আপনে কি রিপোর্টিংয়ের কাজ নিয়ে অনেক বকা ঝোকা শোনেন বসের কাছে? Don't worry today I will show, How you can report very quickly......
Lets begin........... our Project........
আমরা প্রায় সবাই জানি যে যদি অফিসিয়ালি হিসাব নিকাশের কাজ করতে চাই। তবে এক্সেল প্রোগ্রাম এর তুলনা হয় না। কিন্তু সেই এক্সলের কাজ যদি আমাদের বার্তি ঝামেলা করতে হয় তবে এর চেয়ে কষ্টের আর কি হতে পারে।
Excel এর মাঝে Pivot নামে একটি টুলস আছে যা আমাদের সাহায্য করবে এই কাজ করতে। তাই আর বেশি কথা না বলে আমরা শুরু করতে চাই__________________
প্রথম ধাপ
নিচের মত করে কমপক্ষে ২০০ টি Product নিয়ে দুইটি Category তে একটি লম্বা লিস্ট তৈরি করুন।
Lets begin........... our Project........
আমরা প্রায় সবাই জানি যে যদি অফিসিয়ালি হিসাব নিকাশের কাজ করতে চাই। তবে এক্সেল প্রোগ্রাম এর তুলনা হয় না। কিন্তু সেই এক্সলের কাজ যদি আমাদের বার্তি ঝামেলা করতে হয় তবে এর চেয়ে কষ্টের আর কি হতে পারে।
Excel এর মাঝে Pivot নামে একটি টুলস আছে যা আমাদের সাহায্য করবে এই কাজ করতে। তাই আর বেশি কথা না বলে আমরা শুরু করতে চাই__________________
প্রথম ধাপ
নিচের মত করে কমপক্ষে ২০০ টি Product নিয়ে দুইটি Category তে একটি লম্বা লিস্ট তৈরি করুন।
Order ID | Product | Category | Amount | Date | Country | |||
1 | Carrots | Vegetables | ৳ 4,270.00 | 06-01-12 | United States | |||
2 | Broccoli | Vegetables | ৳ 8,239.00 | 07-01-12 | United Kingdom | |||
3 | Banana | Fruit | ৳ 617.00 | 08-01-12 | United States | |||
4 | Banana | Fruit | ৳ 8,384.00 | 10-01-12 | Canada | |||
5 | Beans | Vegetables | ৳ 2,626.00 | 10-01-12 | Germany | |||
6 | Orange | Fruit | ৳ 3,610.00 | 11-01-12 | United States | |||
7 | Broccoli | Vegetables | ৳ 9,062.00 | 11-01-12 | Australia | |||
8 | Banana | Fruit | ৳ 6,906.00 | 16-01-12 | New Zealand | |||
9 | Apple | Fruit | ৳ 2,417.00 | 16-01-12 | France | |||
10 | Apple | Fruit | ৳ 7,431.00 | 16-01-12 | Canada | |||
11 | Banana | Fruit | ৳ 8,250.00 | 16-01-12 | Germany | |||
12 | Broccoli | Vegetables | ৳ 7,012.00 | 18-01-12 | United States | |||
13 | Carrots | Vegetables | ৳ 1,903.00 | 20-01-12 | Germany | |||
14 | Broccoli | Vegetables | ৳ 2,824.00 | 22-01-12 | Canada | |||
15 | Apple | Fruit | ৳ 6,946.00 | 24-01-12 | France | |||
16 | Banana | Fruit | ৳ 2,320.00 | 27-01-12 | United Kingdom | |||
17 | Banana | Fruit | ৳ 2,116.00 | 28-01-12 | United States | |||
18 | Banana | Fruit | ৳ 1,135.00 | 30-01-12 | United Kingdom | |||
19 | Broccoli | Vegetables | ৳ 3,595.00 | 30-01-12 | United Kingdom | |||
20 | Apple | Fruit | ৳ 1,161.00 | 02-02-12 | United States | |||
21 | Orange | Fruit | ৳ 2,256.00 | 04-02-12 | France | |||
22 | Banana | Fruit | ৳ 1,004.00 | 11-02-12 | New Zealand | |||
23 | Banana | Fruit | ৳ 3,642.00 | 14-02-12 | Canada | |||
24 | Banana | Fruit | ৳ 4,582.00 | 17-02-12 | United States | |||
25 | Beans | Vegetables | ৳ 3,559.00 | 17-02-12 | United Kingdom | |||
26 | Carrots | Vegetables | ৳ 5,154.00 | 17-02-12 | Australia | |||
27 | Mango | Fruit | ৳ 7,388.00 | 18-02-12 | France | |||
28 | Beans | Vegetables | ৳ 7,163.00 | 18-02-12 | United States | |||
29 | Beans | Vegetables | ৳ 5,101.00 | 20-02-12 | Germany | |||
30 | Apple | Fruit | ৳ 7,602.00 | 21-02-12 | France | |||
31 | Mango | Fruit | ৳ 1,641.00 | 22-02-12 | United States | |||
32 | Apple | Fruit | ৳ 8,892.00 | 23-02-12 | Australia | |||
33 | Apple | Fruit | ৳ 2,060.00 | 29-02-12 | France | |||
34 | Broccoli | Vegetables | ৳ 1,557.00 | 29-02-12 | Germany | |||
35 | Apple | Fruit | ৳ 6,509.00 | 01-03-12 | France | |||
36 | Apple | Fruit | ৳ 5,718.00 | 04-03-12 | Australia | |||
37 | Apple | Fruit | ৳ 7,655.00 | 05-03-12 | United States | |||
38 | Carrots | Vegetables | ৳ 9,116.00 | 05-03-12 | United Kingdom | |||
39 | Banana | Fruit | ৳ 2,795.00 | 15-03-12 | United States | |||
40 | Banana | Fruit | ৳ 5,084.00 | 15-03-12 | United States | |||
41 | Carrots | Vegetables | ৳ 8,941.00 | 15-03-12 | United Kingdom | |||
42 | Broccoli | Vegetables | ৳ 5,341.00 | 16-03-12 | France | |||
43 | Banana | Fruit | ৳ 135.00 | 19-03-12 | Canada | |||
44 | Banana | Fruit | ৳ 9,400.00 | 19-03-12 | Australia | |||
45 | Beans | Vegetables | ৳ 6,045.00 | 21-03-12 | Germany | |||
46 | Apple | Fruit | ৳ 5,820.00 | 22-03-12 | New Zealand | |||
47 | Orange | Fruit | ৳ 8,887.00 | 23-03-12 | Germany | |||
48 | Orange | Fruit | ৳ 6,982.00 | 24-03-12 | United States | |||
49 | Banana | Fruit | ৳ 4,029.00 | 26-03-12 | Australia | |||
50 | Carrots | Vegetables | ৳ 3,665.00 | 26-03-12 | Germany | |||
51 | Banana | Fruit | ৳ 4,781.00 | 29-03-12 | France | |||
52 | Mango | Fruit | ৳ 3,663.00 | 30-03-12 | Australia | |||
53 | Apple | Fruit | ৳ 6,331.00 | 01-04-12 | France | |||
54 | Apple | Fruit | ৳ 4,364.00 | 01-04-12 | Canada | |||
55 | Carrots | Vegetables | ৳ 607.00 | 03-04-12 | United Kingdom | |||
56 | Banana | Fruit | ৳ 1,054.00 | 06-04-12 | New Zealand | |||
57 | Carrots | Vegetables | ৳ 7,659.00 | 06-04-12 | United States | |||
58 | Broccoli | Vegetables | ৳ 277.00 | 12-04-12 | Germany | |||
59 | Banana | Fruit | ৳ 235.00 | 17-04-12 | United States | |||
60 | Orange | Fruit | ৳ 1,113.00 | 18-04-12 | Australia | |||
61 | Apple | Fruit | ৳ 1,128.00 | 21-04-12 | United States | |||
62 | Broccoli | Vegetables | ৳ 9,231.00 | 22-04-12 | Canada | |||
63 | Banana | Fruit | ৳ 4,387.00 | 23-04-12 | United States | |||
64 | Apple | Fruit | ৳ 2,763.00 | 25-04-12 | Canada | |||
65 | Banana | Fruit | ৳ 7,898.00 | 27-04-12 | United Kingdom | |||
66 | Banana | Fruit | ৳ 2,427.00 | 30-04-12 | France | |||
67 | Banana | Fruit | ৳ 8,663.00 | 01-05-12 | New Zealand | |||
68 | Carrots | Vegetables | ৳ 2,789.00 | 01-05-12 | Germany | |||
69 | Banana | Fruit | ৳ 4,054.00 | 02-05-12 | United States | |||
70 | Mango | Fruit | ৳ 2,262.00 | 02-05-12 | United States | |||
71 | Mango | Fruit | ৳ 5,600.00 | 02-05-12 | United Kingdom | |||
72 | Banana | Fruit | ৳ 5,787.00 | 03-05-12 | United States | |||
73 | Orange | Fruit | ৳ 6,295.00 | 03-05-12 | Canada | |||
74 | Banana | Fruit | ৳ 474.00 | 05-05-12 | Germany | |||
75 | Apple | Fruit | ৳ 4,325.00 | 05-05-12 | France | |||
76 | Banana | Fruit | ৳ 592.00 | 06-05-12 | United States | |||
77 | Orange | Fruit | ৳ 4,330.00 | 08-05-12 | United States | |||
78 | Banana | Fruit | ৳ 9,405.00 | 08-05-12 | United Kingdom | |||
79 | Apple | Fruit | ৳ 7,671.00 | 08-05-12 | France | |||
80 | Carrots | Vegetables | ৳ 5,791.00 | 08-05-12 | United Kingdom | |||
81 | Banana | Fruit | ৳ 6,007.00 | 12-05-12 | Canada | |||
82 | Banana | Fruit | ৳ 5,030.00 | 14-05-12 | Germany | |||
83 | Carrots | Vegetables | ৳ 6,763.00 | 14-05-12 | United Kingdom | |||
84 | Banana | Fruit | ৳ 4,248.00 | 15-05-12 | Australia | |||
85 | Banana | Fruit | ৳ 9,543.00 | 16-05-12 | France | |||
86 | Broccoli | Vegetables | ৳ 2,054.00 | 16-05-12 | United Kingdom | |||
87 | Beans | Vegetables | ৳ 7,094.00 | 16-05-12 | Germany | |||
88 | Carrots | Vegetables | ৳ 6,087.00 | 18-05-12 | United States | |||
89 | Apple | Fruit | ৳ 4,264.00 | 19-05-12 | Australia | |||
90 | Mango | Fruit | ৳ 9,333.00 | 20-05-12 | United States | |||
91 | Mango | Fruit | ৳ 8,775.00 | 22-05-12 | Germany | |||
92 | Broccoli | Vegetables | ৳ 2,011.00 | 23-05-12 | United Kingdom | |||
93 | Banana | Fruit | ৳ 5,632.00 | 25-05-12 | United States | |||
94 | Banana | Fruit | ৳ 4,904.00 | 25-05-12 | New Zealand | |||
95 | Beans | Vegetables | ৳ 1,002.00 | 25-05-12 | Australia | |||
96 | Orange | Fruit | ৳ 8,141.00 | 26-05-12 | United Kingdom | |||
97 | Orange | Fruit | ৳ 3,644.00 | 26-05-12 | Canada | |||
98 | Orange | Fruit | ৳ 1,380.00 | 26-05-12 | Australia | |||
99 | Broccoli | Vegetables | ৳ 8,354.00 | 26-05-12 | Germany | |||
100 | Banana | Fruit | ৳ 5,182.00 | 27-05-12 | United States | |||
101 | Apple | Fruit | ৳ 2,193.00 | 27-05-12 | France | |||
102 | Mango | Fruit | ৳ 3,647.00 | 28-05-12 | United States | |||
103 | Apple | Fruit | ৳ 4,104.00 | 28-05-12 | United States | |||
104 | Carrots | Vegetables | ৳ 7,457.00 | 28-05-12 | United States | |||
105 | Mango | Fruit | ৳ 3,767.00 | 29-05-12 | Canada | |||
106 | Broccoli | Vegetables | ৳ 4,685.00 | 30-05-12 | Germany | |||
107 | Banana | Fruit | ৳ 3,917.00 | 04-06-12 | United States | |||
108 | Apple | Fruit | ৳ 521.00 | 04-06-12 | Canada | |||
109 | Apple | Fruit | ৳ 5,605.00 | 10-06-12 | France | |||
110 | Broccoli | Vegetables | ৳ 9,630.00 | 11-06-12 | Germany | |||
111 | Banana | Fruit | ৳ 6,941.00 | 20-06-12 | Canada | |||
112 | Broccoli | Vegetables | ৳ 7,231.00 | 20-06-12 | United Kingdom | |||
113 | Broccoli | Vegetables | ৳ 8,891.00 | 23-06-12 | Australia | |||
114 | Banana | Fruit | ৳ 107.00 | 25-06-12 | France | |||
115 | Banana | Fruit | ৳ 4,243.00 | 26-06-12 | United States | |||
116 | Orange | Fruit | ৳ 4,514.00 | 27-06-12 | United States | |||
117 | Mango | Fruit | ৳ 5,480.00 | 02-07-12 | United States | |||
118 | Banana | Fruit | ৳ 5,002.00 | 02-07-12 | France | |||
119 | Banana | Fruit | ৳ 8,530.00 | 05-07-12 | Canada | |||
120 | Orange | Fruit | ৳ 4,819.00 | 07-07-12 | New Zealand | |||
121 | Broccoli | Vegetables | ৳ 6,343.00 | 11-07-12 | United Kingdom | |||
122 | Orange | Fruit | ৳ 2,318.00 | 13-07-12 | United Kingdom | |||
123 | Orange | Fruit | ৳ 220.00 | 20-07-12 | United Kingdom | |||
124 | Orange | Fruit | ৳ 6,341.00 | 20-07-12 | New Zealand | |||
125 | Apple | Fruit | ৳ 330.00 | 20-07-12 | Germany | |||
126 | Broccoli | Vegetables | ৳ 3,027.00 | 20-07-12 | United Kingdom | |||
127 | Orange | Fruit | ৳ 850.00 | 22-07-12 | New Zealand | |||
128 | Banana | Fruit | ৳ 8,986.00 | 23-07-12 | United Kingdom | |||
129 | Broccoli | Vegetables | ৳ 3,800.00 | 25-07-12 | United States | |||
130 | Carrots | Vegetables | ৳ 5,751.00 | 28-07-12 | United Kingdom | |||
131 | Apple | Fruit | ৳ 1,704.00 | 29-07-12 | United Kingdom | |||
132 | Banana | Fruit | ৳ 7,966.00 | 30-07-12 | Australia | |||
133 | Banana | Fruit | ৳ 852.00 | 31-07-12 | United States | |||
134 | Beans | Vegetables | ৳ 8,416.00 | 31-07-12 | Australia | |||
135 | Banana | Fruit | ৳ 7,144.00 | 01-08-12 | France | |||
136 | Broccoli | Vegetables | ৳ 7,854.00 | 01-08-12 | United States | |||
137 | Orange | Fruit | ৳ 859.00 | 03-08-12 | United States | |||
138 | Broccoli | Vegetables | ৳ 8,049.00 | 12-08-12 | United States | |||
139 | Banana | Fruit | ৳ 2,836.00 | 13-08-12 | Germany | |||
140 | Carrots | Vegetables | ৳ 1,743.00 | 19-08-12 | United States | |||
141 | Apple | Fruit | ৳ 3,844.00 | 23-08-12 | France | |||
142 | Apple | Fruit | ৳ 7,490.00 | 24-08-12 | France | |||
143 | Broccoli | Vegetables | ৳ 4,483.00 | 25-08-12 | Germany | |||
144 | Apple | Fruit | ৳ 7,333.00 | 27-08-12 | Canada | |||
145 | Carrots | Vegetables | ৳ 7,654.00 | 28-08-12 | United States | |||
146 | Apple | Fruit | ৳ 3,944.00 | 29-08-12 | United Kingdom | |||
147 | Beans | Vegetables | ৳ 5,761.00 | 29-08-12 | Germany | |||
148 | Banana | Fruit | ৳ 6,864.00 | 01-09-12 | New Zealand | |||
149 | Banana | Fruit | ৳ 4,016.00 | 01-09-12 | Germany | |||
150 | Banana | Fruit | ৳ 1,841.00 | 02-09-12 | United States | |||
151 | Banana | Fruit | ৳ 424.00 | 05-09-12 | Australia | |||
152 | Banana | Fruit | ৳ 8,765.00 | 07-09-12 | United Kingdom | |||
153 | Banana | Fruit | ৳ 5,583.00 | 08-09-12 | United States | |||
154 | Broccoli | Vegetables | ৳ 4,390.00 | 09-09-12 | New Zealand | |||
155 | Broccoli | Vegetables | ৳ 352.00 | 09-09-12 | Canada | |||
156 | Apple | Fruit | ৳ 8,489.00 | 11-09-12 | United States | |||
157 | Banana | Fruit | ৳ 7,090.00 | 11-09-12 | France | |||
158 | Banana | Fruit | ৳ 7,880.00 | 15-09-12 | United States | |||
159 | Orange | Fruit | ৳ 3,861.00 | 18-09-12 | United States | |||
160 | Broccoli | Vegetables | ৳ 7,927.00 | 19-09-12 | Germany | |||
161 | Banana | Fruit | ৳ 6,162.00 | 20-09-12 | United States | |||
162 | Mango | Fruit | ৳ 5,523.00 | 25-09-12 | Australia | |||
163 | Broccoli | Vegetables | ৳ 5,936.00 | 25-09-12 | United Kingdom | |||
164 | Carrots | Vegetables | ৳ 7,251.00 | 26-09-12 | Germany | |||
165 | Orange | Fruit | ৳ 6,187.00 | 27-09-12 | Australia | |||
166 | Banana | Fruit | ৳ 3,210.00 | 29-09-12 | Germany | |||
167 | Carrots | Vegetables | ৳ 682.00 | 29-09-12 | Germany | |||
168 | Banana | Fruit | ৳ 793.00 | 03-10-12 | Australia | |||
169 | Carrots | Vegetables | ৳ 5,346.00 | 04-10-12 | Germany | |||
170 | Banana | Fruit | ৳ 7,103.00 | 07-10-12 | New Zealand | |||
171 | Carrots | Vegetables | ৳ 4,603.00 | 10-10-12 | United States | |||
172 | Apple | Fruit | ৳ 8,160.00 | 16-10-12 | France | |||
173 | Apple | Fruit | ৳ 7,171.00 | 23-10-12 | United Kingdom | |||
174 | Banana | Fruit | ৳ 3,552.00 | 23-10-12 | New Zealand | |||
175 | Banana | Fruit | ৳ 7,273.00 | 25-10-12 | Australia | |||
176 | Banana | Fruit | ৳ 2,402.00 | 26-10-12 | Germany | |||
177 | Banana | Fruit | ৳ 1,197.00 | 26-10-12 | Australia | |||
178 | Beans | Vegetables | ৳ 5,015.00 | 26-10-12 | Australia | |||
179 | Orange | Fruit | ৳ 5,818.00 | 02-11-12 | United States | |||
180 | Banana | Fruit | ৳ 4,399.00 | 03-11-12 | United Kingdom | |||
181 | Carrots | Vegetables | ৳ 3,011.00 | 03-11-12 | United States | |||
182 | Apple | Fruit | ৳ 4,715.00 | 09-11-12 | United Kingdom | |||
183 | Apple | Fruit | ৳ 5,321.00 | 12-11-12 | France | |||
184 | Banana | Fruit | ৳ 8,894.00 | 15-11-12 | United States | |||
185 | Carrots | Vegetables | ৳ 4,846.00 | 25-11-12 | United Kingdom | |||
186 | Broccoli | Vegetables | ৳ 284.00 | 25-11-12 | Germany | |||
187 | Orange | Fruit | ৳ 8,283.00 | 26-11-12 | United Kingdom | |||
188 | Orange | Fruit | ৳ 9,990.00 | 28-11-12 | Canada | |||
189 | Banana | Fruit | ৳ 9,014.00 | 28-11-12 | Australia | |||
190 | Apple | Fruit | ৳ 1,942.00 | 29-11-12 | France | |||
191 | Banana | Fruit | ৳ 7,223.00 | 30-11-12 | United States | |||
192 | Carrots | Vegetables | ৳ 4,673.00 | 02-12-12 | United States | |||
193 | Carrots | Vegetables | ৳ 9,104.00 | 04-12-12 | France | |||
194 | Apple | Fruit | ৳ 6,078.00 | 05-12-12 | United States | |||
195 | Beans | Vegetables | ৳ 3,278.00 | 06-12-12 | Germany | |||
196 | Banana | Fruit | ৳ 136.00 | 12-12-12 | Canada | |||
197 | Banana | Fruit | ৳ 8,377.00 | 12-12-12 | Australia | |||
198 | Banana | Fruit | ৳ 2,382.00 | 12-12-12 | United States | |||
199 | Banana | Fruit | ৳ 8,702.00 | 15-12-12 | Germany | |||
200 | Banana | Fruit | ৳ 5,021.00 | 16-12-12 | United States | |||
201 | Apple | Fruit | ৳ 1,760.00 | 16-12-12 | Australia | |||
202 | Banana | Fruit | ৳ 4,766.00 | 18-12-12 | Germany | |||
203 | Beans | Vegetables | ৳ 1,541.00 | 19-12-12 | United Kingdom | |||
204 | Orange | Fruit | ৳ 2,782.00 | 20-12-12 | United Kingdom | |||
205 | Apple | Fruit | ৳ 2,455.00 | 20-12-12 | Canada | |||
206 | Apple | Fruit | ৳ 4,512.00 | 22-12-12 | New Zealand | |||
207 | Apple | Fruit | ৳ 8,752.00 | 22-12-12 | Germany | |||
208 | Carrots | Vegetables | ৳ 9,127.00 | 25-12-12 | United States | |||
209 | Apple | Fruit | ৳ 1,777.00 | 28-12-12 | France | |||
210 | Beans | Vegetables | ৳ 680.00 | 28-12-12 | France | |||
211 | Orange | Fruit | ৳ 958.00 | 29-12-12 | United States | |||
212 | Carrots | Vegetables | ৳ 2,613.00 | 29-12-12 | Australia | |||
213 | Carrots | Vegetables | ৳ 339.00 | 30-12-12 | Australia |