TechNet - PowerPoint PPT Presentation

1 / 370

About This Presentation

Title:

TechNet

Description:

TechNet – PowerPoint PPT presentation

Number of Views:75

Avg rating:3.0/5.0

Slides: 371

Provided by: downloadM

Category:

more less

Transcript and Presenter's Notes

Title: TechNet

1
???? TechNet ????
TechNet ????
2
????

????????????????????? ???

3
??????????????

??? Microsoft Office SharePoint Server 2007 ?????
?? Microsoft Office Excel 2007 ????

3
4
???????

??????????????,?????????????????????????????????,?
???????,????????????

4
5
MOSS ???????

Excel ??
??????
????????
????
???
??????(KPI)

5
6
Excel ????

??????????? Excel 2007 ??? ???????,???????????????
????????
????????????,??????????????
???? 1 ???????????
????????????????
????????????????????
???????????????????????,???????????

6
7
Excel ???????

Excel Calculation Services(ECS)
Excel Services ?????,?????????????????????????????
?
Excel Web Access(EWA)????
???? Excel ??????????,????????? Microsoft Office
Excel ??
Excel Web Services API
Excel Web Services ? MOSS 2007 ?? Web
??,??????????????????????,??????????

7
8
Excel ??????
8
9
(No Transcript)
10
10
11
(No Transcript)
12
(No Transcript)
13
(No Transcript)
14
)
????????????????????
14
15

???????????????????
Shift ??????,?????End???Home?,?????????????????

16
????????????????,???????????????
17
(No Transcript)
18
(No Transcript)
19
(No Transcript)
20
ISERROR(FIND(A1,C3)gt0)
20
21
(No Transcript)
22
(No Transcript)
23
(No Transcript)
24
(No Transcript)
25
(No Transcript)
26
??????????????!
gt
27
???????? SQL ???????????!
gt
28
(No Transcript)
29
(No Transcript)
30
30
31
????????? Excel ????,???????? Excel ????????
)
32
(No Transcript)
33
(No Transcript)
34
)
?!???????????????!
35
Excel Services ???????

???? Excel Calculation Services ??????????????
MOSS 2007 ??
??????(UNC)??
HTTP ??
???????????? Excel Services ???????

35
36
(No Transcript)
37
(No Transcript)
38

???????????????,??????????????????????????????????
????????,???? ECS ? Process ?????????????????
????????????????????,????? IPsec ? SSL,??? Excel
Calculation Services ?????????????????????????????
??????

? Web Front End ??????????,?????????? ECS ???
??? URLWFE ??? Excel ???? URL ?????? ECS,????
Excel ????????????? ECS
??????WFE ????????? ECS ????????
?????? WFE ? ECS ?,????,?????????? ECS

40
????(Session)? SharePoint Server
?????????????,??????????ECS ??????,???????????????
????????
40
41
???? ECS ?????????????????????????????????????????
?
42
???? ECS ????,?????????ECS ?????????,??????,??????
??,??????? windir\ TEMP\Excel
Server\FileCache\ltSSP Namegt,?????????????? 40
GB????????,???????,?????????,??????????,??????????
?
43
??????????????????????????????????
44
(No Transcript)
45
(No Transcript)
46
???? Excel Calculation Services
?????????????????????????????????(??????????)?????
???????
47

????????? Excel ????????????????,??????????????
????????????????,??????????????
??????????????????????

???? ECS ????????????????????????
48
?? Excel ???????????????????????????????
49
??????????????????????????????????????????????????
????????
????????????????
50
???????????????? Excel ??????!
gt
50
51
(No Transcript)
52
(No Transcript)
53
???????? Excel ???,???????????????????
)
54
(No Transcript)
55
(No Transcript)
56
(No Transcript)
57
(No Transcript)
58
(No Transcript)
59
??????????????????????????? Excel
??????,?????????????
)
60
??

????? Excel Services ???? Excel
????????,?????????,?????????,?????????????????????
???????,?????????
????????????????????
???????????????????????
????????????????
????????????????????,???????????

60
61
(No Transcript)
62
(No Transcript)
63
(No Transcript)
64
(No Transcript)
65
(No Transcript)
66
(No Transcript)
67
(No Transcript)
68
(No Transcript)
69
(No Transcript)
70
70
71
(No Transcript)
72
(No Transcript)
73

???????????????
Tables?Charts ?PivotTables ?PivotCharts ? Named
Ranges

