Xem mẫu
- DƯ LIÊU NHÂP
̃ ̣ ̣
NGAY
̀ ̉ ̉
SAN PHÂM KHACH HANG
́ ̀ SÔ TIÊN
́ ̀ QUÝ
1/1/2012 ̉ ̉
San phâm 14 Fabrikam, Inc. 39,228,800.00 ₫ QUY 1
́
1/3/2012 ̉ ̉
San phâm 23 Alpine Ski House 83,657,600.00 ₫ QUY 1
́
1/4/2012 ̉ ̉
San phâm 18 Coho Winery 169,395,200.00 ₫ QUY 1
́
1/7/2012 ̉ ̉
San phâm 10 Southridge Video 166,441,600.00 ₫ QUY 1
́
1/11/2012 ̉ ̉
San phâm 7 Coho Winery 132,953,600.00 ₫ QUY 1
́
1/25/2012 ̉ ̉
San phâm 1 Contoso, Ltd 134,035,200.00 ₫ QUY 1
́
1/30/2012 ̉ ̉
San phâm 27 Southridge Video 57,657,600.00 ₫ QUY 1
́
2/4/2012 ̉ ̉
San phâm 30 City Power & Light 180,419,200.00 ₫ QUY 1
́
2/5/2012 ̉ ̉
San phâm 16 A. Datum Corporation 48,505,600.00 ₫ QUY 1
́
2/8/2012 ̉ ̉
San phâm 21 Alpine Ski House 111,696,000.00 ₫ QUY 1
́
2/10/2012 ̉ ̉
San phâm 6 City Power & Light 36,774,400.00 ₫ QUY 1
́
2/17/2012 ̉ ̉
San phâm 24 Coho Winery 113,859,200.00 ₫ QUY 1
́
2/22/2012 ̉ ̉
San phâm 28 Fabrikam, Inc. 72,675,200.00 ₫ QUY 1
́
2/24/2012 ̉ ̉
San phâm 22 City Power & Light 30,867,200.00 ₫ QUY 1
́
2/29/2012 ̉ ̉
San phâm 26 Humongous Insurance 113,443,200.00 ₫ QUY 1
́
3/1/2012 ̉ ̉
San phâm 15 City Power & Light 47,964,800.00 ₫ QUY 1
́
3/8/2012 ̉ ̉
San phâm 9 A. Datum Corporation 179,961,600.00 ₫ QUY 1
́
3/14/2012 ̉ ̉
San phâm 16 Alpine Ski House 74,755,200.00 ₫ QUY 1
́
3/31/2012 ̉ ̉
San phâm 28 City Power & Light 189,904,000.00 ₫ QUY 1
́
4/3/2012 ̉ ̉
San phâm 28 Southridge Video 207,708,800.00 ₫ QUY 2
́
4/9/2012 ̉ ̉
San phâm 2 Fabrikam, Inc. 172,016,000.00 ₫ QUY 2
́
4/10/2012 ̉ ̉
San phâm 30 A. Datum Corporation 107,827,200.00 ₫ QUY 2
́
4/11/2012 ̉ ̉
San phâm 25 Contoso, Ltd 196,060,800.00 ₫ QUY 2
́
4/11/2012 ̉ ̉
San phâm 15 Humongous Insurance 83,449,600.00 ₫ QUY 2
́
4/15/2012 ̉ ̉
San phâm 28 Coho Winery 160,659,200.00 ₫ QUY 2
́
5/3/2012 ̉ ̉
San phâm 21 Northwind Traders 47,091,200.00 ₫ QUY 2
́
5/4/2012 ̉ ̉
San phâm 30 Coho Winery 194,979,200.00 ₫ QUY 2
́
5/5/2012 ̉ ̉
San phâm 17 Humongous Insurance 76,793,600.00 ₫ QUY 2
́
5/5/2012 ̉ ̉
San phâm 28 Humongous Insurance 189,779,200.00 ₫ QUY 2
́
5/19/2012 ̉ ̉
San phâm 22 Humongous Insurance 103,209,600.00 ₫ QUY 2
́
5/22/2012 ̉ ̉
San phâm 8 A. Datum Corporation 190,652,800.00 ₫ QUY 2
́
5/31/2012 ̉ ̉
San phâm 16 Coho Winery 116,688,000.00 ₫ QUY 2
́
6/2/2012 ̉ ̉
San phâm 8 City Power & Light 69,097,600.00 ₫ QUY 2
́
6/2/2012 ̉ ̉
San phâm 3 Humongous Insurance 53,913,600.00 ₫ QUY 2
́
Page 1 of 6
- NGAY
̀ ̉ ̉
SAN PHÂM KHACH HANG
́ ̀ SÔ TIÊN
́ ̀ QUÝ
6/4/2012 ̉ ̉
San phâm 13 Contoso, Ltd 92,435,200.00 ₫ QUY 2
́
6/9/2012 ̉ ̉
San phâm 10 Southridge Video 149,052,800.00 ₫ QUY 2
́
6/12/2012 ̉ ̉
San phâm 13 Fabrikam, Inc. 104,166,400.00 ₫ QUY 3
́
6/26/2012 ̉ ̉
San phâm 2 Contoso, Ltd 74,422,400.00 ₫ QUY 3
́
6/29/2012 ̉ ̉
San phâm 22 Southridge Video 23,795,200.00 ₫ QUY 3
́
7/2/2012 ̉ ̉
San phâm 14 Alpine Ski House 76,876,800.00 ₫ QUY 3
́
7/6/2012 ̉ ̉
San phâm 14 Coho Winery 147,347,200.00 ₫ QUY 3
́
7/6/2012 ̉ ̉
San phâm 2 City Power & Light 96,553,600.00 ₫ QUY 3
́
7/8/2012 ̉ ̉
San phâm 5 Fabrikam, Inc. 126,422,400.00 ₫ QUY 3
́
7/10/2012 ̉ ̉
San phâm 9 Alpine Ski House 49,795,200.00 ₫ QUY 3
́
7/15/2012 ̉ ̉
San phâm 13 Southridge Video 114,732,800.00 ₫ QUY 3
́
7/16/2012 ̉ ̉
San phâm 8 Fabrikam, Inc. 40,518,400.00 ₫ QUY 3
́
7/19/2012 ̉ ̉
San phâm 28 Contoso, Ltd 151,424,000.00 ₫ QUY 3
́
7/29/2012 ̉ ̉
San phâm 26 A. Datum Corporation 193,273,600.00 ₫ QUY 3
́
8/19/2012 ̉ ̉
San phâm 26 Fabrikam, Inc. 122,054,400.00 ₫ QUY 3
́
8/19/2012 ̉ ̉
San phâm 6 Northwind Traders 85,238,400.00 ₫ QUY 3
́
8/20/2012 ̉ ̉
San phâm 13 A. Datum Corporation 26,416,000.00 ₫ QUY 3
́
8/20/2012 ̉ ̉
San phâm 23 A. Datum Corporation 161,075,200.00 ₫ QUY 3
́
8/24/2012 ̉ ̉
San phâm 2 Humongous Insurance 114,150,400.00 ₫ QUY 3
́
8/24/2012 ̉ ̉
San phâm 5 Southridge Video 144,435,200.00 ₫ QUY 3
́
8/25/2012 ̉ ̉
San phâm 20 Fabrikam, Inc. 92,643,200.00 ₫ QUY 3
́
8/27/2012 ̉ ̉
San phâm 13 City Power & Light 147,680,000.00 ₫ QUY 3
́
8/30/2012 ̉ ̉
San phâm 8 Humongous Insurance 90,396,800.00 ₫ QUY 3
́
9/1/2012 ̉ ̉
San phâm 25 Alpine Ski House 42,265,600.00 ₫ QUY 3
́
9/17/2012 ̉ ̉
San phâm 20 Contoso, Ltd 48,422,400.00 ₫ QUY 3
́
9/22/2012 ̉ ̉
San phâm 18 Humongous Insurance 126,672,000.00 ₫ QUY 3
́
9/25/2012 ̉ ̉
San phâm 19 Coho Winery 173,555,200.00 ₫ QUY 3
́
9/29/2012 ̉ ̉
San phâm 11 Alpine Ski House 122,137,600.00 ₫ QUY 3
́
9/30/2012 ̉ ̉
San phâm 25 Humongous Insurance 32,822,400.00 ₫ QUY 3
́
10/2/2012 ̉ ̉
San phâm 29 City Power & Light 35,651,200.00 ₫ QUY 4
́
10/5/2012 ̉ ̉
San phâm 11 Fabrikam, Inc. 118,892,800.00 ₫ QUY 4
́
10/6/2012 ̉ ̉
San phâm 21 Coho Winery 171,475,200.00 ₫ QUY 4
́
10/14/2012 ̉ ̉
San phâm 11 A. Datum Corporation 184,870,400.00 ₫ QUY 4
́
10/14/2012 ̉ ̉
San phâm 23 City Power & Light 196,310,400.00 ₫ QUY 4
́
11/9/2012 ̉ ̉
San phâm 14 Southridge Video 129,584,000.00 ₫ QUY 4
́
11/13/2012 ̉ ̉
San phâm 17 A. Datum Corporation 88,982,400.00 ₫ QUY 4
́
Page 2 of 6
- NGAY
̀ ̉ ̉
SAN PHÂM KHACH HANG
́ ̀ SÔ TIÊN
́ ̀ QUÝ
11/17/2012 ̉ ̉
San phâm 6 Alpine Ski House 113,110,400.00 ₫ QUY 4
́
11/22/2012 ̉ ̉
San phâm 1 Coho Winery 139,942,400.00 ₫ QUY 4
́
11/25/2012 ̉ ̉
San phâm 30 Fabrikam, Inc. 207,833,600.00 ₫ QUY 4
́
11/25/2012 ̉ ̉
San phâm 26 Northwind Traders 176,009,600.00 ₫ QUY 4
́
11/27/2012 ̉ ̉
San phâm 11 Contoso, Ltd 164,944,000.00 ₫ QUY 4
́
11/30/2012 ̉ ̉
San phâm 30 Northwind Traders 169,228,800.00 ₫ QUY 4
́
12/2/2012 ̉ ̉
San phâm 13 Humongous Insurance 129,209,600.00 ₫ QUY 4
́
12/5/2012 ̉ ̉
San phâm 3 Contoso, Ltd 102,876,800.00 ₫ QUY 4
́
12/5/2012 ̉ ̉
San phâm 3 Southridge Video 177,923,200.00 ₫ QUY 4
́
12/10/2012 ̉ ̉
San phâm 24 Northwind Traders 93,766,400.00 ₫ QUY 4
́
12/21/2012 ̉ ̉
San phâm 7 Humongous Insurance 151,840,000.00 ₫ QUY 4
́
12/24/2012 ̉ ̉
San phâm 17 Fabrikam, Inc. 172,473,600.00 ₫ QUY 4
́
12/26/2012 ̉ ̉
San phâm 26 Alpine Ski House 203,465,600.00 ₫ QUY 4
́
1/3/2013 ̉ ̉
San phâm 19 Fabrikam, Inc. 166,899,200.00 ₫ QUY 1
́
1/4/2013 ̉ ̉
San phâm 22 A. Datum Corporation 78,166,400.00 ₫ QUY 1
́
Page 3 of 6
- MEO:
̣
BAO CAO KINH DOANH
́ ́ ̉
Tùy chinh PivotTable na
PivotTable đê ki
̉ ̣ ̉ ̣
̀y cho phù hợp với nhu cầu cua ban! Chon môt ô trong
̉ ́ch hoat ngăn Danh sa
̣
kéo đê thêm, loai bo hoăc să
̉ ̣ ̣ ̣
́ch Trường PivotTable. Sau đó ở ngăn tác vu, ̣
̣ ́c trường. Ví du, ke
́p xếp lai ca ̣ ́o trường San phâm lên
̉ ̉
trên trường Khách hàng đê co ̉ ́ cái nhìn khác. Đê câp nhât d
̉ ̣ ̣ ữ liêu PivotTable, ha
̣ ̃y
Sum - SỐ TIỀN Years QUÝ ̉ ̣
bấm phai chuôt trong PivotTable sau đo ́ bấm Là m mớ i.
2012 2013 Total Result
SẢN PHẨM KHÁCH HÀNG QÚY 1 QUÝ 2 QUÝ 3 QUÝ 4 QÚY 1
Sản phẩm 1
Coho Winery ### 139,942,400.00 ₫
Contoso, Ltd ### 134,035,200.00 ₫
Sản phẩm 10
Southridge Video ### ### 315,494,400.00 ₫
Sản phẩm 11
A. Datum Corporation ### 184,870,400.00 ₫
Alpine Ski House ### 122,137,600.00 ₫
Contoso, Ltd ### 164,944,000.00 ₫
Fabrikam, Inc. ### 118,892,800.00 ₫
Sản phẩm 13
A. Datum Corporation 26,416,000.00 ₫ 26,416,000.00 ₫
City Power & Light ### 147,680,000.00 ₫
Contoso, Ltd 92,435,200.00 ₫ 92,435,200.00 ₫
Fabrikam, Inc. ### 104,166,400.00 ₫
Humongous Insurance ### 129,209,600.00 ₫
Southridge Video ### 114,732,800.00 ₫
Sản phẩm 14
Alpine Ski House 76,876,800.00 ₫ 76,876,800.00 ₫
Coho Winery ### 147,347,200.00 ₫
Fabrikam, Inc. 39,228,800.00 ₫ 39,228,800.00 ₫
Southridge Video ### 129,584,000.00 ₫
Sản phẩm 15
City Power & Light 47,964,800.00 ₫ 47,964,800.00 ₫
Humongous Insurance 83,449,600.00 ₫ 83,449,600.00 ₫
Sản phẩm 16
A. Datum Corporation
48,505,600.00 ₫ 48,505,600.00 ₫
Alpine Ski House 74,755,200.00 ₫ 74,755,200.00 ₫
Coho Winery ### 116,688,000.00 ₫
Sản phẩm 17
A. Datum Corporation 88,982,400.00 ₫ 88,982,400.00 ₫
Fabrikam, Inc. ### 172,473,600.00 ₫
Humongous Insurance 76,793,600.00 ₫ 76,793,600.00 ₫
Sản phẩm 18
Coho Winery ### 169,395,200.00 ₫
Humongous Insurance ### 126,672,000.00 ₫
Sản phẩm 19
Coho Winery ### 173,555,200.00 ₫
Fabrikam, Inc. ### 166,899,200.00 ₫
Sản phẩm 2
City Power & Light 96,553,600.00 ₫ 96,553,600.00 ₫
Contoso, Ltd 74,422,400.00 ₫ 74,422,400.00 ₫
Fabrikam, Inc. ### 172,016,000.00 ₫
Humongous Insurance ### 114,150,400.00 ₫
Sản phẩm 20
Contoso, Ltd 48,422,400.00 ₫ 48,422,400.00 ₫
Fabrikam, Inc. 92,643,200.00 ₫ 92,643,200.00 ₫
Sản phẩm 21
Alpine Ski House ### 111,696,000.00 ₫
Coho Winery ### 171,475,200.00 ₫
Northwind Traders 47,091,200.00 ₫ 47,091,200.00 ₫
Sản phẩm 22
A. Datum Corporation 78,166,400.00 ₫ 78,166,400.00 ₫
City Power & Light 30,867,200.00 ₫ 30,867,200.00 ₫
Humongous Insurance ### 103,209,600.00 ₫
Page 4 of 6
- MEO:
̣
̉
Tùy chinh PivotTable na ̀y cho phù hợp với nhu cầu cua ban! Chon môt ô trong
̉ ̣ ̣ ̣
̉ ́ch hoat ngăn Danh sa
PivotTable đê ki ̣ ́ch Trường PivotTable. Sau đó ở ngăn tác vu, ̣
̉ ̣ ̉ ̣
kéo đê thêm, loai bo hoăc să ̣ ́c trường. Ví du, ke
́p xếp lai ca ̣ ́o trường San phâm lên
̉ ̉
trên trường Khách hàng đê co ̉ ́ cái nhìn khác. Đê câp nhât d
̉ ̣ ̣ ữ liêu PivotTable, ha
̣ ̃y
Sum - SỐ TIỀN Years QUÝ ̉ ̣
bấm phai chuôt trong PivotTable sau đo ́ bấm Là m mớ i.
2012 2013 Total Result
Southridge Video 23,795,200.00 ₫ 23,795,200.00 ₫
Sản phẩm 23
A. Datum Corporation ### 161,075,200.00 ₫
Alpine Ski House 83,657,600.00 ₫ 83,657,600.00 ₫
City Power & Light ### 196,310,400.00 ₫
Sản phẩm 24
Coho Winery ### 113,859,200.00 ₫
Northwind Traders 93,766,400.00 ₫ 93,766,400.00 ₫
Sản phẩm 25
Alpine Ski House 42,265,600.00 ₫ 42,265,600.00 ₫
Contoso, Ltd ### 196,060,800.00 ₫
Humongous Insurance 32,822,400.00 ₫ 32,822,400.00 ₫
Sản phẩm 26
A. Datum Corporation ### 193,273,600.00 ₫
Alpine Ski House ### 203,465,600.00 ₫
Fabrikam, Inc. ### 122,054,400.00 ₫
Humongous Insurance ### 113,443,200.00 ₫
Northwind Traders ### 176,009,600.00 ₫
Sản phẩm 27
Southridge Video 57,657,600.00 ₫ 57,657,600.00 ₫
Sản phẩm 28
City Power & Light ### 189,904,000.00 ₫
Coho Winery ### 160,659,200.00 ₫
Contoso, Ltd ### 151,424,000.00 ₫
Fabrikam, Inc. 72,675,200.00 ₫ 72,675,200.00 ₫
Humongous Insurance ### 189,779,200.00 ₫
Southridge Video ### 207,708,800.00 ₫
Sản phẩm 29
City Power & Light 35,651,200.00 ₫ 35,651,200.00 ₫
Sản phẩm 3
Contoso, Ltd ### 102,876,800.00 ₫
Humongous Insurance 53,913,600.00 ₫ 53,913,600.00 ₫
Southridge Video ### 177,923,200.00 ₫
Sản phẩm 30
A. Datum Corporation ### 107,827,200.00 ₫
City Power & Light ### 180,419,200.00 ₫
Coho Winery ### 194,979,200.00 ₫
Fabrikam, Inc. ### 207,833,600.00 ₫
Northwind Traders ### 169,228,800.00 ₫
Sản phẩm 5
Fabrikam, Inc. ### 126,422,400.00 ₫
Southridge Video ### 144,435,200.00 ₫
Sản phẩm 6
Alpine Ski House ### 113,110,400.00 ₫
City Power & Light 36,774,400.00 ₫ 36,774,400.00 ₫
Northwind Traders 85,238,400.00 ₫ 85,238,400.00 ₫
Sản phẩm 7
Coho Winery ### 132,953,600.00 ₫
Humongous Insurance ### 151,840,000.00 ₫
Sản phẩm 8
A. Datum Corporation ### 190,652,800.00 ₫
City Power & Light 69,097,600.00 ₫ 69,097,600.00 ₫
Fabrikam, Inc. 40,518,400.00 ₫ 40,518,400.00 ₫
Humongous Insurance 90,396,800.00 ₫ 90,396,800.00 ₫
Sản phẩm 9
A. Datum Corporation ### 179,961,600.00 ₫
Alpine Ski House 49,795,200.00 ₫ 49,795,200.00 ₫
Total Result ### ### ### ### ### ###
Page 5 of 6
- DANH SACH D
́ Ư LIÊU
̃ ̣
SAN PHÂM
̉ ̉ KHACH HANG
́ ̀
MEO:
̣
̉ ̣ ̉ ̉ ̣
Đê thêm môt san phâm hoăc kha ́ch hàng mới, hãy bắt
̉ ̉
San phâm 1 A. Datum Corporation ̣ ̉
đầu nhâp bang d ưới đây và nó sẽ tự đông m
̣ ở rông khi
̣
̉ ̉
San phâm 2 Adventure Works
̣
ban nhâ ̣
́n phím Enter hoăc phi ́m Tab.
̉ ̉
San phâm 3 Alpine Ski House
̉ ̉
San phâm 4 Blue Yonder Airlines
̉ ̉
San phâm 5 City Power & Light
̉ ̉
San phâm 6 Coho Vineyard
̉ ̉
San phâm 7 Coho Winery
̉ ̉
San phâm 8 Coho Vineyard & Winery
̉ ̉
San phâm 9 Contoso, Ltd
̉ ̉
San phâm 10 Contoso Pharmaceuticals
̉ ̉
San phâm 11 Consolidated Messenger
̉ ̉
San phâm 12 Fabrikam, Inc.
̉ ̉
San phâm 13 Fourth Coffee
̉ ̉
San phâm 14 ̣ ́ ́ ̀ ̣
Viên Thiêt kê Đô hoa
̉ ̉
San phâm 15 Humongous Insurance
̉ ̉
San phâm 16 Litware, Inc.
̉ ̉
San phâm 17 Lucerne Publishing
̉ ̉
San phâm 18 Margie's Travel
̉ ̉
San phâm 19 Northwind Traders
̉ ̉
San phâm 20 Proseware, Inc.
̉ ̉
San phâm 21 Trương My thuât
̀ ̃ ̣
̉ ̉
San phâm 22 Southridge Video
̉ ̉
San phâm 23 Tailspin Toys
̉ ̉
San phâm 24 Trey Research
̉ ̉
San phâm 25 ̣ ̣
Công ty Điên thoai
̉ ̉
San phâm 26 Wide World Importers
̉ ̉
San phâm 27 Wingtip Toys
̉ ̉
San phâm 28 Woodgrove Bank
̉ ̉
San phâm 29
̉ ̉
San phâm 30
Page 6 of 6
nguon tai.lieu . vn