1 2 12
1 10 15

:

  1. #1
    moderator
    Mon, 09 Mar 2009 01 PM:23:00
    32
    1,191
    8

    Thumbs up







    :
     .
     .
     Microsoft Excel.
     .
     .
     .
     .
     .
     .
     .
     .
     .
     Excel.
    Microsoft Excel . Excel ɡ . Excel . Excel ϗ Excel. Excel .
    ӡ
    Employee Information.xls Lesson01 Practice .

    Excel
    Microsoft Windows . "" " " "Microsoft Excel" . ̡ ϡ " ".
    Excel ۡ Book1 . . . ϡ . Excel ݡ . . ݡ .
    Excel .
    1 Windows "" " " Microsoft Excel.
    Excel Book1 .

    2 "" " " " ".
    Excel Book2 .
    3 "" "".
    Excel Book2 Book1 .
    .

    ѡ ʡ . Excel ʡ . ȡ "" "" " ". " " " ".

    "" " " .

    Excel Windows. Excel Excel 2002: "" "" " " .

    Excel.

    .
    Excel.
    ѡ . "" "" .
    .
    .
    "" Excel .
    " " .
    . ("" " ") Caps Lock Num Lock.
    ѡ .
    " " .
    .
    ( ) ( ). . ɗ B3.
    ɡ ߡ .
    "" .
    ""/" " ( ) .
    "" .
    .
    ɡ ǡ . . . "" " " Excel .
    " " Excel . "" " Office" .
    Excel.
    1 " " "" .
    .
    2 " " A1.
    .

    3 " " "".
    .

    4 " ".
    .
    5 "" .
    .

    6 .
    .
    7 .
    .

    ( ) . . .
    ɡ . ǡ ɡ .

    " " .

    .

    .
    1 D.
    D.
    2 1.
    1.
    3 B E.
    .
    4 G.
    B C D E.
    .

    . A1 A9 A1:A9. C3 G3 C3:G3. (C5:F9) .

    . ǡ . .
    .
    1 E3 E12 .
    E3:E12 E3 .
    2 A5 (Shift) H16.
    A5 .

    3 F17 (Shift) .
    F17 F21 ( F17:F21).

    Excel: . ɡ . ɡ " " ɡ . .
    ա ɡ A Z . ǡ .
    . ɡ "" ( ) ( ). ա ǡ .
    .
    1 A1 (Enter).
    A1 A2 .
    2 A3 (Enter).
    A3 A4 .
    3 (Enter).
    A4.

    .

    0 9 .

    +
    - ( )
    $
    %
    /
    .
    ,
    E e ( )
    ȡ Excel . ȡ . .
    . ɡ (####) . Excel .
    .
    1 B3 42848 (Enter).
    B3 B4 .
    2 92346 (Enter).
    B4 B5 .
    .

    Excel . 22 2004 1/22/04 . ա . ɡ .
    . Excel 00 29 2000 2029 30 99 1930 1999. .
    . ɡ Excel . . Ρ .
    .
    1 B1 2004 (Tab).
    Excel January 2004
    ( 2004) Jan-04 C1 .
    2 Feb 2004 ( 2004) (Tab).
    Excel Feb-04 C1. D1 .
    .

    ɡ (Enter). ɡ .
    .
    1 C3 D4 .
    C3 C4 D3 D4.
    2 39768 (Enter).
    C3 C4 .
    3 90426 (Enter).
    C4 D3 .
    4 45122 (Enter).
    D3 D4 .

    5 87409 (Enter).
    C3 .
    .

    ɡ . " ". Excel "" "". (Delete) (Backspace) . Excel "" " ": " " "".

    " " "Esc" . Excel "". ɡ . "" .
    .
    1 B3 2 8 " " .
    "" I ( ).
    2 (Backspace) 6 (Enter).
    B3 46848.
    3 C4 92313 (Enter).
    C4 92313.
    4 C3 65452 " " " ".
    .
    .

    ӡ Excel . . . ߡ . .

    .
    1 "2" .
    "2" . .
    2 "1" .
    "1" .
    .

    ʡ . Windows. . ɡ . Excel. ݡ "" "" . .
    ݡ . Windows ѡ 255 ݡ :
    / \ > < * ? | : ;
    " " . Excel .
    Excel. Lotus. ( Lotus .)
    1 "" " ".
    Excel " ". .

    2 " " ( C).
    3 Practice.
    4 " " .
    " ".
    5 2004 Sales "".
    " " " " 2004. Book1 " " Book1 .
    6 " " "".
    .
    7 "" " ".
    8 " " " ".
    9 WK4(1-2-3)(*.wk4).
    10 "".
    Lotus .
    11 Excel .

    Excel . Excel "". ɡ "".
    "" .
    1 "" "".
    "".
    2 " " Practice.
    Practice "".

    3 Lesson01.
    Lesson01.
    4 Employee Information "".
    "" Employee Information.
    5 "" "".
    Excel Employee Information.
    6 "" .
    Excel "".
    7 "" Employee Information.
    .
    .

    Excel "1" "2" "3" . .
    .
    1 "1".
    1 .
    2 (Enter).
    .
    .

    . "". .
    . " " "" .
    . .

    " " . .
    ɡ . "" "".
    .
    1 " " "".
    " ".
    2 .
    .
    3 .
    .
    4 "" " ".
    " ".
    5 "" "".
    "".
    6 "".
    .
    7 "" "".
    .
    .
    Excel
    Excel. Excel Excel.
    ߡ . ݡ Excel . Excel Excel. .
    Excel.
    1 "" .
    .
    2 "" Excel.
    Excel.

    Excel . .
    :
    ■ Excel.
    :
    ■ Excel .

    1 ʿ
    2 Ͽ
    3 ǿ
    4
    5 ɿ
    6 ǿ
    7 ǿ
    8 "" "" ""
    9 ݿ
    10 " "
    11 "" Excel
    12
    13 " "

    1: . B1 C1 D1 2004 2004 2004. B2 D3 .

    1 2. 3 5 .
    2: C3 " " . "1" . B 5. B1 D2 B5 D7 . .
    3: Microsoft Excel . Loan Amortization ( " ") . . ȿ
    4: " " " " Excel . ǡ Microsoft . ʡ " Microsoft.com" . (: ).
    5: . " " .
    [](( ))

    .

  2. #2

    Wed, 27 May 2009 12 PM:47:15
    38
    2
    0




  3. #3
    moderator
    Mon, 09 Mar 2009 01 PM:23:00
    32
    1,191
    8



    http://www.filebox.com/kw92ygvl9h29

    :
     .
     .
     .
     .
     .
     .
     .
    Microsoft Excel . . . 1455 1.455$.
    . Excel. ڡ Excel .
    Excel . Excel .
    ӡ
    Percent Sales Increase.xls Five Year Sales02.xls Rentals.xls
    Monthly Sales.xls Lesson02 Part IV Practice .

    Excel . . Adventure Works . ʡ . Excel .
    ߡ Excel . . "" ǡ .
    ($ % / , E e) Excel . ݡ .

    .
    .
    ( ).
    .
    18 2004 18 5/18
    8:47 20:47 8:47:56.
    100 .
    .
    .
    .
    .
    .
    . ޡ .
    .
    1 Excel " " " ".
    "".
    2 " " .
    3 Practice Part IV Lesson02.
    4 Percent Sales Increase "".
    Percent Sales Increase.
    5 A1 "" "". "" ǡ "" "".
    " " "" "" .

    6 "" 14/03/01 "".
    A1 .
    7 B3 F8.
    8 "" "" "" "".
    " " ( ). ($) .

    9 " " 0
    (Enter).
    .
    10 C10 F10.
    11 "" "" " " "".
    " " " " . .

    12 "".
    .
    13 .
    .

    14 "" "".
    15 Excel .

    32.000 8.43 . ϡ . (######) . Adventure Works ɡ (###) 12.400,450$ 11 ǡ 8.43 . ɡ ǡ .
    ѡ .
    Adventure Works ʡ . ɡ 8.43 ǡ . ϡ .
    Excel . " " ( "") . . ϡ . ϡ .

    ʡ H . . ѡ .
    ߡ Excel .
    . " " ( "") . 1/72 . 12 ( ) 1/6 . .

    . ߡ .
    . 15 .
    1 "" "".
    "". Lesson02 Practice.
    2 Five Year Sales02 "".
    .
    3 B4 F4. "" "" "".
    " " .

    4 13 " " "".
    ɡ B F 15 13 .

    5 .
    B4 F4.
    6 2.
    .
    7 20.25
    (27 ).
    2.

    8 D.
    .
    9 D.
    D .

    .

    . . . . ɡ ء .
    :
    1.400.342
    842
    1.952
    ߡ . . . Adventure Works
    ( ) ( ). :

    12
    4
    32
    7
    ɗ . . . ݡ .
    "" "" .
    1 B3 B6.
    2 "" "".
    " " .
    3 "".
    "".

    4 "" " ( )" .
    5 "" .
    "" . .
    6 "" .
    7 "".
    Excel .
    8 "" "".
    Excel .
    9 "" "".
    Excel .
    10 "" "".
    Excel .
    .

    Excel . 50 . ߿ Adventure Works ( ). " ". 50 . 50 ѡ .
    50.000$ .
    1 B3 F6.
    2 "" " ".
    " ".

    3 "".
    " " .

    4 "" ( ) " " " " ǡ "".
    " " .
    5 "" " " .
    6 50000 "".
    . ϡ ء .
    7 "" "".
    .
    8 "" "".
    .
    Excel .

    . ɡ . Excel. "" " " Excel .
    . Excel .
    . Adventure Works Rental .95 .99 ( 4.95$ 4.99$ .) ѡ ʡ .
    "" " ". " " " " "" " " " ".

    ǡ . ߡ " " " " .
    .
    1 "" "".
    "". Lesson02
    Part IV Practice.
    2 Rentals "".
    .
    3 "" "".
    " ".
    4 "" ǡ .

    5 " " .
    Excel .
    6 "" " " .
    Excel .
    7 " " "".
    Excel .

    ɡ ɡ ɡ "" " ". "" " " ɡ .
    8 " ".
    Excel .
    9 " ".
    Excel .
    10 " " "".
    11 " " "" .95 (Tab).
    " ".
    12 " " .99
    " " .
    13 "" " ".
    Excel .
    14 " ".
    Excel .95.
    15 "".
    Excel .95 .99 .
    16 " ".
    Excel .95 .99 " ".
    17 "" .
    18 "".
    " ".
    19 "" " " 2 "".
    .
    .

    95 99 . ߡ Excel 95 95 95 " " Excel 99 . ɡ Excel . " " " ". " " ( ). " " .
    .
    . Rentals . . C Rentals . ɡ ϡ .
    "" "". . ѡ . . :

    5 6 7 . "" "" Excel ϡ .
    . ѡ . . :

    C D . "" "" Excel ϡ .

    " " . " " . .

    ݡ ̡ .
    ݡ ̡ .
    ϡ ̡ .
    ϡ ̡ .
    .

    ( ) .
    1 C3.
    C3 .
    2 "" "" "".
    .
    3 "" "".
    "".

    4 " " "".
    "" .
    5 C1 F1.
    .
    6 "" "".
    "".

    7 " " "".
    Excel ( ) .
    8 A10 A12.
    .
    9 "" "".
    Excel 10 (
    13). .

    10 "" .
    Excel .
    11 "" "".
    .
    12 "" "".
    .
    Excel .

    . .
    ߡ . Excel . () () . ʡ Excel "" Windows . . "" Microsoft Word Microsoft PowerPoint.
    . Adventure Works . . . ( ) . .
    ǡ .
    . ʡ . "" Excel "" "" "" "".

    .
    1 "" "".
    "". Lesson02
    Part IV Practice.
    2 Monthly Sales "".
    .
    3 A7 "" "".
    A7 "" Windows A7. .
    4 A8 "" "".
    "" Windows ( A7) A8 A7.
    5 B3 D6 "" "".
    "" Windows "" Windows.
    6 " " Excel.
    Excel " ".
    7 B4 "" "".
    "" Windows " " (B4).
    8 "" "" "".
    Excel .
    9 "" "".
    .
    10 "" "" "".
    Excel .

    11 3444 (Enter).
    Excel .
    12 "" " " 2 "".
    .

    "" "" . "" .
    :
    ■ " 2".
    :
    1 " 2".
    2 "" Excel.

    1 7 ɡ ǿ
    2 "" ""
    3 ǿ
    4 ""
    5 ߿

    1: Five Year Sales02.xls. 1 2. 1 25 . . .
    2: Five Year Sales02.xls B4:F7 . 20000 40000. 12 13.
    3: Five Year Sales02.xls A3 F7 "1" " Office". " 2" A3. "2" A F 15 . B4 F7 . .
    4: 1 B. A 2 ( ). 1 . . . . .
    5: 4 "2". . . "3" . . . ʡ .
    [](( ))

    .

  4. #4
    moderator
    Mon, 09 Mar 2009 01 PM:23:00
    32
    1,191
    8

    Thumbs up



    http://www.filebox.com/z3jnwj8hgak1



    ӡ :
     .
     .
     " ".
     .
     .
     " ".
     .
     .
    Microsoft Excel . .
    Excel . . ֡ . ( ) .
    ( ) . " " Excel . . Excel . ء . .
    ӡ Lodging Analysis03 AW Guest Supplies Lesson03 Practice .

    . . . Arial 10 Excel. 1/72 . 10 1/6 . ߡ Arial 10 . . "" " " ( ) . Excel "". .

    .
    1 Lodging Analysis03.xls Lesson03 Practice .
    2 B1 "" " ".
    .
    3 B3 E3 "" "".
    .
    4 " " "".
    .
    5 ǡ " " ɡ "".
    "" " ".

    6 "" Times New Roman.
    7 "" 12.
    8 "" "" ( ) "" .
    Times New Roman 12 .
    9 A4 A8 " ".
    .
    10 "" "" "".
    " " "" .
    11 " " 1 "".
    .

    12 "" " " Lodging Analysis "".
    .
    .

    Excel "" . "" " " . ݡ ѡ .
    "". "" .

    ѡ ݡ .
    100 .
    .
    .
    .
    "" .
    1 B4 E8 "" "".
    . ѡ .
    2 " " .
    . .

    .
    " "
    " " . .
    " " .
    1 B3.
    .
    2 " " "".
    .

    3 A4 A8 ( ).
    Excel B3 . Times New Roman ѡ 12 .
    4 "" "".
    .
    .

    . . .
    Excel . . ǡ . . .
    Excel "" "" . . Excel . ɡ . Excel .
    ϡ "".

    ǡ . . . Excel . "".
    .
    1 B8 E8.
    2 "" "".
    .

    3 " " ( ).
    .
    4 A3 E3.
    5 "" "" "".
    " " "" .

    6 "" "" .
    7 "" "" ( ).
    8 "" ѡ .
    Excel .

    9 "" .
    " " .
    10 " " "" "" "".
    11 " " .
    " " .
    12 B1. " " "" .
    .

    .

    ϡ . . . . . ء . .
    .
    1 B8 E8.
    .
    2 "" "" "".
    " " "" .

    3 "" .
    4 "".
    ǡ .

    5 "" .
    "" .
    6 "" .
    .
    7 "" "".
    .
    .

    ݡ . " " ɡ . . " " . " " "" "".
    " " " ".
    1 A3 E8.
    .
    2 "" " ".
    " ".

    3 .
    4 ʡ " 2" "" .
    " 2".

    5 "" "".
    .
    .

    ء . Excel : Comma Comma [0] Currency Currency [0] Normal Percent. :






    ( ) ( ). ء . ߡ . ߡ ߡ .
    . .
    1 B1 "" "".
    "" "Normal" .

    2 " " Normal 2 "".
    Normal2.
    3 "".
    " ". .
    4 "" Times New Roman "" " " " " 14 "".
    "Normal2" Times New Roman 14 .
    5 "".
    "" Normal2.
    6 "" .
    B1 Normal2.
    7 A8 "" "".
    "".
    8 " " Normal2 "".
    A8 Normal2.

    9 "" " ".
    A8 .
    10 "" "".
    .
    11 "" "".
    .

    . . . . ѡ .
    . . ɡ . . 16 . 9.999 . ϡ . .
    . " " . .
    ( ) ( ) .
    1 AW Guest Supplies Lesson03 Practice .
    2 A1 ǡ .
    3 (Shift) F1.
    A1 F1.
    4 " ".
    ɡ .
    5 A3 (Shift) F3.
    A3 F3.
    6 " ".
    ɡ .

    7 C4 C5 ɡ " " .
    " ".
    8 "".
    "" " " .

    9 "" "".
    .
    10 " " ѡ " ".
    .
    11 " " ѡ " " "".
    .
    12 C ( ).
    13 C .
    .

    14 "" " " D4 D5.
    Excel .
    15 E4 E5.
    Excel .
    16 F4 F5 " ".
    17 Excel " " C4.
    18 D E F .

    19 "" " " AW Guest Supplies 03 "".
    .

    "" " " " " .
    :
    ■ AW Guest Supplies 03.
    :
    1 .
    2 "" Excel.

    1 ɿ
    2 ɿ
    3 ʿ
    4 ؿ
    5

    1: Lodging Analysis03.xls. . . " " .
    2: Lodging Analysis03.xls . . "".
    3: . ( ޡ ). A . ڡ . . Arial 14 . ( ) " 1" " ".
    4: ʡ 3 " 1" . . տ ǿ .
    5: ɡ . "" Excel . .
    [](( ))

    .

  5. #5

    Thu, 02 Jul 2009 08 PM:50:21
    4
    0




  6. #6
    moderator
    Mon, 09 Mar 2009 01 PM:23:00
    32
    1,191
    8

    [](( ))

    .

  7. #7
    moderator
    Mon, 09 Mar 2009 01 PM:23:00
    32
    1,191
    8



    http://www.filebox.com/5iu4b761hd58


    ӡ :
     .
     .
     .
     .
     .
     .
    . Adventure Works Microsoft Excel . Excel .
    ɡ ʡ ( ) . . . . . ɡ .
    ӡ Sports Income Lesson04 Practice .

    . . .
    Excel. Excel . . Excel. Excel . .
    " " ɡ :

    " " . ߡ Excel 2002 : . . ɡ " " . .
    " " " " .
    .
    1 Sports Income.
    2 "" "/ ".
    " " "/ " .

    3 " ".
    " ".
    4 " " DATE ().
    .
    5 " " "".
    " ". "" " ".
    6 "". ѡ Sports Income.xls 1.
    "".
    7 "".
    " ". ɡ .
    8 "" " ".
    "" .
    9 " " "".
    .
    10 " " "".
    .
    11 .
    .

    2.45 2 . 1.7 .
    . Adventure Works Sports Income ɡ 3.8 . ǡ " ".
    .
    1 "" " ".
    " ".
    2 "" .
    "" "" "" "" "" "".

    3 "".
    3.8 .
    4 "".
    3.8 .

    " " "" " " .
    5 " " ѡ "" "".
    6 " " .
    :

    7 " " "".
    " ".
    .

    . " " . " " . " " " " .

    . ( ) . .
    .
    1 "" " ".
    " ".
    2 "".

    3 " ".
    .
    4 "" " ".
    .
    5 " " "".
    " ".
    6 "" " ".
    "" " ".
    7 "" ȡ " ". ɡ "1 " "1 ". .
    8 "" " ".
    . .

    9 " " "".
    " ".
    10 .
    .

    Excel . Excel ɡ Excel . ߡ Excel . ǡ . . Adventure Works .
    .
    1 "" " ".
    " " "".
    2 " " 100 "".
    100%.
    3 A18. "" " ".
    Excel 17. .

    4 "" " ".
    .
    5 " " "".
    " ".
    6 "" " ".
    .

    " ". " " " " " " "".
    7 .
    .

    ǡ . ǡ . "". ɡ ɡ "" "". Adventure Works . .
    .
    1 "" " ".
    " " "".
    2 "" ȡ " ". ɡ "1 " "1 ".
    .
    3 "".
    4 A1 O19.
    5 "" " " " ".
    6 "" " ".
    " " .

    7 " " "". "" ѡ "".
    .
    8 "" " " " ".
    .
    9 .

    ѡ . ֡ . "" " ".

    :
    ■ . .
    ■ .
    ■ .
    ■ .
    ■ .

    . .
    :
    ■ .
    :
    1 .
    2 "" Excel.

    1
    2
    3 ǿ
    4

    1: Sports Income.xls Practice . . . 2 .

    1 2.
    2: Sports Income.xls " " ʡ 100% . . A1 P20 .
    3: ( ) . . .
    4: . .
    5: "" " " . "" Excel ɡ . ߡ " " . ѿ
    [](( ))

    .

  8. #8

    Thu, 09 Jul 2009 09 PM:49:01
    29
    5
    0

    ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,

  9. #9

    Sun, 04 Oct 2009 05 PM:04:28
    28
    3
    0

    ..
    .

    ...
    ..

    ..
    ..

  10. #10
    moderator
    Mon, 09 Mar 2009 01 PM:23:00
    32
    1,191
    8

    [](( ))

    .

: 1 (0 1 )

  1. merakeb
    : 7
    : Sun, 24 Feb 2013, 08 PM:55:04
  2. : 4
    : Sat, 17 Mar 2012, 08 PM:18:07
  3. semo
    : 3
    : Sat, 10 Jul 2010, 03 PM:43:42
  4. : 0
    : Thu, 15 Oct 2009, 08 AM:08:39