74
(No Transcript)
75
(No Transcript)
76
(No Transcript)
77
(No Transcript)
78
(No Transcript)
79
(No Transcript)
80
80
81
?????????!???????????!
82
(No Transcript)
83
(No Transcript)
84
(No Transcript)
85
(No Transcript)
86
YA!???????????,????????????!
8
87
)
?? Excel ??????,?????????????????
87
88
(No Transcript)
89
(No Transcript)
90
90
91
(No Transcript)
92
(No Transcript)
93
?????????????????,????????????,?????????,?????????
94
(No Transcript)
95
(No Transcript)
96
(No Transcript)
97
(No Transcript)
98
(No Transcript)
99
(No Transcript)
100
100
101
(No Transcript)
102
(No Transcript)
103
(No Transcript)
104
(No Transcript)
105
(No Transcript)
106
(No Transcript)
107
(No Transcript)
108
(No Transcript)
109
(No Transcript)
110
110
111
(No Transcript)
112
(No Transcript)
113
(No Transcript)
114
(No Transcript)
115
(No Transcript)
116
(No Transcript)
117
(No Transcript)
118
(No Transcript)
119
(No Transcript)
120
120
121
(No Transcript)
122
?? Excel 2007,??????????,????????????,????????????
????????!
123
(No Transcript)
124
(No Transcript)
125
(No Transcript)
126
(No Transcript)
127
(No Transcript)
128
(No Transcript)
129
(No Transcript)
130
130
131
(No Transcript)
132
(No Transcript)
133
(No Transcript)
134
(No Transcript)
135
(No Transcript)
136
(No Transcript)
137
(No Transcript)
138
(No Transcript)
139
(No Transcript)
140
????????????????????,????????? Excel ?????
)
140
141

? Excel ?????????????,?????????????
? Excel ?????????????,????????????? ????????,????
?????
???????????? ????????
?????????????????????????????

142
(No Transcript)
143
???,??????????????? Excel ???????Excel ????
gt
144
(No Transcript)
145
(No Transcript)
146
???????????????,????????? Excel ??????????
147
(No Transcript)
148
(No Transcript)
149
?? Excel ?????????????????,????????????????????
)
150
Excel Web Access ????

???? Excel ??????????
???????? Excel ??
????????????????
?????????????????,??????? Excel ?????

150
151
(No Transcript)
152
(No Transcript)
153
(No Transcript)
154
(No Transcript)
155
(No Transcript)
156
(No Transcript)
157
(No Transcript)
158
(No Transcript)
159
????? Excel Web Access ???????????? URL ? UNC ??
160
160
161
(No Transcript)
162
(No Transcript)
163
(No Transcript)
164
??????????,?????????????????
)
165
??????

????????????????
MOSS 2007 ?? 10 ???????
?????????????????????,????????????????
????????????????????????????,????????
???????????,?????????

165
166
?????????????

??????????????????
???????????
???????????????????????(??)

166
167
?? 1??????????????????
168
(No Transcript)
169
?? 2???????????
170
170
171
?? 3???????????????????????
172
????????????????????????????
173
(No Transcript)
174
(No Transcript)
175
(No Transcript)
176
?????????????!????
177
(No Transcript)
178
(No Transcript)
179
(No Transcript)
180
180
181
(No Transcript)
182
(No Transcript)
183
(No Transcript)
184
(No Transcript)
185
?!????,??????????!
186
(No Transcript)
187
(No Transcript)
188
)
?????????????,???????????!???????????,????????????
???
188
189
(No Transcript)
190
190
191
?? 1??????????????????
192
?????????????????????????????
193
(No Transcript)
194
?? 2???????????
195
(No Transcript)
196
?? 3???????????????????????
197
(No Transcript)
198
(No Transcript)
199
(No Transcript)
200
200
201
??????? Cache ?!?????!
202
(No Transcript)
203
(No Transcript)
204
?!??????!????? Excel ???,???????!
8
205
)
??? Excel ????????????,???? Excel Web Access
???????,????????????????? Excel
???????????,???????????????
205
206
(No Transcript)
207
(No Transcript)
208
(No Transcript)
209
(No Transcript)
210
210
211
(No Transcript)
212
(No Transcript)
213
???????? Excel Web Access ????????????????????????
????????????????
214
(No Transcript)
215
(No Transcript)
216
(No Transcript)
217
???????????? Excel Web Access ??????
)
218
(No Transcript)
219
8
?????????,?????? ......
220
220
221
(No Transcript)
222
??????? SD ? SE ??????!
8
223
(No Transcript)
224
8
??????? SD ? SE ??????!?????!
225
)
Excel ??????????? SQL ???,????????????,???????????
??? MOSS 2007 ? Excel Service ??,????????
225
226
????????

