کتابی در 149 صفحه که از ابتدا تا انتها و بصورت کامل و جامع کاربردهای اکسل در حسابداری را آموزش داده است
1 ........................................................................................................................................
1 .........................................................................................................................................
6 .............................................................................................................................
7 .....................................................................................................................
9 .....................................................................................................................
11 ...........................................................................................................................
13 ................................................................................................................."!
16 ........................................................................................................ (' &' $%
21 ........................................................................................... -.
*+, ) *+, )
25 .................................................................................................................
2 10!
27 ..................................................................................................................................... 4
'
27 ...........................................................................................................................HOME (
27 ........................................................................................................................CLIPBOARD
29 .............................................................................................. FORMAT PAINTER 7856
30 ...................................................................................................................................FONT
30 .............................................................................................................................. FONT
31 ................................................................................................................................. SIZE
32 .............................................................................................................................. BOLD
32 ............................................................................................................................. ITALIC
33 ...................................................................................................................UNDERLINE
33 .......................................................................................................BOTTOM BORDER
34 ...................................................................................... FONT CO LOR
FILL COLOR
35 ...................................................................................................................... ALIGNMENT
35 ...................................................BOTTOM ALIGN
MIDDLE ALIGN ) TOP ALIGN
35 ................................................ ALIGN TEXT LEFT
CENTER ) ALIGN TEXT RIGHT
36 .............................................................................................................. ORIENTATION
37 ......................................................................................................... TEXT DIRECTION
37 ......................................................................... decrease indent
Increase indent
37 ......................................................................................................................Warp text
38 ...................................................................................................... MERGE & CENTER
39 ............................................................................................................................ NUMBER
40 .......................................................................... ACCOUNTING NUMBER FORMAT
40 ........................................................................................................... PERCENT STYLE
41 ............................................................................................................ COMMA STYLE
41 ........................................................ INCREASE DECIMAL & DECREASE DECIMAL
41 ................................................................................................................................ STYLES
41 ...................................................................................CONDI TIONAL FORMATTING
44 .......................................................................... CELL STYLES
FORMAT AS TABLE
44 .................................................................................................................................. CELLS
45 ...........................................................................................................................DELETE
45 ............................................................................................................................... DELETE
46 ..............................................................................................................................EDI TING
46 ................................................................................................................................SUM
49 ................................................................................................................................. FILL
49 ............................................................................................................................ SERIES
51 ..................................................................................................................JUSTIFY 7856
51 ............................................................................................................. SORT & FI LTER
65 ................................................................................................................ 4
' 2 10!
66 .....................................................................................................................................4
66 ..........................................................................................................................INSERT (
66 ................................................................................................................................. Tables
66 ..................................................................................................................... Pivottable
74 .......................................................................................................................table 7856
75 ................................................................................................................ ILLUSTRATIONS
76 ................................................................................................................................. Charts
79 .................................................................................................................................... Links
81 .................................................................................................................................... TEXT
83 .......................................................................................................................4 10!
85 .................................................................................................................................. 4(<
85 ............................................................................................................ PAGE LAYOUT (
85 ..................................................................................................................... THEMES =>$
85 ................................................................................................................ page setup =>$
86 ........................................................................................................... sheet options =>$
87 ................................................................................................................ gridlines =>$
87 ................................................................................................................. heading =>$
88 ....................................................................................................................................?@8A
88 ...................................................................................................................... formulas (
88 ........................................................................................................... Func tion library
112 ....................................................................................................... DEFINED NAMES
113 ............................................................................................... FORMULA AUDITING
116 ................................................................................................................................. ?BC
116 ...........................................................................................................................DATA (
116 .....................................................................................................DATA TOOLS 0D
129 ............................................................................................................ OUTLINE 0D
133 .................................................................................................................................. ?.E
133 ...................................................................................................................... REVIEW (
133 ..................................................................................................... COMMENTS 0D
134 .......................................................................................................... CHANGES 0D
138 ................................................................................................................................. ?.B
138 ........................................................................................................................... VIEW (
141 ............................................................................................................MACROS 0D
آموزش جامع کاربرد اکسل در حسابداری
