Excel
- 1. Buddhi Sakal School Microsoft office Excel 2007 α ααα αα αα ααΈ αααααα Tel: 076 662 0833 αααα ααΈ 1
- 2. Buddhi Sakal School Microsoft office Excel 2007 α ααα αα αα ααΈ αααααα Tel: 076 662 0833 αααα ααΈ 2
- 3. Buddhi Sakal School Microsoft office Excel 2007 α ααα αα αα ααΈ αααααα Tel: 076 662 0833 αααα ααΈ 3 ααΌαααααΆ ααααααααα·ααΈ Microsoft Excel 2007
- 4. Buddhi Sakal School Microsoft office Excel 2007 α ααα αα αα ααΈ αααααα Tel: 076 662 0833 αααα ααΈ 4 ααα ααααΈ α‘ α‘. αα·ααααα Microsoft Excel ααΊααΆααααα·ααΈαα½αααααΆααααα αΎααααα αααααΆα ααΆαα·αααααααΎααααΎαααΈαααΆαΎααΆ ααααΆ αααααΈαααα α ααααααΆαα·α ααααααα·αα· α¬ααααααααα·ααααα α α’. αααααααΎαααααα·ααΈ Microsoft Excel 2007 ο° α α»α αααΎααΆαα Start Manu ο° ααααΆαα Program > Microsoft Office ο°α α»α αααΎααΆαα Microsoft Office Excel 2007 ααα αααααααΌα αααααααα·ααΈ Microsoft Excel 2007 ααααα αα α αα ααα»α Work Book ααααααα·ααΈ Microsoft Excel ααΆα Work Sheet ααΆααα αΎα α αΎααα ααα»α Work sheet ααΈαα½α α ααΆα Row α ααα½α 65536 ααΉα Columns 256 . Tab Bar Tools Bar Active Cell Formula Bar Columns Row Work sheet Cell αα·ααααα Microsoft Excel 2007
- 5. Buddhi Sakal School Microsoft office Excel 2007 α ααα αα αα ααΈ αααααα Tel: 076 662 0833 αααα ααΈ 5 ο Tab Bar ααΊααΆ αααααααα½ααααααααΆαααα»α Tools ααΆααα αΎαααααΆααα’αα»αααααααΆ ααΆ ο Active Cell : ααΊααΆαααααααααΆαααααΆαΆ αα’αΆααααααα ααα Cell ο Formula Bar : ααΊααΆααααααααααΆαααααΆαΆ α αΌαααα α¬ αα·αααααααα»α Cell ααΈαα½α α ο Row : ααΊααΆαα½ α αα Cell ο Columns : ααΊααΆαα½ αααααα Cell ο Cell : α αααα»α αααααΆ ααΆα Row αα·α Columns ο Work Book : ααΆααΆααααΆααααΆ ααΆ αααααααα·ααΈ Excel α αΎαααΆααααααααααΎ Work Sheet ο Work Sheet : ααΊααΆααα·ααα ααααΆα Work Book ααααααα Cell α£. αααΎ Tab ααα Microsoft Office Excel ααΆαα’αΆαΈαααα ? αα ααα»αααααα·ααΈ Microsoft Office 2007 ααΆα Tab αααΌα ααΆ α - Tab Home - Tab Insert - Tab Page Layout - Tab Formula - Tab Data - Tab Review - Tab View - αααααααα α αααα»αααα Tab ααααααααα·ααααααΎααΆααααα ααΊααΆαααα Tab Home , Insert , Page layout αα»ααα α α
- 6. Buddhi Sakal School Microsoft office Excel 2007 α ααα αα αα ααΈ αααααα Tel: 076 662 0833 αααα ααΈ 6 ααα ααααΈ α’ α‘. Tab Home Tab Home ααΊααΆ Tab αα½ααααααααααΎααααΆαααααΌ Font , Size Font , α’αΆα ααααΉαα’ααααααααααΆα α’αΆα αααααΆααΆαααΆα α α αΎααα ααα»α Tab Home ααααΆαααααααα αααΆ blog αααααααααα ααΆααααΌα ααΆ α -Blog Clipboard -Blog Font -Blog Alignment -Blog Number -Blog Style -Blog Cell -Blog Editing α‘.α‘ Blog Clipboard Blog Clipboard ααΊααΆαααααααα½αααααΆαααα’αΆααααΎαα’αΆα α ααααα·ααααααα αααΈ Cell αα½ααα Cell αα½αααααααΆα α α‘.α’ Blog Font Blog Font α’αΆα αααΌ αα αα’αα , αααΌ Font , αααΌ αααα’αα ααααα αα·ααΆα’αααΈ Tab Office α αΆααααααααΎ Cell α’αα ααα·α Font α’αα αααα αααΆα ααααΈααααΆαα’αα αα αα’αα αααααΎααα αα’αα αα½α CM αααααα αα’αα αα½α CM αααΌ αααα’αα
- 7. Buddhi Sakal School Microsoft office Excel 2007 α ααα αα αα ααΈ αααααα Tel: 076 662 0833 αααα ααΈ 7 ααααα·ααααααααΎαα’αΆα α αΌααα ααα Blog Font ααΆα αα Font Property - Font : ααααΆαααααΌ αα αα’αα αααα α ααΆααααα α ααα Font - Font Style : ααααΆααααααααααα α ααα Font ααΆααααΌα ααΆ Regular , Italic , Bold , Bold Italic - Size : ααααΆααααααααα α αααα’αα - Underline : ααααΆααααααααααΆα ααααΈααΆαααααΆαα’αα - Color : ααααΆααααααααααα’αα - Effects : ααααΆααααΌααααΆα ααα ααααΆα αα’αα ( αααα’αα ααα»ααααα α ) - Preview : ααΆααααααααααΆαααααΆαΆ αααΌαα’αΆαΈαααααααΆααααΆαΎ αααΎα’αα αααΆα
- 8. Buddhi Sakal School Microsoft office Excel 2007 α ααα αα αα ααΈ αααααα Tel: 076 662 0833 αααα ααΈ 8 α‘.α£ Blog Alignment ααααΆαα Blog Alignment αα·αααΊααααΎααΆααααΆααααααΉαα’αααα αα·ααααααααααααΆααα ααα»α Cell ααααα»ααα α α ααααα·ααααααααΎαα’αΆα α αΌααα ααααΎ Blog Alignment ααΆα αα Format Alignment - Horizontal : ααααΆαααααααααααΉααα’αΆααα½αααααα Cell - Horizontal : ααααΆαααααααααααΉααα’αΆααα½α αα Cell - Orientation : ααααΆαααααααααααα αααα’αα ααααΉαααΆααααΆα ααααΉαα αααα αααα·ααααΎ ααααΉαα αααα αααααΎ αααΎααααΎ αααΎ ααααΉαα αααα α ααααΉαααΆααααα α ααα·αα’αα αα αααΆαααα»α Cell ααα·αα’αα αα αααα αααα»α Cell ααααΉαα αααα αααααΎ αααΎααααΎ ααααΆα αααΌ αα ααα’αα ααααΆααααα α α Cell Format Alignment
- 9. Buddhi Sakal School Microsoft office Excel 2007 α ααα αα αα ααΈ αααααα Tel: 076 662 0833 αααα ααΈ 9 α‘.α€ Blog Number ααααΆαα Blog Number ααααΆααααααααααααααα ααααα ααα αααα ααα α , ααααα αΌαααΈααααα ααααα αααα α ααααα·ααααααααΎαα’αΆα α αΌααα ααααΎ Blog Number ααΆα αα Format Number - Category : ααααΆααααααααααααααααα ααα Number - Simple : ααααΆαααααΆαΆ αααΈααΆ ααα αααα - Type : ααΆαα α ααα Number Format αααααααΆ Dollar αααααααΆααΆα α αααααααΆααΆα α αααααααααααααααα½ααααα αααααααααααααα½ααααα
- 10. Buddhi Sakal School Microsoft office Excel 2007 α ααα αα αα ααΈ αααααα Tel: 076 662 0833 αααα ααΈ 10 α’. Tab Insert Tab Insert ααΊααΆ Tab αα½ααααααααααΎααααΆαααα’αΆααααΎαα’αΆα αααααΆααΆα , ααΌα αΌαααΆα ( Drawing ) , ααΆ ααΆα αα αΌαααΆαααααααααααΎααααα·ααΈ , ααΆ ααααααΆαα·α ...α α αΎαααα»α Tab ααααααΎααα·ααΆααα Tab 5 ααααΆαααΆααΆαααα αααααΆααααααΆαααααΎαααααΎααΆααααα -Blog Table - Blog Illustration -Blog Charts -Blog Text -Blog Symbol α’.α‘ Blog Table Blog Table ααΊααΆ Blog αα½αααααΆαααα’αΆααααΎαα’αΆα αααααΆααΆααα αααΎ Cell α’.α’ Blog Illustration α’αΆα ααααα αΌαααΆα , α’αΆα ααΆααα αΌαααΆαααΆαααααααααα»αααααα·ααΈ , α’αΆα ααΌααααΆα αα ααααααααα...
- 11. Buddhi Sakal School Microsoft office Excel 2007 α ααα αα αα ααΈ αααααα Tel: 076 662 0833 αααα ααΈ 11 α’.α£ Blog Chart Chart ααΊααΆ Blog αα½αααααΆαααα’αΆααααΎαααααααΆαα·α ααααααααα·αααααααα»α Cell αααααα α α§ααΆ αα αααΆαα·α α αααΆαα·α ααΆα αααΆαα·α αααΆα αα αααΆαα·α ααα αααΆαα·α αααα αααΆαα·α ααΆαα αααΆαα·α α
- 12. Buddhi Sakal School Microsoft office Excel 2007 α ααα αα αα ααΈ αααααα Tel: 076 662 0833 αααα ααΈ 12 α’.α€ Blog Text Text ααΊααΆ Blog αα½αααααΆααα’αΆαα’αΆα α αα α’αα ααα αα , α’αα ααα»αααα’αα , α’αΆα αααααααΆααααα ααΆα ααα»α ααααΉαααΆ ααΆ ααΆα α’.α₯ Blog Symbol Blog Symbol ααΊααΆ Blog ααααΎαααΆααααααΆαα ααααααΆ α¬ αΌα αααααααΆαααααααααα»αααααα·ααΈ ααΊαα’αΆα α αα ααΆ αααααααα·ααα·αα ααΆααααααα α£. Tab Page Layout Tab Page layout α ααα²αααααΎααα αααΆ α ααα αααααΉαααΆ ααΆ ααααααΎααα’αΆαααΆαααααΆ ααα»ααα·αααΆ Print αα αααααα αααΆα α αααΌαα αααααΎαααΆαααα Blog Page Setup αααααααααΆααααΆααααααααα·ααΆ α α’αα ααα»αααα’αα α’αα ααα αα αααααααΆα α¬αααΎααααα αα§αα αα α αα ααα·ααα·αα αΌααααααΆ αααααααααΆααααααα αα ααααααα αααααααααα α¬ αααα Background ααααΉαααΆ ααΆ
- 13. Buddhi Sakal School Microsoft office Excel 2007 α ααα αα αα ααΈ αααααα Tel: 076 662 0833 αααα ααΈ 13 ααααΆαα Margin ααααΉαααΆααααα αααααΉαααΆααααΆα ααααΉαααΆααααΎ ααααΉαααΆαααααΆα ααααΉαααΆααααα ααααΉααααΎααααα ααααΆααααΎααααΎ αααα αααΆααααα αααααΎ αααα
- 14. Buddhi Sakal School Microsoft office Excel 2007 α ααα αα αα ααΈ αααααα Tel: 076 662 0833 αααα ααΈ 14 ααα ααααΈ α£ ααααΆααααααα·ααΈαααααΊα’αΆα ααααΆα ααα½αααααααΉααααααΆααααααααα αααΌα ααΆααΆ αααααααΌααααα αα»αααα α α¬ ααααααΆα αααααααα ααα½α α¬ ααΆ α αΊαααΆα ααααΆααααα ααΆααααΎα α ααααα ααααααΆααααΆ ααααΆ αΌααααααα»αααααα·ααΈααΊαααΌααααααΆααααααΆ ααααΎ ( =) αα ααΈαα»αααΆαααα αααΆα α I. αΌααααααα»αααΆ αααααΌα (Summation +) αα·ααΈααΈα‘ =sum(Cell: Cell) Ex. =sum(A5:A9) αα·ααΈααΈα’ =Number1 + Number2 +Number3+.... EX. =10 + 5 + 10 II. αΌααααααα»αααΆ αααααα ( Subtraction - ) αα·ααΈααΈα‘ =Number1 = Number2 EX. =10 - 5 αα·ααΈααΈα’ =Cell - Cell EX. =A5-A8 III. αΌααααααα»αααΆ ααααα»α ( Production -) αα·ααΈααΈα‘ =Number1 * Number2 EX. =10 * 5 αα·ααΈααΈα’ = Cell * Cell EX. = A5*A8 IV. αΌααααααα»αααΆ αααααα α ( Division / ) αα·ααΈααΈα‘ =Number1 / Number2 EX. =10 / 5 αα·ααΈααΈα’ = Cell / Cell EX. = A5/A8 αΌααααααααΆ
- 15. Buddhi Sakal School Microsoft office Excel 2007 α ααα αα αα ααΈ αααααα Tel: 076 662 0833 αααα ααΈ 15 V. αΌααααααα»αααΆ ααααα»αααα αΎααα½ ( Production ) =Production ( Cell : Cell ) Ex. production(A5:A20) VI. αΌααααααα»αααΆ αααααααΆα ( Average ) αα·ααΈααΈα‘ =Average (Cell: Cell) EX. =Average (A5:A8) αα·ααΈααΈα’ =(Number1 + Number2 + Number3) /n EX. =( 10 +5 + 10 ) /3 αα·ααΈααΈα£ =Sum(Cell: Cell)/3 EX. =Sum(A5:A8)/3 VII. αΌααααααα»αααΆ αα ααα½ααααααα»α ( Maximum ) αα·ααΈααΈα‘ =Max (Cell: Cell) EX. =Max (A5:A8) VIII. αΌααααααα»αααΆ αα ααα½ααα½α αααα»α ( Minimum ) αα·ααΈααΈα‘ =Min (Cell: Cell) EX. =Min (A5:A8) IX. αΌααααααα»αααΆ αααΆαααα»α ( Power ) αα·ααΈααΈα‘ =Power (Cell: Cell) EX. =Power (A5:A8) αα·ααΈααΈα’ =(Number1 ^ Number2) EX. =( 4 ^2 ) = 16 X. αΌααααααα»αααΆ α αΊαααΆα ( SQRT ) αα·ααΈααΈα‘ =sqrt (Cell: Cell) EX. =sqrt (A5:A8) αα·ααΈααΈ2 =sqrt (Number) EX. =sqrt (9)
- 16. Buddhi Sakal School Microsoft office Excel 2007 α ααα αα αα ααΈ αααααα Tel: 076 662 0833 αααα ααΈ 16 XI. αΌααααααα»αααΆ ααΆααα ααα½α ( Count ) αα·ααΈααΈα‘ =Count (Cell: Cell) EX. =Count (A5:A8) XII. αΌααααααα»αααΆ ααΆααα ααα½αααΆααααααα ( Countif ) αα·ααΈααΈα‘ =Countif( Cell:Cell,Cell) EX. =Countif (A5:A8,B5) XIII. αΌααααααα»αααΆ α αααααααα αα ( Rank ) αα·ααΈααΈα‘ =Rank (Cell, Cell: Cell α α»α F4) > Cell ααΆ Cell ααα Average EX. =RANK(N7,$N$7:$N$12) XIV. αΌααααααα»αααΆ αααααααΆαα α¬ αααα αα αα·ααΈααΈα‘ =if(Cell>=Number,βCriteriaβ,β Criteriaβ) EX. = if(A3>=50,βPassβ,βFailβ) XV. αΌααααααα»αααΆ αα ααα½αααα αααα ααα α ααΆα αα Datedif αα·ααΈααΈα‘ = Datedif(βStart dateβ,βEnd dateβ,βUnitβ) EX. = Datedif(β01/12/1999β,02/04/2010β,βYβ) ααα α EX. = Datedif(β01/12/1999β,02/04/2010β,βMβ) ααα α EX. = Datedif(β01/12/1999β,02/04/2010β,βDβ) ααα α XVI. αΌααααααα»αααΆ αα ααα½αα’αΆαα» ( Today) αα·ααΈααΈα‘ =(today()-Birth of date)/365.25 EX. = (TODAY()-E7)/365.25 XVII. αΌααααααα»αααΆ ααΌααααααααα ( Sumif ) αα·ααΈααΈα‘ =sumif(Rang,βCriteriaβ,Sum Rang) EX. =SUMIF(C7:C28,C7,J7:J28) ααΆ ααΌαααααΆαααααΆαα Manager
- 17. Buddhi Sakal School Microsoft office Excel 2007 α ααα αα αα ααΈ αααααα Tel: 076 662 0833 αααα ααΈ 17
- 18. Buddhi Sakal School Microsoft office Excel 2007 α ααα αα αα ααΈ αααααα Tel: 076 662 0833 αααα ααΈ 18 ααα αΆααα’αα»ααααα