??????????????????
Excel ?????????????
SQL ???? SharePoint ??????????,????????????(??
SAP ? Siebel)?? .
????????????,???????????????????????????,?????????
???
?????????????,??????????????
??????????????????????????

226
227
(No Transcript)
228
(No Transcript)
229
(No Transcript)
230
230
231
(No Transcript)
232
(No Transcript)
233
(No Transcript)
234
(No Transcript)
235
(No Transcript)
236
(No Transcript)
237
(No Transcript)
238
(No Transcript)
239
239
240
(No Transcript)
241
(No Transcript)
242
(No Transcript)
243
(No Transcript)
244
(No Transcript)
245
????????,?? Excel Services ??? Query Table
246
(No Transcript)
247
(No Transcript)
248
(No Transcript)
249
(No Transcript)
250
250
251
(No Transcript)
252
(No Transcript)
253
(No Transcript)
254
(No Transcript)
255
(No Transcript)
256
(No Transcript)
257
????????? 2002?2003 ? 2004 ???????,??????
)
258
(No Transcript)
259
(No Transcript)
260
260
261
(No Transcript)
262
(No Transcript)
263
(No Transcript)
264
(No Transcript)
265
(No Transcript)
266
(No Transcript)
267
(No Transcript)
268
(No Transcript)
269
(No Transcript)
270
270
271
(No Transcript)
272
??????!????????????!
273
)
?????????,????????????
273
274
(No Transcript)
275
?!??????!???????
)
276
Excel Services ????????

?? Excel Calculation Services ????????????
???????????? Excel Services ????????

276
277
(No Transcript)
278
(No Transcript)
279
(No Transcript)
280
280
281
(No Transcript)
282
(No Transcript)
283
(No Transcript)
284
(No Transcript)
285
(No Transcript)
286
(No Transcript)
287
(No Transcript)
288
(No Transcript)
289
)
??????????????????,???????
289
290
290
291
(No Transcript)
292
(No Transcript)
293
(No Transcript)
294
(No Transcript)
295
(No Transcript)
296
(No Transcript)
297
(No Transcript)
298
(No Transcript)
299
(No Transcript)
300
300
301
(No Transcript)
302
Excel ????????????????
)
303
?????
?????
???
304
Excel ????????

??? Excel 2007 ??????? Excel 2007 ????(.xls)
????????
????????????
???????????????????????? .
?????????
HyperLink?RTD?SQL.Request?Char?Cell?Info .
????????????
?????????????????????????? .
..

304
305
????

???????????????????
?????????????????
???????????????????????
????????????????,?????????????????
?????????????????????

305
306
(No Transcript)
307
(No Transcript)
308
(No Transcript)
309
(No Transcript)
310
(No Transcript)
311
(No Transcript)
312
?????????,?????????????????
313
(No Transcript)
314
(No Transcript)
315
gt
?????????!
316
(No Transcript)
317
???

MOSS 2007 ??????????,?????????????????????????
??????????????????
???????????????????

317
318
(No Transcript)
319
(No Transcript)
320
320
321
(No Transcript)
322
(No Transcript)
323
(No Transcript)
324
(No Transcript)
325
(No Transcript)
326
(No Transcript)
327
(No Transcript)
328
gt
?????????????!
329
??????

???????(Peter Drucker)?????????(KPI)?????????????
????
MOSS 2007 ? KPI ??
?? SharePoint ??????
?? Microsoft Office Excel ???????
?? Microsoft SQL Server 2005 Analysis Services
???
?????????

329
330
330
331
(No Transcript)
332
(No Transcript)
333
(No Transcript)
334
(No Transcript)
335
(No Transcript)
336
???????? 75 ?,?? ? ????? 60 ?,?? ? ??????? ?
337
(No Transcript)
338
(No Transcript)
339
(No Transcript)
340
340
341
???????? 10 ?,?? ? ????? 20 ?,?? ? ??????? ?
342
(No Transcript)
343
(No Transcript)
344
??????????????
345
(No Transcript)
346
(No Transcript)
347
(No Transcript)
348
???????? 400,000 ?,?? ? ????? 250,000 ?,??
? ??????? ?
349
(No Transcript)
350
350
351
(No Transcript)
352
(No Transcript)
353
(No Transcript)
354
(No Transcript)
355
(No Transcript)
356
(No Transcript)
357
(No Transcript)
358
(No Transcript)
359
(No Transcript)
360
360
361
(No Transcript)
362
(No Transcript)
363
(No Transcript)
364
(No Transcript)
365
(No Transcript)
366
????