Excel 2007 Excel 2007 Office Professional 2007 1 90 Web http://softpress.nikkeibp.co.jp/ "BP " 6 1
Excel 2007 2 IT-Excel2007_dl.zip IT-Excel2007_dl IT-Excel2007_koushi.zip IT- Excel 2007_koushi _ _ Windows XP IT-Excel2007_dl Windows XP IT- Excel 2007_dl Windows XP IT-Excel2007 2
Excel 2007 Lesson1 p.3 1 p.4 p.5 4/252009/4/15 Lesson4 1 p.6 2 Windows XP IT-Excel2007 3 Windows XP Enter p.7 4 =12+8 p.8 p.9 B3 D4 =B3+C3+D3+B4+C4+D4 3
Excel 2007 p.9 SUM SUM =SUM 1, 2 =SUM B3:B4,C3,D4,=SUM B3:B4,50 p.9 SUM Ctrl 2 p.10 p.13 p.15 6 6 Lesson2 p.18 1 ###1E+06 p.18 4 p.18 6 p.21 Excel 4
Excel 2007 p.22 3 p.25 5 p.25 9 1 F4 p.25 1 p.26 Esc p.26 p.27 3 p.27 5
Excel 2007 Lesson3 p.32 1 D4E4 p.33 1 2 1 E4 = D4 / E4 F4 F4 $ D4E4 p.38 4 p.38 5 Tab ROUND Tab p.39 5 3 " " Lesson4 p.46 1 B6 3 p.46 6 p.47 TODAY NOW =NOW() p.48 COUNTA COUNTA COUNT A 6
Excel 2007 p.49 2 Tab p.51 4 5 6 G5 G6 G12 2 $F$5:F$12 p.54 2 AND OR p.54 3 IFAND OK OK OK IF p.55 Lesson5 p.60 Lesson11 11 p.61 6 p.61 0 p.62 p.61 A10111 p.62 7
Excel 2007 p.61 p.64 VLOOKUP 6 4 TRUE1FALSE0 p.65 VLOOKUP 8 VLOOKUP p.66 A7 2 A7 #N/A A7 A103 p.68 Office 2007 p.68 p.67 69 Lesson6 p.80 1 p.81 8
Excel 2007 p.84 2 p.84 3 p.84 4 1 Excel 1 1 5 p.84 Lesson7 p.89 1 Ctrl 2 p.89 4 p.89 1 1 p.91 9
Excel 2007 p.92 2 p.93 p.95 SmartArt 3 SmartArt SmartArt 7 SmartArt 6 SmartArt SmartArt SmartArt 9 Enter BackSpace Delete Shift Enter p.97 4 p.99 10
Excel 2007 Lesson8 p.105 1 p.105 p.106 Lesson5 3 p.108 7 p.109 p.109 Lesson4 3 p.111 p.114 1 OK 3 p.115 11
Excel 2007 Lesson9 p.119 p.121 1 p.120 p.122 9.2 p.126 AND OR AND 8 12 8 AND 12 OK p.127 1 p.127 4 5 p.128 p.129 2 12
Excel 2007 Lesson10 p.134 p.127 =COUNTIF(C4:C14,"?") SUMIF p.135 3 250 3 p.138 p.139 p.139 10.5 p.140 0 100 Lesson11 p.144 1 E3 12 p.144 p.145 p.145 13
Excel 2007 p.146 12 5 5 p.146 p.147 13 B4 =!E4 =! p.148 14 3-D p.149 3-D 3-D Enter 1 Ctrl+Enter p.150 2 p.150 1 B3 p.151 5 Lesson12 p.155 Windows Windows XP 14
Excel 2007 Windows Vista p.155 CSV Excel CSV Office CSV OK p.158 12 p.160 p.161 p.162 15
Excel 2007 11 8 G211/8 Enter B3 B3 D3 A1 HGP E 16 A3 G8 Ctrl A10 B10 A3 G3 A3 G3 Ctrl A10 5 60 3 2 A3 G3 E4 E8 B10 E4 E8 =SUM E4:E8 Enter G4 =F4-E4Enter G4 G4 G8 8. B4 F8 G4 G8 Ctrl B10 9. Office IT-Excel2007 Enter E-L01-01 16
Excel 2007 Office IT-Excel2007_dl E-L01-02_.xlsx C3 C3 H3 A4 A4 A8 C4 I9 C4 I9 A3 I3 41 3 Office Excel 97-2003 Excel 97-2003 IT-Excel2007 E-L01-02 Microsoft Office Excel Office IT-Excel2007 E-L02-01 I 3 4 Ctrl 12 13 E C14 Ctrl D15 E16 F17 E Ctrl Enter 6-2016-204 H14 H17 H14 6-201 H14 H14 H17 17
Excel 2007 B 200 B17 14 17 28.50 G14 G17 C14 F17 Ctrl H14 H17 8. I / A14 A17 9. B14 I17 3 OK C17 Ctrl D14 E15 F16 OK 10. B15 F15 Ctrl H15 I15 B17 F17 H17 I17 5 80 2 2 1 5 2 OK 1 Office IT-Excel2007_dl.xlsx No A3 / B3 18
Excel 2007 No A3 S 8 C D Esc D5 E14 1 2 Ctrl+Shift Shift 10/31 Ctrl Ctrl Delete R5 C5+H5+J5+L5+N5+P5 Enter S5 I5+K5+M5+O5+Q5 T5 R5 S5 R5 T5 T5 T14 8. OK 9. Office IT-Excel2007 E-L02-02 B1 B1 19
Excel 2007 HGP B 14 B3 F8 C4 Ctrl D5 E6 F7 OK B3 F3 4 60 3 3 B8 F8 4 80 2 3 B3 F8 I3 M8 I3 M8 B3 B4 C3 B4 Ctrl C3 OK 8. B3 G3 9. 4 7 30.00 10. I M 1 Office IT-Excel2007 E-L02-03 A-101A-105 20
Excel 2007 A4 A8B-101B-103 A9 A114 6 C3 E3 I3 A3 J3 A12 B12 A13 B13 F4 A14 B14 F4 C4 F12 G4 C4 E4 =AVERAGE C4:E4 Enter G4 G4 G12 C13 C4 C11 =MAX C4:C11 Enter C14 C4 C11 =MIN C4:C11 Enter C13 C14 C14 G14 H4 =F4/$F$12Enter =F4/F$12 H4 H4 H12 H4 H12 I4 =ROUND(B4*85%,-2)Enter I4 I4 I11 J4 =IF(H4>=14%,"","") Enter J4 J4 J11 8. A3 J11 Ctrl A12 H12 A13 G14 8 21
Excel 2007 Esc A3 J3 Ctrl A12 H12 2 10% 2 3 A13 G14 2 3 C4 G14 B4 B11 Ctrl I4 I11 9. Office IT-Excel2007 E-L03-01 A1 A3B3 B4 E4 F3 K3 B3 E3 A3 A4 F4 B4 E4 A 9.50 B F 00 E5 E12 F5 =E5/SUM($E$5:$E$12)Enter =E5/SUM(E$5:E$12) F5 F5 F12 F5 F12 G5 =IF(E5>=2500," ","")Enter G5 G5 G12 I5 =E5/H5Enter 22
Excel 2007 I5 I5 I12 2 J5 =IF(I5>=103%,"",IF(I5>=97%," ",""))Enter J5 J5 J12 8. K5 =ROUNDDOWN(AVERAGE(E5,H5),-2) Enter K5 K5 K12 9. A3 K12 A5 K12 2 OK 10. 8 Esc 1 A3 K4 5 11 1 G5 G12 Ctrl J5 J12 B5 E12 Ctrl H5 H12 K5 K12 1 Office IT-Excel2007 E-L03-02 6 14 G16/14 Enter J1 K1 J2 K2 F4 B 100 23
Excel 2007 I L 00 G1 H1 13 3 14 OK G2 A5 A11 =COUNT A5:A11 Enter G2 G/ " " OK C5 =PHONETIC(B5)Enter C5 C5 C11 C 18.00 B7 / H5 E5 G5 =MAX(E5:G5 Enter H5 H5 H11 8. I5 =RANK(H5,$H$5:$H$11) Enter =RANK(H5,H$5:H$11) I5 I5 I11 9. J5 =IF(OR(D5>=$L$1,H5>=$L$1),"A","") Enter K5 =IF(OR(D5>=$L$2,H5>=$L$2),"B","") Enter J5 K5 K5 K11 10. L5 =IF(AND(E5>=7,F5>=7,G5>=7)," ","") 24
Excel 2007 Enter L5 L5 L11 1 L4 3 7m 1 D5 H11 0.00 OK 1 F1 H1 Ctrl F2 G2 J1 L2 Ctrl A4 L11 D4 D11 OK 1 A4 L4 Ctrl F1 F2 A5 A11 I5 L11 A4 L4 3+ 60 3 4 1 Office IT-Excel2007 E-L04-01 1 1/43/31 Enter A3 B3 B4 D4 E3 J3 B3 D3 A3 A4 F4 Alt+Enter I2 25
Excel 2007 Ctrl B4 D4 A5 A10 / / OK H1 H114 OK J1 F4 E5 E10 G5 =E5-F5Enter G5 G5 G10 B5 D10 E5 F10 #,##0 #,##0 " " OK 8. G5 G10 1234 OK 9. H5 =IF(AND(B5>C5,C5>D5)," "," ") Enter H5 H5 H10 10. I5 =IF(OR(G5<0,H5=" ")," "," ") Enter I5 I5 I10 1 J5 26
Excel 2007 =RANK(E5,$E$5:$E$10,1) Enter =RANK(E5,E$5:E$10,1) J5 J5 J10 1 B3 1 G1 Ctrl H1 J1 A3 J10 1 H5 J10 A3 J4 4 60 3 3 1 Office IT-Excel2007 E-L04-02 B 100 G 00 H A8 E18 Ctrl D19 E21 G3 I21 A8 E8 Ctrl D19 D21 G3 I3 5 A4 Ctrl D6 Sheet1 Enter Sheet2 Sheet3 A9 A18 27
Excel 2007 1 18 OK D9 D18 1 OK B9 =IF(A9="","",VLOOKUP(A9,$G$4:$I$21, 2,FALSE))Enter C9 =IF(A9="","",VLOOKUP(A9,$G$4:$I$21, 3,FALSE))Enter B9 C9 C9 C18 E9 =IF(A9="","",C9*D9)Enter E9 E9 E18 8. E19 =SUM(E9:E18)Enter 9. E21 =E19+E20Enter 10. E9 E19 Ctrl E21 1 B4 Ctrl E6 A9 A18 D9 D18 H18 I21 OK OK 1 Office IT-Excel2007 E-L05-01 28
Excel 2007 Office IT-Excel2007_dl.xlsx Sheet1 Enter Sheet2 Enter Sheet3 A19 A33 5 OK D19 D33 1 OK F11,, OK B19 =IF(A19="","",VLOOKUP(A19,!$B$5:$D$16,2,FALSE))Enter C19 =IF(A19="","",VLOOKUP(A19,!$B$5:$D$16,3,FALSE))Enter B19 C19 C19 C33 8. E19 =IF(A19="","",C19*D19)Enter E19 E19 E33 9. E34 =SUM(E19:E33)Enter 29
Excel 2007 10. E35 =E34*5%Enter E36 =E34+E35Enter 1 B13 =E36Enter B13 14 1 E19 E36 B13 1 F4 Ctrl A6 F11 A19 A33 D19 D33 F19 F33 OK OK 1 OK 1 Office IT-Excel2007 E-L05-02 Office E-L05-02 E-L05-02 OK 2005 2008 A3 F7 B3 F3 30
Excel 2007 A3 F3 Ctrl A7 F7 2+ 10 2 3 B4 E6 B4 F7 A3 E6 A9 12 kg 600 8. 21 3 2+ 10% 2 3 9. 21 3 10. Office IT-Excel2007 E-L06-01 31
Excel 2007 1 12 A3 D3 1+ 60 3 5 B4 D15 0.0 OK A3 D15 2-D F3 M22 3 14 8. 9. 1+ 80 2 5 10. Office IT-Excel2007 E-L06-02 H16 H20 A 100 B3 F3 Ctrl A7 A3 F3 32
Excel 2007 Ctrl A7 F7 3+ 40% 4 4 B7 F7 B3 F3 Ctrl B7 F7 2-D A9 F27 12 70% 8. OK 100 9. 3 + 80 2 4 10. Office IT-Excel2007 E-L06-03 33
Excel 2007 1 4 B E A3 F3 A3 F3 Ctrl A9 F10 6+ 60% 3 B4 E8 Ctrl B10 F10 B4 F9 A4 A8 Ctrl F4 F8 3-D 3-D A12 F27 12 1 300 8. A3 E8 2-D 34
Excel 2007 / 9. A29 G44 10. 12 1 A10 E10 OK 1 3 3 2 1 Office IT-Excel2007 E-L07-01 H18 H21 A A3 E3 + A8 E8 + B3 E3 A3 E3 Ctrl A8 E8 21 3 B4 E7 35
Excel 2007 B8 E8 A3 E7 2-D 100% A11 F27 11 8. 9. 21 3 10. Office IT-Excel2007 E-L07-02 C 200 H 100 E A3 H3 A3 H3 6+ 25% 5 36
Excel 2007 11 B C Ctrl G H OK A4 101Tab B4 F4 G4 Enter 5 27 OK OK OK G H H I 8. / 9. 4 10. Office IT-Excel2007 E-L08-01 37
Excel 2007 Office IT-Excel2007_dl.xlsx OK OK OK OK A OK 18 /,,1 2009/10/5 8. 4 9. 38
Excel 2007 1 3 $1:$3 OK 10. Office IT-Excel2007 E-L08-02 D101D117 B D OK 12 4 6 OK 8. 15000 OK 9. Office IT-Excel2007 E-L09-01 39
Excel 2007 9-1 E-L09-01 Office IT-Excel2007 E-L09-02 A21 D118Tab B21 C21 F21 OK 14000 AND 16000 OK Office IT-Excel2007_dl.xlsx 2 6 B8 G8 B3 B4 >=2009/6/20 D4 F4 >=16 G3 G4 <=18 B5 >=2009/6/20 D5 F5 >=16 G5 <=18 40
Excel 2007 B6 >=2009/6/20 D6 F6 >=16 G6 <=18 B3 G6 OK Office IT-Excel2007 E-L09-03 A A3 G3 Ctrl I3 K3 + G4 G20 J4 =COUNTIF(B$4:B$20,I4) Enter J4 J4 J6 H4 =SUMIF(B$4:B$20,I4,G$4:G$20) Enter H4 H4 H6 G4 G20 40 OK G4 G20 / 10 5 OK C4 F20 8. Office 41
Excel 2007 IT-Excel2007 E-L10-01 1 4 B D G A3 H17 A3 H3 2+ 80% 2 4 D4 G17 H4 H17 H4 H17 4 H4 H17 / OK D4 G17 900 2 OK OK K3 K6 L4 =AVERAGEIF(C$4:C$17,K4,H$4:H$17) Enter L4 L4 L6 K8 K10 L9 =COUNTIF(H4:H17,"<4000") Enter L10 =COUNTIF(H4:H17,">=5000") Enter 42
Excel 2007 8. Office IT-Excel2007 E-L10-02 A A4 E10 A4 E4 Ctrl A5 A10 E5 E10 2 3 B4 E4 E5 B5 D5 =SUM B5:D5 Enter E5 E5 E10 Sheet1 Enter Sheet2 Sheet3 Ctrl Ctrl 2 Enter B1 B4 C4 D4 D2 E2 Ctrl Ctrl 2 Enter 4 5 5 6 B1 43
Excel 2007 5 B1 6 B1 8. B5 = E5 C5 = E5 D5 = E5 B5 D5 D5 D10 9. E2 Shift 6 E2 10. B5 D10 Shift 6 B5 1 Shift 6 B5 E10 1 Shift 6 E2 A4 E4 Ctrl A5 A10 E5 E10 5+ 80% 2 2 1 Office IT-Excel2007 E-L11-01 Office IT-Excel2007_dl 44
Excel 2007 7.xlsx Sheet2 A B4 E4 A4 E4 2+ 80% 2 5 + A4 E4 E5 E10 Sheet1 7 Enter Sheet2 8 Sheet3 7-9 7-9 7 Office IT-Excel2007_dl 9.xlsx 9.xlsx9 7.xlsx OK 8. 7-9 A3 7 A3 E7 8 A4 E10 9 B3 F7 OK 45
Excel 2007 9. 7-9 A B3 E3 A3 E3 3+ 80% 2 4 10. Office IT-Excel2007 E-L11-02 IT-Excel2007_dl 1 2 3 B2 OK I 9.50 B2 I2 4 E3 I16 1 2 3 4 OK D 46
Excel 2007 47 OK Office IT-Excel2007 E-L12-01 Office IT-Excel2007_dl.xlsx / OK OK 18 /
Excel 2007 OK 8. OK 9. Office IT-Excel2007 E-L12-02 1 4 B F B9 B10 Ctrl G3 G2 OK 6 1240 9841205887 A4 A7 A8 A9 F4 A 50 C4 G10 48
Excel 2007 C4 G10 C11 C4 C9 =AVERAGE C4:C9 Enter C11 C11 G11 H3 M3 J4 L9 8. H4 =G4/$G$10Enter =G4/G$10) H4 H4 H9 H4 H9 9. I4 =RANK(G4,$G$4:$G$9)Enter =RANK(G4,G$4:G$9) I4 I4 I9 10. I4 I9 G/ " " OK 1 M4 =IF(AND(C4+D4>=K4,E4+F4>=L4)," ","")Enter M4 M4 M9 1 C3 M3 Ctrl A4 M9 B10 G11 J6 OK 8 Esc 49
Excel 2007 B4 M7 Ctrl B8 M9 2 OK 1 C3 M3 Ctrl A4 B9 B10 B11 5 80% 2 2 3 11 100 1 J6 1 Office IT-Excel2007 Enter E-S01 Office IT-Excel2007 E-S0xlsx B3 F9 2-D 2 / B15 H30 12 B10 F10 50
Excel 2007 OK 2 2 14000 1 25% 4 8. SmartArt SmartArt SmartArt ( 2 ) OK SmartArt 1 SmartArt 1 1 Enter Tab 2 2 Enter Shift+Tab Enter Tab 9. Office IT-Excel2007 E-S02 51
Excel 2007 S1001S1024 F J 10.00 C A3 J3 1+ 60% 3 5 + S1 S OK E4 =ROUNDDOWN(D4*105%),-1) Enter E4 E4 E27 I4 F4 H4 =SUM F4:H4 Enter I4 I4 I27 J4 =E4*I4Enter J4 J4 J27 D4 E27 Ctrl I4 J27 OK 52
Excel 2007 8. F4 H27 1 + 60% 3 5 OK 9. A3 / A30 C30 10. B31 =COUNTIF(B$4:B$27,A31) Enter B31 B31 B33 1 C31 =SUMIF(B$4:B$27,A31,J$4:J$27) Enter C31 C31 C33 C31 C33 1 Office IT-Excel2007 E-S03 Office IT-Excel2007_dl.xlsx OK 4 4 A88 85Tab B88 3/313 31 53
Excel 2007 C88 F88 G88 37,500 H3 H 300 H4 H88 OK 40 OK Ctrl Ctrl 2 Enter 8. 9. 1 3 $1:$3 OK 10. OK 1 2 1 29 2 1 2 3 2 28 3 2 54
Excel 2007 1 18 HG UB 1+ 25% 4 1 / / 1 Office IT-Excel2007 E-S04 A 10.00 A3 F3 Ctrl A9 F9 3+ 60% 3 4 A3 F3 Sheet1 Enter Sheet2 Sheet3 Ctrl Ctrl 2 Enter 55
Excel 2007 A1 A1 B4 E8 Shift B4 Shift B4 F9 A1 B3 C3 D E A3 D3 Ctrl A9 D9 1+ 60% 3 5 8. B4 = F4 Enter B4 B8 C4 = F4 Enter C4 C8 9. B4 D9 10. A3 C8 2-D 2 A12 G27 1 11 2 2 56
Excel 2007 1+ 80% 2 5 1 ( 2 ) 1 Office IT-Excel2007 E-S05 IT-Excel2007_dl 1 2 3 A3 OK A1 H3 H4 =F4*G4Enter H4 H4 H1003 A3 H3 2+ 60 3 5 57
Excel 2007 4 / OK 8. OK 9. Sheet1 G1002 25 Ctrl+End Sheet4 10. 1 / OK 1 10 2 3 58
Excel 2007 1 OK A20 F40 1 Office IT-Excel2007 E-S06 59
BP Excel 2007 2009 2 23 ZUGA BP 108-8646 1-17-3 FAX 03 5421-9137 nsp@nikkeibp.co.jp http://softpress.nikkeibp.co.jp 2009 ZUGA INC. Excel Microsoft PivotChart PivotTable SmartArt Windows Windows Vista Microsoft Corporation 60