8/14/2019 Microsoft Excel - Curs de Utilizare
1/62
8/14/2019 Microsoft Excel - Curs de Utilizare
2/62
! " #!$ " %& !"'(!%"!%)!$*+,*+-
# % ' ." ,/"010-" 2 % " !%.
!
0%#
3
45" 4,-6
7"!50,%
)" $ . %7.-6
8/14/2019 Microsoft Excel - Curs de Utilizare
3/62
8
6 ," - 7 !"6
0&'"!%"%"%
0
/1$%$
"
"
#%"
.
+!5
+!9
+
:
+
+
+
"%$3
8/14/2019 Microsoft Excel - Curs de Utilizare
4/62
;
3 % $ #"%%' ,!&5)" 5""-6
,-3 ! "
! 2 "6
6 !
" #
!$"&55'
8/14/2019 Microsoft Excel - Curs de Utilizare
5/62
@
$ %
$ &!
!!3
"% $!!
!3
'6 !%6 $"%
$! % 6 % " $ $! ")"
2!5"%$!3 " % %
!"4%%6
3 " !
6 ,
)%%-3!%4,%-"%!
!(
)$ " % % $ !"#$##&(7%"%!$&%
= " %5 ! !"
!!,4-!,""%$!!-
3 "6 ,4-6 "# " 7 )"
$
8/14/2019 Microsoft Excel - Curs de Utilizare
6/62
A
$ '
5%!
" " " % " $
# $ % "
! % A BC # BC" 5 %$BCBC
2 !" BC" $BC"$
$" (%
2"%
#"%5!% $) "
2! ! % " & !
% &!! 5 " $%5"&& 2 " &D 5 & %
. ' ! *)(&+""$"
,-
2"%
7!#"#",!-3$9,9-
7"3 39""8"?69EE"9@"9@E"?6 385#5EE8"@5#5EE8"?6@D99DEE"@D9DEE69E3EE"
9E39@"9E38E"?6 3"""?62"F""">6
8/14/2019 Microsoft Excel - Curs de Utilizare
7/62
G
3 7
8/14/2019 Microsoft Excel - Curs de Utilizare
8/62
K
% "( (."*(>$%.
.!&.
&/#"!%
0 $ " &5(
!>3
6 $"$
2 !" , -
$.!%3 !$6 !,"0-6
%3&6 %1 3 " "
,
8/14/2019 Microsoft Excel - Curs de Utilizare
9/62
L
#",-7%5"&"& 1."!%
$
(
#%"$3 ,-%56 !!%,
-6 0. % &
%# ! %
!3 6 !!,-6 .
$$ +%
:$%5"5!
$"&5%0$$!"20"23"4"
# " 54 5 "$
. % %, %! !-
$, %
#$%&3 34$)6 !3 )53!5!,
-""&&!!,-6
) 3 ! !" " &4"1"!6
&34&6 34
8/14/2019 Microsoft Excel - Curs de Utilizare
10/62
9E
# " %&!3 , & -3 !! &
5&6%!"!'6
,&-3!""%&"6
, %
5 $!" % 5" '
"2%"!$0&"$ " &55 !"&
5!!!$3 ),)-3"$')"!)2, 6'7-" % $ ,) &-" $2'""1""$$'
2%)$"$ ) ,) -3 $ % %
,&-6
8/14/2019 Microsoft Excel - Curs de Utilizare
11/62
8/14/2019 Microsoft Excel - Curs de Utilizare
12/62
9
0 (
!! ! !! % " 3
>#"
77N #72:O2
>20+.#
"!!!32"2#%!"$&%
&%0"!3 6 D%6 6"%%"
$,&-",%!-6
,- !%"3
!!3"26
! 6 !'53
H8"H"H96 !'H3"H""!'5"6
!56 !3:3
2 D" #
3
0 (1
2!% "!
%!"!&"!#!,-"$!
0D!3 !! !1.H,1.HM- $!&! 1.H*
8/14/2019 Microsoft Excel - Curs de Utilizare
13/62
98
2 % 3 " %)'"&%".$$&"%$P7
2%!!5D"!%
3 !" !5',%5
-6
5,-!&
1.,-
= % D & $" !3;"$!!!%
0 1
,-D%&!
0!!3 !6 D6 ! D & D
%6 "6
!6$%)
6
.)5"4"1,-4"1H1.,-%
8/14/2019 Microsoft Excel - Curs de Utilizare
14/62
9;
0" (1
#"$
% " $ " $ $
0$ ()22%*
%5"!"
# " ! 2 " 5 ! ! . 73
!6 36 !!6
.6 3
.J#%
)3 " 3
" $ 6
13&5
0, (#
0 D
8/14/2019 Microsoft Excel - Curs de Utilizare
15/62
9@
$! ! ,& -" $ 3
!" 6 "6).J6
6 !&6 .
3 (
.%$!%"5%(
8/14/2019 Microsoft Excel - Curs de Utilizare
16/62
9A
3 4
.%
3
7#%&,! 3(-&%,!"7-#"",0((-"3
"3%%6 "3%
# $ & %" $
0((
5 67
.&$%
5 7
> $ % $ $
!%0&$!="
5 87
. &
%& && 5 5 " "!/
2%%&%"!/"!$!
"3
%6 %6
8/14/2019 Microsoft Excel - Curs de Utilizare
17/62
9G
%&6 %
5" '17
. ! % % &.!%3
!5%!626&5!6
2 ,-7!"!&D 0!%$ 5$,"!%"%-6
8/14/2019 Microsoft Excel - Curs de Utilizare
18/62
8/14/2019 Microsoft Excel - Curs de Utilizare
19/62
9L
)"$ $ %&""%"$
!%3
2!%,-"$%&!2"$%$&%!
. $!! %"%%!
05$3
8/14/2019 Microsoft Excel - Curs de Utilizare
20/62
E
!%6 $ !33## (
!"$%5",-6
" (" ! ! % #
5,-3
$%"$1
.%2>#"
"$%2$2""%$?
# & 3' 7%LEEEEEEE2$!"%3
8/14/2019 Microsoft Excel - Curs de Utilizare
21/62
9
7 $ % @Q"$R
.$2!" !" ! " !%
%
.%%%
7 '$ '
5 " %7$$ '# A 7; ' B+ A 7 $B 7%C ' ( DEDC'$'(('('(@7$&((
2D3
"!$%53'F33GH336 "!$%5!,-3
'F33GH3GH6
( '( ) , -( ) " STS=!%STS" ((,(-.'(%5( $%',-(UV"%)''7(' "
%!
8/14/2019 Microsoft Excel - Curs de Utilizare
22/62
="$("Q"!9L@EEEE#BTS%"5$5$
="(',-'(3
9
8/14/2019 Microsoft Excel - Curs de Utilizare
23/62
8
" !!'($ !%$" ! & $ WX !! &
" ,- $ ' % %5 "3
"
8/14/2019 Microsoft Excel - Curs de Utilizare
24/62
;
$""%F8$TF8D28:%28$""!&%E(TF8D2
(%F%2" 0 " !" " 0 ! " $ ! BYC" '!&
0"3 $6 3"!TFDY2Y"
$&5"&6 3%!"%BY #
'$(("BY#'$()(
)$3%'!&"5(
"(
0"&""!3
! !7%&!%$,%!(;-"5$%$%"%!'"%$ T7,(3(8- # ! "#"$!"&5!
!"$%$#"%$"!
8/14/2019 Microsoft Excel - Curs de Utilizare
25/62
@
#&"!,$$-7&%"&$%$
. ! #"!3J9E""%%$T7,3J9E-$""7""%#G"$3T7,3J9E"#G-7$"% " B"C" B6C , % $$$!!B"C-
(7 .'$2!"$7
#.J$%
8/14/2019 Microsoft Excel - Curs de Utilizare
26/62
A
7$%2"%#G"$6G$#G 6G,$
-"! 5 , ! - $ 7#, -
$&%%
",$!D!-$%$356
!%!""'(>'% )("$(((%5'($%)
',(-.
!'#''$"! "'0"('$'(%"! & 0 ' " WX ! % ! # &"$ % ) # &!(' "U!V
8/14/2019 Microsoft Excel - Curs de Utilizare
27/62
G
=%%!"$!!&!"B3C#"+9E3#9E
,:#%
$ .'$ '( '(" ! # " " '$"%!%$'"!'$" WTX # ! " " $W6X%!3
E6J'$AK@LB2 ! '$ ,%&'- !%'$++(+(+ %7$'"+$A-! ! ! & %!!'$
",- ( =+ (
&+)+AM'$B ( )" , -
3( (+ (=( +
( ), -
( ) (+ (( ((+ + '$$(+'$(+'$+
*- ( + 7 + (++
+, ( !
,-
( 7 ( ) @ + (
!&$"6161-,!- 2()@(AB),- )7&I+(
=+(7++,- )( ( 7 ( ) 10
A)(B *. A'B+ '( )$ 'A$(B
",- ( '$ ./+' + &
,- 7+ '$ &0 %111
+ 23),
8/14/2019 Microsoft Excel - Curs de Utilizare
28/62
K
-:#+ 2% "$
!.'$"%,-0
!"%&$%!"$.'$"$ . '$ , ! " @$-2!" > '$ ,JJJ -'$,1- # ! "4"@ 0!!!%EEEEEEE")8A"&@Z
2 [5" ! :02$ !6 !+;6 .'$6 !"216
! , % "$$6+9"%96" $ % ;-6 $ &! "%)! 6 " ! $!! % 6
8/14/2019 Microsoft Excel - Curs de Utilizare
29/62
L
!&N6
0-9 2)B5C,-
% ! % 6" E!(!!7O8 2! " $
!3!"
0%
(!%
".#\"/J#\"\6()2:F"
.+2:" .7" .7[" #F7" *:" M0" (" (>.." 2:" >:" >.F">.F9E" #" 2:*7" >" .#" .##" 02" 0./" 0.#"#2:7":#".:".:#".:##./:".:#0"72F:"72:"72:["7]" 7+.>" 7" 72(" 70.#" 77]" 7M\"7M0\"7M\":":[":6
" .:" .:".:+>:J" .:2(" .*" 2+2:." #*7]" 0.:#27" (#27"(2:*" (27[" (27[2:*" (.7" (]:\" (7" F#27"
8/14/2019 Microsoft Excel - Curs de Utilizare
30/62
8E
F2:*" F>:" F.:" F./[" [:" [\0F.#27"2:0"J">F">2:7">.F7">.F2:*">.F:.#27"M"M"#2:" 2:" 2:" .#" :F+2:.#27" :.#27" :.2:*":.7#27" :.72:*" 07.:" 0:2>" 0::J"0"0.277.:" 0.+" ]2>" :J" 7]" 7J/" 7>.0" 7>>"
7:##2I" 7#*" 7#*" 7#*0" 7#*0" 7\M" #27" 2:*"#"2:"7"*"*"*0"*0"/2+>>"I76 ( ! :7"
F02*.#" [>..J0" [\0>2:J"2:#M"2:#2">..J0"[".((7"./"./7":70.7"*>..J06
>" M" (2:#" (2M#">(" >:" >./" 2#" 0.0" 0>" 0" 2F[" 7["7+72""M"2"00"*>6
+" ." \0" 2:(." 27+>:J" 27" 27." 27>.F2>"
27:"27:.M"27:+"27("27M":":"\0
3(#%
!!%3
$562 !7$+)2)8!!
*F,+G+H+- (
EA5G5H5B;7,+G+H+- (E5G5H5
0.#,+G+H+- 2EGH2:,+G+H+- +G+H+M,+G+H+- +G+H+.:,)+)G+H+)- 6($.:,)+)G+H+)- 6($+7,- 9(,-2:,- 2&('(
(>..,"- 2&(7],- (((.:#,+- I7$!02,- *(T8"9;9@LA@8@KLGL:#,- 6(%$,E"9-*,+G+H+- 3($+G+H+
#T ,
8/14/2019 Microsoft Excel - Curs de Utilizare
31/62
89
,-0./,+- 2.#,+- 7
:.,- 6$*(>7"(>7
,- *(>7,- *(>76%2(,++G- 7 $! $ #$
" 2( !
$ " ! $G[..7,"+G+H+- 2'$(7$
5$"!$.#\,- 3((:./,- 37((*>..J0,)++- ( )(7$%
# !%7!!#!% "$
09
[>..J0,)++- ((7$% # ! %7!! #!%"$ 09
.(7,++++- . '$ ( ,T%" T-! ! !
)9).#,- 2
,$'-[,- (2%*>,- 9(>:,- 6(
>(,+- 22F[,+- 0
8/14/2019 Microsoft Excel - Curs de Utilizare
32/62
8
2#,++G- !G%&!
0,+-
2,- "
$>./,- %00,- %0.0,- % $&
%.::,+G+H+- +G+
H+0>,++G+G- P % % G
%&!G:
(*,+++)+P- 9) ,)-%%5 $" "T&!"T"T%")T$%" PT 9 E %&
:0,++)+')+P- 6 ' 5 : " " ! %
0,++)+')+P- 2P@7%0*,+++')+P- 2)
8/14/2019 Microsoft Excel - Curs de Utilizare
33/62
88
!$#2:,++- !)(
!$#0.#,++- ! $ !
$
#*,++- !($!$#+G+H+$"$ +G+H+#T ,
8/14/2019 Microsoft Excel - Curs de Utilizare
34/62
8;
!#%"!$%%0 0 " 5
" " !
5'%
)*
!!!!$73
"A1.+*1*)(+*1B3 1.5$!,$$-6 *1*)(5$!%2(,-"!$6
*15""$!$%2(,-"!=!3
T V &U &VT UT
5,%2(-!"%"
$03
!)!$"2(+>:J,- 52(,- 5,&^:D-2(.,- 52(>.F2>,- 5$
2(:,- 5$^:D2(:+,- 5
8/14/2019 Microsoft Excel - Curs de Utilizare
35/62
8@
2((,- 52(M,- 5#"%5%9"
!$$)`*%9_`""5
"$)3
"A"181A*BCSSCS9($'&*TSB
5!
" ! " 7 %!9"99LEE
(3
# 5!$#*> 5$%5#\ 5$%5!#\8AE 5!!58AE
!# 5!
%.:[ 5$%5$!:/.J#\7 5!!.#\ 5!
/J#\ 5$%!&/.J#\ 5!%!
\ 5$%5\( 5 ! !
!&. 0 %5 " $! 13*U,-"$
!#$"$%
9=*7%*G!9E
&0"%*G$3 E*5>VM0,"8-"$"
"%*"%*G$3E3*1AU*A*B+614A*B5-+3*UA*BB 80!EE9"$
3 E3*1AG>>C-CB@
9EE9!
8/14/2019 Microsoft Excel - Curs de Utilizare
36/62
8A
5"3
[. 5$%5
2: 5$%:./ 5!7.:# 5$%2 5!!2*> 5$%5
"%
&!"
#"EE85&"
( "" H 1 ( 7$ 1("%5!1G>>-
7 $ 5 $"B_C%
1($
$;%#
. !
$2!%5"!&$$ # 2$$
+ a (
8/14/2019 Microsoft Excel - Curs de Utilizare
37/62
8G
2 a ,
8/14/2019 Microsoft Excel - Curs de Utilizare
38/62
8K
,
3E98;@AGKLH5,-"DYZ
)$""39EE659KLEE69Z69D;6Y;EE2" .!""%,-$,"-%2+%R
#" 5 " 5 " $ ,- &
%
,G
2%%55
""5$,-P&%
,-((7
! $ $ ! !" !# $ " ! % #""$!!!$!"&%F
3 9LEE 9LE;7/19LEE09LE;"4$""4%(W>,
$
" ;" $"9LEE 9 " 9LEE ,$
9-89 " LLLL ,$L@K;A@-
9LE; " 9LE; ,$9-
89 " LLLL ,$L@GEE8-
2
8/14/2019 Microsoft Excel - Curs de Utilizare
39/62
8L
EEE&EL"EE& L#"KD@D9L"!KE9L
9L8E&9LLL"8E& LL#"KD@DLK"!K9LLK
7!!!""
"(W>,0%
3
" " ";;PPPP
!" PPPP , 5;-6
9D9DKL ! 9 KL"EDE8D9LLE ! 8 9LLE
@@PPPP+@@PPPP ! " PPPP
95)59LKE ! 9 9LKE" )5KE ! 9LKE
0$",-
`3`#"9A3G"9K3G39E2!%;#!%9"$0#3@3;E093@
$%
2$$!!!5,-" $ 0 " $,-&&"
(%&&"&%"5" $" " " $ #"$$3#%#
."%&",-"$3#0"$$
#!$5,-#$%$
$"%
7!6(
8/14/2019 Microsoft Excel - Curs de Utilizare
40/62
;E
7 $ % & "
# !3
F 5$"
: 5 ! ! % 6( " !
% 0$
0) 5%9EE#"E99EZ
!( 5,D@"
9 8D; - ( 5 .! %" " 9D 0 "%'"E8D;
7 5!39H89EEE
7 5 0 & !$" $ =
5 " !! $!%
# 5 >1P 7 $,H-
5 57 5 % "
""0! 5! $
8/14/2019 Microsoft Excel - Curs de Utilizare
41/62
;9
$'([
$$'%
0 5 , - $
,*- # " " % !& % )" % $D%"%&!
, " $ $%-%%&%"
0&!"$%"%3
"
8/14/2019 Microsoft Excel - Curs de Utilizare
42/62
;
0%!393
!3(6
,"(7(-6%$6
3 !3(6 !!bb*!"
6 "!6
2!%
"$%%!&'""%""%%"%
,-0$$3
$%6 ! ! bb* !
"6
0 $" % %
2 " $ & +
#9!"(7(6"! ",-
$,%
( ! !
,-
8/14/2019 Microsoft Excel - Curs de Utilizare
43/62
;8
$- /
0 '
% (
,'
8/14/2019 Microsoft Excel - Curs de Utilizare
44/62
;;
$"%!#$ $ , ) 5" -
% " %
" $!! &""5 % " $!! # $"
!2 $ *I
% $ " !"$,%-#)$
-
7&$!!0!(!!!$!!$
!
0
2 " 5"
0 ""
$ # $" % "% $" ! "% %
" $
8/14/2019 Microsoft Excel - Curs de Utilizare
45/62
;@
2!"!%&!&
34%
3(
0$3
!$!,!$-6
4 3( 6
$3("!&"&&)3("1$" ($
0$!!$! *($ 7 $$ ( ) ( ," $!$&5-0$6
0$3("%!%
8/14/2019 Microsoft Excel - Curs de Utilizare
46/62
;A
>, $-"
3,-",-"',F-",>-"'
,#>-,#-
>;,%
%5-6
8/14/2019 Microsoft Excel - Curs de Utilizare
47/62
;G
$1$%
*
E9EEEEEEEEEEEEEE8EEEEEEE;EEEEEEE@EEEEEEEAEEEEEEEGEEEEEEEKEEEEEEELEEEEEEE
9EEEEEEEE
+
++
* +
++
*
.03("
3&
0 ! $ ,5 4 "%&%)'$'-"$! ' $` %
!"$
3"6
!!)5"!!,'-&&5$%!
3$8
7!#
3,&%
8/14/2019 Microsoft Excel - Curs de Utilizare
48/62
;K
#"!"1("10$1"% . ' % ! "$41
3$
3-'
#"
"%5"$$``%.%!! ." " , -" !. 05"$%#7,-$"
!$&
30&%%
# !! '` `% , "
%-"$%!0"44!"
``!#$!
33#
0!!%3
!&46 5 5 ' , ! -
&'$42$'$((2%
!"$4 '$((6
!2($"%#"'"3( " ) ,!" -" &5
35
04$,$-*(7@53"(""6(*
8/14/2019 Microsoft Excel - Curs de Utilizare
49/62
;L
# " 5 2 $
5=
8/14/2019 Microsoft Excel - Curs de Utilizare
50/62
@E
""=
#%5)"!)"
;=& ! 2I'"
!!"!$!%&3 7"%!%
%)#"!'"'"$ & " %& ! ! ! + % )
7$!!!&%) 7$!!!%
) 75""
#$%;=-
& 2I '"!!"!$!%&3
c$'"""c%!%%)#""4""%
" ." )! " $ !!&$6
!!'")6 !!6 "
"%!%%)
9
0!$3
09
!"7" !!1.H0" $!!! % $ , 7 !
& ( 4
8/14/2019 Microsoft Excel - Curs de Utilizare
51/62
@9
&( -"
$"
0 7$!"
$ % "(" % 6 $!#"%!% " $ # % "&"&'7"%5,-" $ " "6
%X('!3
o 15"$",%-
o
2 ,3.-
%$$%3"&5!"3
o $5!! ! ,!& (" 0 " 7 0-6
o )5$6
o 15%
8/14/2019 Microsoft Excel - Curs de Utilizare
52/62
@
""!"&5%"6(,9-#"!",$9&" $ " -
*08 7$3
.J" )" $!!
0!%4
" " ! %
#)*
( $ ,- ( %>%("!%"%&$" % %5(
0 % (" $ ""(""((0$ % (5 ,6 (-"( , !-" $%$(,"(5-"$.J
# % % 5!" &5
!0%$ & &$ & ""(
8/14/2019 Microsoft Excel - Curs de Utilizare
53/62
@8
'
0!""("
0$("%$4
(5"$$$(
>1$%5
$! (57!.J$%("4
8/14/2019 Microsoft Excel - Curs de Utilizare
54/62
@;
"6
0(39#""!(
(=6(4
!! = ! % ! 5 " !
5!
7 $ % " !
5"!',"-
#"%& ! " $ % ! 2 "$%%!
%,-3!""#$%&!'!"()$%&!'
*+!,$-$%&!*+&!+.!&!/,*+*+!,)$%&!*+&!+.!&!/,*+*+!,$%&!
*+&!+.!&!/,*+*+!,0+$%&!*+&!+.!&!/,*+*+!.1$%&!*+&!+.!&!/
,*+*+!.23
8/14/2019 Microsoft Excel - Curs de Utilizare
55/62
@@
$%&!*+&!+.!&!/,*+!""#$%&!'!"()$%&!'*+!,$-$%&!*+&!.!&!/,*+*+!,)$%&!*+&!.!&!/,*+*+!,
$%&!*+&!.!&!/,*+*+!,0+$%&!*+&!.!&!/,*+*+!.1$%&!*+&!+
.!&!/,*+*+!.23$%&!*+&!+.!&!/,*+*+..!&45&!,*+,
$(
#!!!
0"4&&
"``&&!5"
$*(
8/14/2019 Microsoft Excel - Curs de Utilizare
56/62
@A
= 6 ( $ ! ,
% !- $ (G !"$.J#5! " $ ! % ! , - & & ! & 0 $4
,'
0)$4
$"!*(*(#6( ! " % 0 ! .J # ) "$
-8%
74"4&'%)0#
0&%
74"
4 & " %& 74
8/14/2019 Microsoft Excel - Curs de Utilizare
57/62
@G
3
7!4!
# " $ 0
5 0 % !5*""%"=$.J
5
8/14/2019 Microsoft Excel - Curs de Utilizare
58/62
@K
"?##
0$"5&&
"
";!%
2 ;: $%)%
>H: =%>H: !7[2(H: $%%
+ $%7[2(H+ $
&%7 +J70 P&
#> P
>H#> P& *%"%)"&
[. *%(;>H\ 7[2(H( >H7[2(H(8 '&>H# %)>H >H(8 #
";%2 ;+J70 $
$
: >H7[2(H: 27 %%>H 0
%5>H7[2(H 2!"
%5>HJ 2'a4
8/14/2019 Microsoft Excel - Curs de Utilizare
59/62
@L
:,%5'a4-
$'a4
( $!&
(8 >
7[2(H(8 >%5(L '>H>H(L $7[2(H(L $T,- >>HT,- 2=>H6,$- 2>H7[2(H3,- 2>H7[2(H`,'- $$%
%
>Hd,'&- %$>He,- $%
%>H7NFNf.7
$@%
9 +" #" " " +" F" " "' R WY"00"):"9LLA
"'48 "*"("2"EEE; ":2"'G>>>""9LLL@ 7""'WMRWY7R61""9LLGA :"0"'''G>>>""EEE
8/14/2019 Microsoft Excel - Curs de Utilizare
60/62
AE
(:=6+
>
8/14/2019 Microsoft Excel - Curs de Utilizare
61/62
A9
>%
8/14/2019 Microsoft Excel - Curs de Utilizare
62/62
9A PF:2+.:#0.(.2#> @A9G .#2(2:>2+.:>2@A9K (.M>2+.:>2 @G9L 7.>22f.#>727:>.((2 @G
%%
Top Related