泦
- 1. ڣPC 泦
- 2. Ŀ 1. ExcelȤϺΤ 2. Excelλ昋 3. ExcelǺΤǤ뤫 ǩ` Ӌ դ 4. Excelλ ֤ ֤? ιxk 5. ExcelʹäƤߤ褦 ٥Ȥβμɤ ٣ ȥҊLʂ ٣ L ٣ Υȥ̫֤ˤ ٣ ҊαɫBˤ ٣ ηߤ루ޥǥɥå뷽 ٣ ٥Ȥβμߥǩ` ӋCܤʹäƤߤ褦 դäƤߤ褦 6. ǩ`K椨Ƥߤ褦 ե륿`CܤʹäƤߤ褦 1
- 3. 1.ExcelȤϺΤ ExcelȤMicrosoftuαӋ㥽եȤǤ ? zՈʤɤӛ똔ʽ ? μڎһEʤɤΥǩ`ӛh ǩ` ? ʽ줿ǩ`һΥ`ǁK椨ꡢǩ`? ꤷƥǩ` Ӌ ? 줿ǩ`ԄӤǼӋꡢƽꤹ뤳Ȥǡǩ` ȫĤʃA餫ˤ ? 줿ǩ`ӋYԪ˥դɤҕҙĤҊ䤹YϤ ɤ 2
- 4. 2.Excelλ昋 ٥֡ ǰܥå ڥ ݥƥ֥ з з ʽЩ` ߥ`Ҋ ܥ ۩`ࡹ롹ʤɤΥ֤ åȤ줾Υ֤ ʹCܣܥʾ ޤ ExcelDZɤФAȤʤ ΤǡΥޥФ˥ǩ` Ʊɤޤ з 줾Υκ᷽ηؤ з 줾Υοkηؤ ƥ ֥ FxkƤ륻루 ƥ֥ȺӤޤηؤ ʾޤǤϣ£ ʽЩ` Ƥ֤Ӌ ʽʾޤ `Ҋ ExcelǤϣĤΥե} `Ȥ뤳ȤǤҊ ϤåФ椨 ޤ 3
- 5. 3.ExcelCܤʤ ǩ` ٤αμ 혤ˁK椨 ٤αФǵ 项 ˤʾ Ƥޤ K椨 ǩ`γ 4 Υǩ`ˤĤƤ n}K˽B餷ޤ
- 6. 3.ExcelǺΤǤ뤫 Ӌ Ф֣Oסլ OÑκӋ ӤӋ㤷Υ ˱ʾƤޤ ƽӋ㤷 ޤ Фһ ֤ҊĤƱʾ ޤ ФһС ֤ҊĤƱʾ ޤ Ӌ ƽ С ˤ⡢ƽ?٤ꡢ ӋCܤƤޤ 5
- 9. 4.Excelλ ֤? ֤Ƥ륻 ƥ֤ˤޤ ƥ֤ˤ֥륯å ޤ ȡФǥ`뤬礷 Τǡ`λä Ӥ֤Ƥ ƥ֤ˤ״Bǡ `ܩ`ɤΡDelete`Ѻ Ƥ ע!! ƥ֤ˤơ֥륯å֤ʼȡ ǤƤ֤٤¤֤ޤ 8
- 10. 4.Excelλ ιxk xkνǤˤʤ륻 åޤ åޤޥޥ? ˄Ӥޤ ɫä֤xkƤ״ BǤҪʥɫ٤Ɖ äȤǥåޤ ιxkҪˤʤ ? }ΥƤǩ`ޤȤƥԩ`ꤹ ? }ΥαɫLɫʤɤޤȤƉ ? K椨ʤɤФrˡɤɤޤǤΥƤǩ`K 椨Τָ ? ӋФäꥰդäꤹrˡӋ䥰ɤΌȤǩ` ιָ 9
- 11. 5.ExcelʹäƤߤ褦 ٥Ȥβμɤ Excelʹäƥ٥Ȥβμ ɤƤߤޤ礦 혤ϴΤͨǤ 1. Υȥ루ٽҲμ Ҋ ݷšμգ 2. LĤ 3. ȥ̫֤ˤ 4. Ҋαɫ Bˤ 5. ηߤ{ 6. μߤΥǩ` 10
- 16. 5.ExcelʹäƤߤ褦 ٣ ηߤ루ޥǥɥå뷽 зABgФ꾀Ϥ˥ޥ `֤äƤȡΤ褦 ״ˤʤޤ åޤޥޥҤ˄Ӥ 10.6390ԥ룩ˤʤäȤ Ťޤ ͬˤBCηڤޤ礦 B BCgФ꾀å C CDgФ꾀å BCȤ10.0085ԥ룩 θߤ䤨Ȥϡͬ褦з gФ꾀å¤˥ɥå ޤ ״BǥåȡFڤA ʾޤ 15
- 25. 5.ExcelʹäƤߤ褦 ӋCܤʹäƤߤ褦 `SUMܥʹˤ⤤ʼӋǤ Ӌʽ =v죩 ӋY Ӌ Ӌ =SUM(B3:B8) 1801 B3B8ޤǤ κӋʾޤ ƽ =AVERAGE(B3: B8) 300.166 7 B3B8ޤǤ ƽʾޤ =COUNT(B3:B8) 6 B3B8ޤǤ ʾޤ =MAX(B3:B8) 559 B3B8ޤǤ Ф ֤ʾޤ С =MIN(B3:B8) 91 B3B8ޤǤ ФС ֤ʾޤ 24
- 37. 5.ExcelʹäƤߤ褦 ǩ`K椨Ƥߤ褦 K椨ɥʾޤ ǡK椨ˤĤƽhޤ ^Фǩ`Ҋ ʹä롹˥å äƤȡһϤФ ҊȤJR ФΥǩ`K 椨ޤ μߤΥǩ`֤K 椨ΌȤʤ Ȥ륭`ǡK椨 λʤˤĿxӤޤ Ǥϲμ혤ˁKى䤨 ǡμաxkޤ ǡK椨ηָޤ N혣 С֣ʮ혣ե٥å 혣 С֣ʮ혣楢ե٥å 36
- 38. 5.ExcelʹäƤߤ褦 ǩ`K椨Ƥߤ褦 K椨ɥOKܥ Ѻȡμߤμ혤ˁK 椨ޤ K椨Фrע ? ձZΈϡh֤i߷ˤäƤ ˤʤ뤳Ȥޤ ? ݷšȤΤ褦˥Εʽ СˤƤȡ҇Τ褦ʥ `뤳Ȥޤ Τ褦ˡg֤ոΤ褦ʡ ԥ``Ǥ⺆gJRǤǩ`Ǥ K椨ФޤϤˤäƤ˼ ͨˁK椨ʤȤޤ `ȤȤϡK椨 ФȤǤ 37