Excel 2007 Intermedio

90

description

Dispensa Excel 2007 Intermedio

Transcript of Excel 2007 Intermedio

Page 1: Excel 2007 Intermedio
Page 2: Excel 2007 Intermedio
Page 3: Excel 2007 Intermedio

Non è sempre possibile essere precisi nella descrizione dei

comandi, anche perché questi variano, nelle varie versioni e con i numerosi ag-

giornamenti del sistema e degli applicativi. Se trovate cose inesatte o sbagliate, vi

chiedo di segnalarmele per le successive

Versioni della dispensa scrivendo a:

Grazie

Page 4: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� � �

,�,�Q�QR�RP�PL�L�

,�QRPL�3HU� RJJL� VRVSHQGLDPR� XQ� SR¶� OD� SUHVHQWD]LRQH� GL� QXRYH� IXQ]LRQL� �QRQ�SUHRFFXSDWHYL��GRPDQL�YH�QH�SURSRUUHPR�XQ�SDLR���&L�RFFXSLDPR�SLXWWRVWR�GL�XQD�SRVVLELOLWj�RIIHUWD�GD�([FHO�FKH�SXz�UHQGHUH�PROWR�SL��SUDWLFR��IXQ]LRQDOH�H�YHORFH�O¶LQVHULPHQWR�GL�IRUPXOH�H�IXQ]LRQL��6L�WUDWWD�GHL�QRPL�GD�DVVHJQDUH�DOOH�FHOOH��

5LFRUGDWH� OD� OH]LRQH� ���� LQ� FXL� DEELDPR� GRYXWR� ILVVDUH� LQ� YDORUH� DVVROXWR� LO�ULIHULPHQWR� DG� XQD� FHOOD�� SHU� SRWHUOD� XVDUH� LQ� XQD� IXQ]LRQH� GD� WUDVFLQDUH"�(EEHQH� LQ� TXHVWD� OH]LRQH� YL� SURSRQLDPR� XQD� VROX]LRQH� GLYHUVD� DO� SUREOHPD��XVDQGR�L�QRPL��/D�FHOOD�GD�ILVVDUH�LQ�YDORUH�DVVROXWR�HUD�+��FKH�FRQWLHQH�OD�TXRWD�DVVRFLDWLYD�ILVVD�GD�VRPPDUH�DO�WRWDOH�GL�WXWWH�OH�JLWH��)LJXUD�����

)LJXUD���±�/D�FHOOD�LQ�YDORUH�DVVROXWR�

'RYUHPR�TXLQGL�DVVHJQDUH�XQ�QRPH�D�TXHVWD�FHOOD�LQ�PRGR�GD�IDUH�ULIHULPHQWR�DG�HVVD�FRQ�LO�VXR�QRPH�H�QRQ�FRQ�LO�ULIHULPHQWR�FRORQQD�ULJD��+����9HGLDPR�FRPH�IDUH��)DWH�FOLF�VX�+��H�SRUWDWHYL�DOOD�VFKHGD�)RUPXOH�GHOOD�EDUUD�PXOWLIXQ]LRQH��1HO�JUXSSR�1RPL�GHILQLWL��SUHPHWH�LO�SXOVDQWH�'HILQLVFL�QRPH��([FHO�YL�PRVWUHUj�OD�ILQHVWUD�'HILQLVFL�QRPH��)LJXUD����

Page 5: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD�����/D�ILQHVWUD�'HILQLVFL�QRPH�

1RWDWH�FKH�([FHO�QHOOD�FDVHOOD�5LIHULWR�D�FL�PRVWUD��ILVVDWR�LQ�YDORUH�DVVROXWR��LO�ULIHULPHQWR�DOOD�FHOOD�D�FXL�VWLDPR�DVVHJQDQGR�LO�QRPH��([FHO� FL� SURSRQH� DQFKH� GL� DVVHJQDUH� DOOD� FHOOD� +�� LO� QRPH�TXRWDBGLBLVFUL]LRQHBILVVD� �OR� YHGHWH� QHOOD� FDVHOOD� GL� WHVWR� SL�� LQ� DOWR��ULFDYDQGROR�GDO�FRQWHQXWR�GHOOD�FHOOD�DFFDQWR��4XHVWR�QRPH�q�XQ�SR¶�WURSSR�OXQJR�SHU�HVVHUH�XVDWR�FRPRGDPHQWH��q�PHJOLR�VRVWLWXLUOR�FRQ�XQR�SL��LPPHGLDWR��&DQFHOODWH�LO�QRPH�SURSRVWR�H�VRVWLWXLWHOR�FRQ�³,VFUL]LRQH´��)LJXUD�����

)LJXUD���±�&DPELDUH�LO�QRPH�

2UD� FKH� DYHWH� GHFLVR� FKH� QRPH� GDUH� DOOD� FHOOD�� SUHPHWH� LO� SXOVDQWH� 2.� SHU�FRQFOXGHUH�OD�SURFHGXUD�H�WRUQDUH�DO�IRJOLR�GL�ODYRUR��3RWHWH�DFFHUWDUYL�FKH�LO�QRPH�q�VWDWR�GHILQLWR��RVVHUYDQGR�OD�FDVHOOD�GHO�QRPH��RYYLDPHQWH�+��GHYH�HVVHUH�OD�FHOOD�DWWLYD���SULPD�GHOOD�GHILQL]LRQH�GHO�QRPH�TXL�OHJJHYDWH�LO�ULIHULPHQWR�FRORQQD�ULJD�GHOOD�FHOOD��2UD�F¶q�LO�VXR�QRPH��)LJXUD����

Page 6: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�, O�QRPH�QHOOD�FDVHOOD�GHO�QRPH�

4XHVWR� QRPH� SXz� HVVHUH� XVDWR� QHOOH� IRUPXOH�� &RUUHJJLDPR�TXLQGL� OD� IRUPXOD�GHOOD�FHOOD�(��LQ�TXHVWR�PRGR� 6200$�%��'���LVFUL]LRQH��,O�ULVXOWDWR�GHOOD�IXQ]LRQH�QRQ�FDPELD��)LJXUD�����

)LJXUD���±�/D�IXQ]LRQH�FKH�XVD�XQ�QRPH�

2UD�WUDVFLQDWH�OD�IXQ]LRQH�YHUVR�LO�EDVVR��WXWWR�IXQ]LRQD�D�SHUIH]LRQH��

, O�QRPH�SHU�XQ�LQWHUYDOOR�GL�FHOOH�2OWUH�FKH�DG�XQD�VLQJROD�FHOOD��q�SRVVLELOH�DVVHJQDUH�XQ�QRPH�DG�XQ�LQWHUYDOOR�H�SRL�XVDUOR�QHOOH�IXQ]LRQL��3URYLDPR�DG�DVVHJQDUH�XQ�QRPH�DOO¶LQWHUYDOOR�%��%��H�SRL�XVDUH�TXHVWR�QRPH�SHU�FDOFRODUH�OD�PHGLD��6HOH]LRQDWH� OH� FHOOH� %��%��� QHO� JUXSSR� 1RPL� GHILQLWL�� SUHPHWH� LO� SXOVDQWH�'HILQLVFL�QRPH�GHOOD�VFKHGD�)RUPXOH��([FHO�YL�PRVWUHUj�OD�ILQHVWUD�'HILQLVFL�QRPH��)LJXUD�����

)LJXUD���±�'HILQLUH�XQ�QXRYR�QRPH�

4XHVWD� YROWD� LO� QRPH� FKH� FL� SURSRQH� ([FHO�� 3XOOPDQ�� YD� EHQLVVLPR�� SUHPHWH�$JJLXQJL�H�SRL�2N�SHU�FRQFOXGHUH�OD�SURFHGXUD�

Page 7: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

$QFKH�LQ�TXHVWR�FDVR��OD�FDVHOOD�GHO�QRPH��PRVWUD�LO�QRPH�DSSHQD�GHILQLWR��4XDQGR� DYHWH� GHILQLWR� GHL� QRPL�� OD� FDVHOOD� GHO� QRPH�� YLHQH� DUULFFKLWD� GD� XQ�HOHQFR�D�GLVFHVD�FRQ�WXWWL� L�QRPL�GHILQLWL�QHOOD�FDUWHOOD�GL� ODYRUR� LQ�XVR��%DVWD�IDUH�FOLF�VX�XQ�QRPH�SHU�VHOH]LRQDUH� UDSLGDPHQWH�OH�FHOOD�D�FXL�ID� ULIHULPHQWR��)LJXUD�����

)LJXUD���±�, �QRPL�GHOOD�FDUWHOOD�GL�ODYRUR�

7RUQLDPR� DO� QRVWUR� HVHPSLR�� )DFFLDPR� FOLF� QHOOD� FHOOD� %�� H� VFULYLDPR� OD�IXQ]LRQH� 0HGLD�SXOOPDQ���$SSHQD� XVFLDPR� GDOOD� FHOOD� ([FHO� FDOFROD� LO� ULVXOWDWR� GHOOD� IXQ]LRQH�� 3RWHWH�FRQIURQWDUOR� FRQ� TXHOOR� RWWHQXWR� XVDQGR� L� ULIHULPHQWL� GL� FHOOD�� LO� ULVXOWDWR� QRQ�FDPELD��2YYLDPHQWH� LQ� TXHVWR� FDVR�� QRQ� SRVLDPR� WUDVFLQDUH� OD� IXQ]LRQH�YHUVR� GHVWUD�SHU� FDOFRODUH� PHGLD� GHOOH� DOWUH� FRORQQH�� SHUFKp� WUDVFLQDQGR� LO� ULIHULPHQWR� D�SXOOPDQ� QRQ� VL� DJJLRUQD� �OR� DEELDPR� VSHULPHQWDWR� DQFKH� QHOO¶HVHPSLR�SUHFHGHQWH�� H� OD� IRUPXOD� YLHQH� FRSLDWD� WDOH� H� TXDOH� �)LJXUD� ���� QRQ� YHQH�DJJLRUQDWD��LO�FKH�QRQ�DYUHEEH�PROWR�VHQVR��

)LJXUD���±�/D�IRUPXOD�YLHQH�FRSLDWD�QRQ�DJJLRUQDWD�

'HULYDUH�L�QRPL�GDOOH�LQWHVWD]LRQL�GL�ULJD�H�FRORQQD�3LXWWRVWR�VDUHEEH�XWLOH�GHILQLUH�XQ�QRPH�SHU�WXWWH�OH�FRORQQH��LQ�TXHVWR�PRGR��&��&�� �%LJOLHWWRBGLBLQJUHVVR��'��'�� �3DVWR��(��(� 7RWDOH��

9HGLDPR� FRPH� SURFHGHUH�� 6HOH]LRQDWH� OH� FHOOH� GD� &�� D� (��� SRL� VHPSUH� QHO�JUXSSR� 1RPL� GHILQLWL� GHOOD� VFKHGD� )RUPXOH� SUHPHWH� LO� SXOVDQWH� &UHD� GD�VHOH]LRQH�� ([FHO�YL�PRVWUHUj�OD�ILQHVWUD�&UHD�QRPL�GD�VHOH]LRQH��)LJXUD����

Page 8: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD�����/D�ILQHVWUD�&UHD�QRPL�

4XHVWD�ILQHVWUD�YL�FKLHGH�GRYH�WURYDUH�L�QRPL�SHU�JOL�LQWHUYDOOL��,Q�TXHVWR�FDVR�L�QRPL� VL� WURYDQR� QHOOH� LQWHVWD]LRQL� GHOOH� FRORQQH�� FLRq� QHOOD� ULJD� SL�� LQ� DOWR�QHOO¶LQWHUYDOOR� VHOH]LRQDWR�� 6FHJOLHWH� GXQTXH� O¶RS]LRQH� 5LJD� VXSHULRUH�� SRL�SUHPHWH�2N��,�QRPL�VRQR�SURQWL�FRPH�YL�PRVWUD�OD�FDVHOOD�GHO�QRPH��)LJXUD������

)LJXUD����±�, �QXRYL�QRPL�

6H�VHOH]LRQDWH�RJQL�QRPH�SRWUHWH�YHGHUH�D�TXDOH�FHOOH�FRUULVSRQGH��/D�)LJXUD����PRVWUD�O¶LQWHUYDOOR�FRUULVSRQGHQWH�DO�QRPH�3DVWR��

)LJXUD����±�/¶LQWHUYDOOR�3DVWR�

1RWDWH� LO� QRPH� %LJOLHWWRBGLBLQJUHVVR�� VLFFRPH� L� QRPL� QRQ� SRVVRQR� FRQWHQHUH�VSD]L� YXRWL��SHU�GHULYDUH� LO� QRPH�GDOO¶HWLFKHWWD�GL� FRORQQD��([FHO�DJJLXQJH� IUD�XQD�SDUROD�H�O¶DOWUD�GHL�WUDWWLQL�EDVVL��B��R�XQGHUVFRUH��

Ê�SRVVLELOH�ULFDYDUH�L�QRPL�DQFKH�GDOOH�LQWHVWD]LRQL�GL�ULJD��DG�HVHPSLR��%��'��SRWUHEEHUR� FKLDPDUVL� *LWDBDB*DUGDODQG�� %��'�� VL� GRYUj� FKLDPDUH�*LWDBDOO¶DFTXDULRBGLB*HQRYD�H�FRVu�YLD�

Page 9: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

3URYLDPR�D�IDUOR�LQVLHPH��6HOH]LRQLDPR�OH�FHOOH�$��'���SRL�VFHJOLDPR�,QVHULVFL�‡�1RPH�‡�&UHD��4XHVWD�YROWD�QHOOD�ILQHVWUD�&UHD�QRPL��([FHO�KD�JLj�LQGLYLGXDWR�FKH�O¶RS]LRQH�JLXVWD�q�&RORQQD�VLQLVWUD��)LJXUD������

)LJXUD����±�&UHDUH�L�QRPL�GDOOH�LQWHVWD]LRQL�GL�FRORQQD�

&RQIHUPDWH�SUHPHQGR�2N��,�QXRYL�QRPL�VRQR�SURQWL��)LJXUD������

)LJXUD����±�, �QXRYL�QRPL

Page 10: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� � �

$�$Q�QF�FR�RU�UD�D�I�IX�XQ�Q]�]L�LR�RQ�QL�L�

$QFRUD�IXQ]LRQL�

'RSR�OD�SDXVD�GHOOD�VFRUVD�OH]LRQH��RJJL�YL�SURSRQJR�DOFXQH�DOWUH�IXQ]LRQL��1RQ�KR�FHUWR�OD�SUHWHVD�GL�SURSRUYHOH�WXWWH��DQFKH�SHUFKp�VRQR�WDQWLVVLPH��PD�VROR�GDUYL�XQ¶LGHD�GL�FLz�FKH�SRWHWH�WURYDUH��Ê�RYYLR�FKH�FLDVFXQR�GL�YRL�XVDQGR�OD� JXLGD� LQ� OLQHD� R� OD� ILQHVWUD� ,QVHULVFL� IXQ]LRQH� SRWUj� ULFHUFDUH� H�VSHULPHQWDUH�OH�IXQ]LRQL�FKH�VHUYRQR�DO�VXR�ODYRUR��3HU� WURYDUH� O¶HOHQFR� FRPSOHWR� GHOOH� IXQ]LRQL� GLVSRQLELOL� LQ� ([FHO� HG� XQD�GHVFUL]LRQH�GHO�ORUR�XWLOL]]R��SURFHGHWH�FRPH�VHJXH��$SULWH�OD�JXLGD�LQ�OLQHD�GL�([FHO�XVDQGR�LO�SXOVDQWH� �)LJXUD�����

)LJXUD���±�$SULUH�OD�JXLGD�LQ�OLQHD�GL�([FHO�

([FHO� YL�PRVWUHUj� LO� ULTXDGUR� GHOOD�*XLGD� LQ� OLQHD� ([FHO� �(UURUH�� /RULJLQH�ULIHULPHQWR�QRQ�q�VWDWD�WURYDWD����1HO�ULTXDGUR�GL�VLQLVWUD�q�SUHVHQWH�LO�VRPPDULR�GHOOD�JXLGD��6FHJOLHWH�OD�YRFH�*XLGD�GL�ULIHULPHQWR�DOOH�IXQ]LRQL��)LJXUD�����$� TXHVWR� SXQWR� SRWHWH� VFHJOLHUH� OD� FDWHJRULD� FKH� ID� SHU� YRL� H� DQDOL]]DUH� OH�IXQ]LRQL�FKH�FRQWLHQH�

Page 11: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�7URYDUH�O¶HOHQFR�GHOOH�IXQ]LRQL�H�OD�ORUR�GHVFUL]LRQH�

/D�IXQ]LRQH�6(�4XHVWD� IXQ]LRQH� YL� SHUPHWWH� ³IDUH� TXDOFRVD´� QHO� IRJOLR� GL� ODYRUR� VROR� VH� VL�YHULILFD�XQD�GDWD�FRQGL]LRQH��,QL]LDPR� FRQ� XQ� HVHPSLR� VHPSOLFH�� &RQWLQXLDPR� FRQ� O¶HVHPSLR� GHOOD� VFRUVD�OH]LRQH��)LJXUD�����

)LJXUD���±�, �GDWL�GL�SDUWHQ]D�

1HOOD� FRORQQD� )� YRJOLDPR� LQVHULUH� OD� VFULWWD� &DUR� VH� LO� FRVWR� WDWH� GHOOD� JLWD� q�PDJJLRUH� GL� ¼� ������� DOWULPHQWL� VFULYHUHPR� DFFHWWDELOH�� 9HGLDPR� FRPH�SURFHGHUH��

)DWH� FOLF� QHOOD� FHOOD� )��� SRL� DSULWH� OD� ILQHVWUD� ,QVHULVFL� IXQ]LRQH� H�� IUD� OH�IXQ]LRQL�ORJLFKH��FHUFDWH�OD�IXQ]LRQH�6H��)LJXUD����

Page 12: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�/D�IXQ]LRQH�6(�

([FHO� YL� PRVWUHUj� OD� ILQHVWUD� $UJRPHQWL� IXQ]LRQH�� FKH� SHU� OD� IXQ]LRQH� 6H�SUHYHGH�WUH�FDVHOOD�GD�FRPSLODUH��)LJXUD�����

)LJXUD���±�*OL�DUJRPHQWL�GHOOD�IXQ]LRQH�6(�

,O�SULPR�DUJRPHQWR�ULFKLHGH�GL�VSHFLILFDUH� LO�FULWHULR� LQ�EDVH�DO�TXDOH�VL�GHFLGH�TXDOH�RSHUD]LRQH�HVHJXLUH��2FFRUUH�VSHFLILFDUH�XQ�FULWHULR�R�XQD�RSHUD]LRQH�FKH�UHVWLWXLVFD�XQ�YDORUH�ERROHDQR�RVVLD�XQ�YDORUH�WLSR�9HUR�R�)DOVR�

Page 13: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

6H� O¶RSHUD]LRQH�VSHFLILFDWD� LQ�TXHVWR�DUJRPHQWR�UHVWLWXLVFH�FRPH�YDORUH�9HUR��DOORUD� ([FHO� HVHJXH� O¶RSHUD]LRQH� VSHFLILFDWD� QHO� FDPSR� 6HBYHUR�� VH�� LQYHFH��UHVWLWXLVFH�)DOVR��DOORUD�HVHJXH�O¶D]LRQH�VSHFLILFDWD�LQ�6HBIDOVR��&RPSOLFDWR"� 1R� SL�� GLIILFLOH� D� VSLHJDUVL� FKH� D� IDUVL�� &RPSOHWLDPR� LO� QRVWUR�HVHPSLR�H� WXWWR�VDUj�SL��FKLDUR��*OL�DUJRPHQWL�GHYRQR�HVVHUH�FRPSLODWL�FRPH�QHOOD�)LJXUD����

)LJXUD���±�*OL�DUJRPHQWL�GHOOD�IXQ]LRQH�6(�FRPSOHWDWL�

4XDQWR� DEELDPR� VFULWWR� VLJQLILFD�� YHULILFD� VH� LO� FRQWHQXWR� GHOOD� FHOOD� (�� q�PDJJLRUH�GL�����VH�OR�q�DOORUD�VFULYL�&DUR��VH�QRQ�OR�q�VFULYL�$FFHWWDELOH��1RWDWH�FKH�DSSHQD�XVFLWH�GDOOD�FDVHOOD�6HBYHUR�LO�WHVWR�FKH�DYHWH�VFULWWR�YLHQH�SRVWR� IUD�YLUJROHWWH��4XHVWR�DYYLHQH�SHUFKp�VL� WUDWWD�GL�XQD�VWULQJD� �WHUPLQH�WHFQLFR�SHU�GHILQLUH�LO�WHVWR��H�OH�VWULQJKH�QHOOH�IXQ]LRQL�YDQQR�VHPSUH�SRVWH�IUD�YLUJROHWWH��9RL�SRWHWH�QRQ�SUHRFFXSDUYHQH��LQIDWWL��VH�XVDWH�OD�ILQHVWUD�LQVHULVFL�IXQ]LRQH�� FL� SHQVHUj� ([FHO� DG� LQVHULUH� OH� YLUJROHWWH� DO� ORUR� SRVWR�� VH�� LQYHFH��SUHIHULWH� VFULYHUH� OD� IXQ]LRQH� GLUHWWDPHQWH� QHOOD� FHOOD�� QRQ� SRWHWH�DVVROXWDPHQWH�GLPHQWLFDUYL�OH�YLUJROHWWH��DOWULPHQWL�OD�IXQ]LRQH�QRQ�IXQ]LRQHUj��

&RPXQTXH�� TXDQGR� DYHWH� ILQLWR� FRQ� JOL� DUJRPHQWL�� SUHPHWH� 2N� H� WRUQDWH� DO�IRJOLR�GL�ODYRUR��SHU�WUDVFLQDWH�OD�IXQ]LRQH�SHU�WXWWD�OD�FRORQQD��)LJXUD�����

)LJXUD���±�/D�IXQ]LRQH�QHO�IRJOLR�GL�ODYRUR

Page 14: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)RUVH�q�XQD�SUHFLVD]LRQH�LQXWLOH��PD�JLj�FKH�FL�VLDPR«�1HOOD�ULJD���YHGLDPR�OD�VFULWWD� $FFHWWDELOH�� LQIDWWL� LO� FRQWHQXWR� GL� (�� QRQ� q� PDJJLRUH� GL� ���� PD� q�XJXDOH� D� ���� 6H� DYHVVLPR� YROXWR� FRQVLGHUDUH� FDUD� DQFKH� TXHVWD� JLWD�� OD�FRQGL]LRQH�GD�YHULILFDUH�GRYHYD�HVVHUH�(�! ����FLRq�(���SRL�GD�WUDVFLQDUH��q�PDJJLRUH� R� XJXDOH� �! �� D� ���� $OO¶RSHUDWRUH� PDJJLRUH� R� XJXDOH� �! ��FRUULVSRQGH�O¶RSHUDWRUH�PLQRUH�R�XJXDOH��� ���

3ULPD�GL�FRQFOXGHUH�FRQ�OD� IXQ]LRQH�6H��FHUFKLDPR�GL�FDSLUH�FRPH� IDUH�D�QRQ�VFULYHUH� QXOOD� QHOOD� FHOOD� VH� OD� FRQGL]LRQH� QRQ� VL� YHULILFD�� 1RQ� SRVVLDPR�VHPSOLFHPHQWH� QRQ� VFULYHUH� QXOOD� QHOO¶DUJRPHQWR� 6HBIDOVR�� LQIDWWL�� LQ� TXHVWR�FDVR�([FHO� VFULYHUHEEH�)$/62�QHOOD� FHOOD�TXDQGR� OD� FRQGL]LRQH�QRQ�VL� YHULILFD��)LJXUD�����

)LJXUD���±�([FHO�VFULYH�)DOVR�VH�OD�FRQGL]LRQH�QRQ�VL�YHULILFD�

3HU�ODVFLDUH�YXRWD�OD�FHOOD�RFFRUUH�FRUUHJJHUH�FRVu�OD�IXQ]LRQH�

6(�(�!����&DUR������

2VVLD�O¶DUJRPHQWR�6HBIDOVR�GHYH�HVVHUH�FRVWLWXLWR�GD�YLUJROHWWH�DSHUWH�H�VXELWR�FKLXVH��4XHVWR�LQGLFD�DG�([FHO�GL�LQVHULUH�QHOOD�FHOOD�XQD�VWULQJD�YXRWD��)LJXUD�����RVVLD�XQ�WHVWR�QXOOR��

)LJXUD���±�8QD�VWULQJD�YXRWD

Page 15: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)XQ]LRQH�2JJL���3HU� FRQFOXGHUH� TXHVWD� OH]LRQH� YL� SURSRQJR� OD� IXQ]LRQH� 2JJL��� FKH� DSSXQWR�UHVWLWXLVFH� OD�GDWD�FRUUHQWH��FLRq� OD�GDWD�GL�RJJL� ����2JQL�JLRUQR� OD�GDWD�YLHQH�DJJLRUQDWD�VXOOD�EDVH�GHOOD�GDWD�GHO�YRVWUR�3&��3RQHWHYL�LQ�XQD�FHOOD�TXDOXQTXH�H��IUD�OH�IXQ]LRQL�GL�GDWD�H�RUD�� LQGLYLGXDWH�OD�IXQ]LRQH� RJJL����1RWHUHWH�FKH�OD�IXQ]LRQH�2JJL�QRQ�ULFKLHGH�DUJRPHQWL��)LJXUD������

)LJXUD����±�/D�ILQHVWUD�$UJRPHQWL�IXQ]LRQH�SHU�OD�IXQ]LRQH�2JJL�

,Q�TXHVWR�FDVR�q�SL��UDSLGR�VFULYHUH�OD�IXQ]LRQH�GLUHWWDPHQWH�D�PDQR�QRQ�IRJOLR�GL� ODYRUR�� PD� ULFRUGDWHYL� FKH� DQFKH� VH� OD� IXQ]LRQH� QRQ� KD� DUJRPHQWL�� QRQ�SRWHWH��FRPXQTXH��WUDODVFLDUH�OH�SDUHQWHVL�WRQGH�DOOD�ILQH��

,O� ULVXOWDWR� GHOOD� IXQ]LRQH� RJJL� q� XQD� GDWD� H� SRWHWH� IRUPDWWDUOD� FRPH� WDOH��ULFRUUHQGR�DOOD�ILQHVWUD�)RUPDWR�FHOOH��6H�QRQ�ULFRUGDWH�FRPH�GHILQLUH�LO�IRUPDWR�GL�XQD�GDWD��DKL��DKL�DKL«����ULSDVVDWH�OD�OH]LRQH���

Page 16: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� � �

/�/H�H�I�IX�XQ�Q]�]L�LR�RQ�QL�L�Q�QL�LG�GL�LI�IL�LF�FD�DW�WH�H�

/H�IXQ]LRQL�QLGLILFDWH�

([FHO�YL�SHUPHWWH�GL�LQVHULUH�XQD�IXQ]LRQH�GHQWUR�O¶DOWUD�R�XQD�IXQ]LRQH�GHQWUR�XQD� IRUPXOD�� /D� IXQ]LRQH� ³LQWHUQD´� ID� GD� DUJRPHQWR� D� TXHOOD� SL�� HVWHUQD�� 6L�SDUOD� GL� IXQ]LRQL� QLGLILFDWH��8QD� IRUPXOD� SXz� FRQWHQHUH� ILQR� D� VHWWH� OLYHOOL� GL�IXQ]LRQL�QLGLILFDWH��,QFRPLQFLDPR� FRQ� XQ� HVHPSLR� VHPSOLFH�� XVDQGR� GHOOH� IXQ]LRQL� FKH� JLj�FRQRVFHWH��SRL�YL�SURSRUUHPR�TXDOFRVD�GL�SL��³XWLOH´��/¶HVHPSLR� q� VHPSUH� TXHOOR� GHOOH� OH]LRQL� VFRUVH�� 6H� ULFRUGDWH�� QHOOD� ULJD� ��DYHYDPR�FDOFRODWR�L�YDORUL�PHGL�GHOOH�FRORQQH�%��&�H�'��)LJXUD�����

)LJXUD���±�, O�SURVSHWWR�GL�SDUWHQ]D�

2UD��VH�YRJOLDPR�FDOFRODUH�FRQ�OD�IXQ]LRQH�0D[�LO�YDORUH�SL��DOWR�IUD�TXHVWH�WUH�SRWUHPPR� SURFHGHUH� LQ� GXH� PRGL�� ,O� SL�� VHPSOLFH� q� XVDUH� OD� IXQ]LRQH� 0D[�IDFHQGR�ULIHULPHQWR�DO�FRQWHQXWR�GHOOH�FHOOH�%���&��HG�(���VFULYHQGR�LQ�XQD�FHOOD�TXDOXQTXH�OD�IXQ]LRQH� 0D[�%��'����)LJXUD�����

)LJXUD���±�, O�YDORUH�PDVVLPR�IUD�OH�PHGLH

Page 17: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

2SSXUH�SRVVLDPR�FDOFRODUH�OD�PHGLD�DOO¶LQWHUQR�GHOOD�IXQ]LRQH�PD[��3URYLDPR�D�IDUOR�LQVLHPH��)DWH�FOLF�LQ�XQD�FHOOD�TXDOVLDVL��SRL�FRQ�O¶XVR�GHOOD�ILQHVWUD�,QVHULVFL�IXQ]LRQH�R�GDOOD�EDUUD�PXOWLIXQ]LRQH�LQVHULWH�OD�IXQ]LRQH�0D[��4XHVWD� YROWD� QRQ� DEELDPR� XQ� LQWHUYDOOR� GL� FHOOH� LQ� FXL� WURYDUH� LO� YDORUH�PDVVLPR�� PD� WUH� YDORUL� �SRFR� LPSRUWD� FKH� OL� FDOFROHUHPR� FRQ� OD� IXQ]LRQH�PHGLD��� TXLQGL� RJQL� YDORUH� YD� LQVHULWR� LQ� XQD� FDVHOOD� GLYHUVD� GHOOD� ILQHVWUD�DUJRPHQWL��&RPLQFLDPR�DG�LQVHULUH�LO�SULPR�YDORUH��OD�PHGLD�GHOO¶LQWHUYDOOR�D�FXL�DYHYDPR�DVVHJQDWR�LO�QRPH�3XOOPDQ��6FULYHWH�GXQTXH��PHGLD�SXOOPDQ��QHOOD�FDVHOOD�GHO�SULPR�DUJRPHQWR��)LJXUD�����

)LJXUD���±�, O�SULPR�DUJRPHQWR�

1RWDWH�FKH�OD�IXQ]LRQH�³LQWHUQD´�QRQ�GHYH�HVVHUH�SUHFHGXWD�GDO�VHJQR�XJXDOH�� ���TXHOOR�YHUUj�VFULWWR�XQD�VROD�YROWD�DOO¶LQL]LR�GHOOD�IXQ]LRQH�SULQFLSDOH��

'RSR�DYHU� VFULWWR� LO� SULPR�DUJRPHQWR��SDVVDWH�DOOD� FDVHOOD�SHU� LO� VHFRQGR�FKH�VDUj�PHGLD�%LJOLHWWRBGLBLQJUHVVR��H�SRL�D�TXHOOD�GHO�WHU]R��FKH�QHO�IUDWWHPSR�q�GLYHQWDWD�YLVLELOH��FKH�VDUj�PHGLD�SDVWR���)LJXUD����

Page 18: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�7XWWL�JOL�DUJRPHQWL�GHOOD�IXQ]LRQH�

/D�IXQ]LRQH�q�ILQLWD��SUHPHWH�2N�SHU�LQVHULUOD�QHO�IRJOLR�GL�ODYRUR��)LJXUD�����

)LJXUD���±�/D�IXQ]LRQH�QHO�IRJOLR�GL�ODYRUR�

/H�WUH�IXQ]LRQL�PHGLD�VRQR�QLGLILFDWH�QHOOD�IXQ]LRQH�0D[��

&HUFKLDPR� RUD� GL� SURSRUUH� XQ� HVHPSLR� SL�� XWLOH�� DQFKH� VH� XQ� SR¶� SL��FRPSOHVVR�� 8VHUHPR� OD� IXQ]LRQH� SURGRWWR� FKH� UHVWLWXLVFH� DSSXQWR� LO� SURGRWWR�GHL� YDORUL� HOHQFDWL� FRPH� VXRL� DUJRPHQWL�� $G� HVHPSLR�� SURGRWWR������UHVWLWXLVFH����2VVHUYDWH�LO�SLFFROR�SURVSHWWR�GHOOD�)LJXUD���

Page 19: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�, O�SURVSHWWR�GL�SDUWHQ]D�

9RJOLDPR� FDOFRODUH� OD� SURYYLJLRQH� FKH� VSHWWD� D� FLDVFXQ� YHQGLWRUH�� /D�SURYYLJLRQH� q� SDUL� DO�����GHO� YHQGXWR� VH� LO� YHQGXWR� q�PDJJLRUH� GL� ¼��������DOWULPHQWL�q�GHOO¶����

3HU� GLUH� DG� ([FHO� FKH� GHYH� FRPSRUWDUVL� LQ�PRGR� GLYHUVR� LQ� VLWXD]LRQL� GLYHUVH�GREELDPR�ULFRUUHUH�DOOD�IXQ]LRQH�6(��SRL�SHU�FDOFRODUH� OD�SURYYLJLRQH�XVHUHPR�OD�IXQ]LRQH�SURGRWWR�SHU�PROWLSOLFDUH�LO�FRQWHQXWR�GHOOH�FHOOH�GHOOD�FRORQQD�&�SHU�����������R������������

)DWH�FOLF�QHOOD�FHOOD�'��H�LQVHULWH�OD�IXQ]LRQH�6(��$�TXHVWR�SXQWR��FRPH�SULPR�DUJRPHQWR� VFULYHWH�&�!������3DVVDWH�D� FRPSLODUH� O¶DUJRPHQWR�6HBYHUR��3HU�LQVHULUH� OD� IXQ]LRQH�SURGRWWR�DYHWH�GXH�SRVVLELOLWj�� VFULYHUOD� FRPSOHWDPHQWH�D�PDQR�LQ�TXHVWR�FDPSR�RSSXUH�IDUYL�DLXWDUH�GDOOD�ILQHVWUD�LQVHULVFL�IXQ]LRQH��1HO�SULPR� FDVR� GRYHWH� VFULYHUH� SURGRWWR�&�������� QHO� VHFRQGR� VFULYHWH� VROR�SURGRWWR��)LJXUD�����

)LJXUD���±�,QVHULUH�LO�SURGRWWR

Page 20: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

$�TXHVWR�SXQWR��ODVFLDQGR�DSHUWD�OD�ILQHVWUD�$UJRPHQWL�IXQ]LRQH��VXOOD�EDUUD�GHOOD�IRUPXOD�IDWH�FOLF�VXOOD�VFULWWD�SURGRWWR��OD�ILQHVWUD�$UJRPHQWL�IXQ]LRQH�YL�PRVWUHUj�JOL�DUJRPHQWL�GHOOD�IXQ]LRQH�SURGRWWR��)LJXUD�����

)LJXUD���±�*OL�DUJRPHQWL�GHOOD�IXQ]LRQH�SURGRWWR�

'REELDPR�LQVHULUH�QHOOH�GLYHUVH�FDVHOOH�L�IDWWRUL�GD�PROWLSOLFDUH��1XP��VDUj�&���VFULYHWHOR�R�VHOH]LRQDWHOR�GDO�IRJOLR�GL�ODYRUR���PHQWUH�1XP��VDUj������

2UD� GREELDPR� WRUQDUH� LQGLHWUR� DJOL� DUJRPHQWL� GHOOD� IXQ]LRQH� 6(� SHU� ILQLUH� GL�FRPSOHWDUH�O¶DUJRPHQWR�6HBIDOVR��9L�EDVWHUj�IDUH�FOLF�VXOOD�SDUROD�6H�VXOOD�EDUUD�GHOOD� IRUPXOD�� OD� ILQHVWUD� $UJRPHQWL� IXQ]LRQH� YL� PRVWUHUj� GL� QXRYR� JOL�DUJRPHQWL�GHOOD�IXQ]LRQH�6H�FRQ�OD�IXQ]LRQH�QLGLILFDWD�SURGRWWR�RSSRUWXQDPHQWH�FRPSLODWD��)LJXUD����

Page 21: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�*OL�DUJRPHQWL�GHOOD�IXQ]LRQH�6H�

&RQ�TXHVWD�VWHVVD�WHFQLFD�FRPSLODWH� O¶DUJRPHQWR�6HBIDOVR�FKH�GRYUj�ULVXOWDUH�3URGRWWR�&���������3RL� WRUQDWH�DJOL� DUJRPHQWL�GHOOD� IXQ]LRQH�6H�FKH�RUD� VRQR�FRPSOHWL��)LJXUD������

)LJXUD����±�*OL�DUJRPHQWL�GHOOD�IXQ]LRQH�6H�FRPSOHWL�

3UHPHWH� 2N� SHU� FRQFOXGHUH� OD� IXQ]LRQH�� $SSOLFDWH� DOOD� FHOOD� (�� LO� IRUPDWR�FRQWDELOLWj� R� YDOXWD�� SRL� WUDVFLQDWHOD� SHU� WXWWD� OD� FRORQQD� �(UURUH�� /RULJLQH�ULIHULPHQWR�QRQ�q�VWDWD�WURYDWD���

Page 22: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� �

Page 23: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� � �

,�,�I�IL�LO�OW�WU�UL�L�

,�ILOWUL�

2OWUH� DG� HVHJXLUH� FDOFROL� VXL� GDWL� �OR� DEELDPR� LPSDUDWR� SHU� EHQH�QHOOH� VFRUVH�OH]LRQL��� ([FHO� YL� SHUPHWWH� DQFKH� GL� HODERUDUH� L� GDWL�� 8Q� SULPR� WLSR� GL�HODERUD]LRQH�q�LO� ILOWUDJJLR��SRVVLDPR�FLRq�HVWUDSRODUH�GD�XQ�HOHQFR�VROR� L�GDWL�FKH�ULVSRQGRQR�D�GHWHUPLQDWL�FULWHUL��3DUWLDPR�GD�XQ�HVHPSLR�VHPSOLFH��/D�)LJXUD���PRVWUD�XQ�ILOH�SHU�OD�JHVWLRQH�GL�XQ�PDJD]]LQR��

)LJXUD���±�, O�ILOH�GL�SDUWHQ]D�

1HOOD�FRORQQD�'�OHJJLDPR�LO�QXPHUR�GHL�SH]]L�FKH�DEELDPR�LQ�PDJD]]LQR��QHOOD�FRORQQD�(�LO�TXDQWLWDWLYR�PLQLPR�GL�SURGRWWR�FKH�YRJOLDPR�DYHUH�LQ�PDJD]]LQR��1HOOD�FRORQQD�+��FRQ�OD�IXQ]LRQH�6(��QRQ�GRYUHVWH�DYHU�SUREOHPL�D�FDSLUH�FRVD�DEELDPR�IDWWR���IDFFLDPR�LQ�PRGR�FKH�FRPSDLD�OD�VFULWWD�GD�ULRUGLQDUH�TXDQGR�LO�YDORUH�GHOOD�FRORQQD�'�q�SL��EDVVR�GHO��FRUULVSRQGHQWH�YDORUH�GHOOD�FRORQQD�(��

2UD�YRJOLDPR�RWWHQHUH�XQ�HOHQFR�GL�VROL�SURGRWWL�GD�ULRUGLQDUH��6L�WUDWWD��FLRq��GL�PRVWUDUH�VROR�OH�ULJKH�LQ�FXL�QHOOD�FRORQQD�+�FRPSDUH�OD�VFULWWD�GD�ULRUGLQDUH�

Page 24: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

/D�VROX]LRQH�SL��VHPSOLFH�q�TXHOOD�GL�ULFRUUHUH�DG�XQ�ILOWUR�DXWRPDWLFR��)DWH� FOLF� LQ� XQ� SXQWR� TXDOVLDVL� DOO¶LQWHUQR� GHOO¶HOHQFR� H� SRUWDWHYL� DOOD� VFKHGD�'DWL� GHOOD� EDUUD� PXOWLIXQ]LRQH�� 4XL�� QHO� JUXSSR� 2UGLQD� H� ILOWUD�� SUHPHWH� LO�SXOVDQWH�)LOWUD��([FHO� PRVWUHUj� GHOOH� SLFFROH� IUHFFH� LQ� FRUULVSRQGHQ]D� GHOOH� LQWHVWD]LRQL� GL�FRORQQD��)LJXUD�����

)LJXUD���±�3 LFFROH�IUHFFH�VXOOH�LQWHVWD]LRQL�GL�FRORQQD�

6H� IDWH� FOLF� VXOOD� IUHFFHWWLQD� GL� FLDVFXQD� FRORQQD�� QRWHUHWH� FKH� YL� VL� DSUH� XQ�HOHQFR� D� GLVFHVD� FRQ� WXWWH� OH� YRFL� GHOOD� FRORQQD�� SUHVH� XQD� YROWD� VROD�� SL��DOFXQH�DOWUH�YRFL�XJXDOL�LQ�WXWWH�OH�FRORQQH��$� QRL� LQWHUHVVD� ODYRUDUH� VXOOD� FRORQQD� +�� SHU� FXL� DSULWH� LO� UHODWLYR� PHQX� D�GLVFHVD��)LJXUD�����

)LJXUD���±�, O�PHQX�GHOOD�FRORQQD�+�

/DVFLDWH� VHOH]LRQDWD� VROR� OD�YRFH�GD� ULRUGLQDUH��([FHO� YL�SUHVHQWD� OH� VROH� ULJKH�GHOO¶HOHQFR� FKH�GHOO¶HOHQFR� FKH� SUHVHQWDQR� TXHVWD� YRFH� QHOOD� FRORQQD� +

Page 25: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

��

)LJXUD�����

)LJXUD���±�/¶HOHQFR�ILOWUDWR�

1RWDWH� FKH�RUD�YHGLDPR�VROR� WUH� ULJKH�H� OR� ORUR� LQWHVWD]LRQL� VRQR�PRVWUDWH� LQ�EOX��DG�LQGLFDUH�YLVLYDPHQWH�FKH�VL�WUDWWD�GHO�ULVXOWDWR�GL�XQ�ILOWUR��$FFDQWR�DOOD�IUHFFLQD�GHOOD� FRORQQD�VX�FXL�DEELDPR�HVHJXLWR�LO�ILOWUR�q�FRPSDUVR�XQ�SLFFROR�LPEXWR��FRVu�VDUj�IDFLOH�LGHQWLILFDUH�LPPHGLDWDPHQWH�D�TXDOH�FRORQQD�q�VWDWR�DSSOLFDWR�LO�ILOWUR��

6H�RUD�YRJOLDPR�YHGHUH�QXRYDPHQWH�WXWWR�O¶HOHQFR��EDVWD�VFHJOLHUH�6HOH]LRQD�WXWWR�GDOO¶HOHQFR� D� GLVFHVD� GHOOD� FRORQQD� D� FXL� DEELDPR� DSSOLFDWR� LO� ILOWUR�� QHO�QRVWUR� FDVR� OD� +�� /H� IUHFFH� GHO� ILOWUR� QRQ� VFRPSDLRQR�� PD� YHGLDPR� WXWWH� OH�ULJKH��

6H� YROHWH� ULPXRYHUH� OH� IUHFFH�� FLRq� XVFLUH� GDOOD� PRGDOLWj� ILOWUR�� SUHPHWH�QXRYDPHQWH�LO�SXOVDQWH�)LOWUR��3HU� RUD� ULPDQLDPR� LQ� PRGDOLWj� ILOWUR� H� IDFFLDPR� DOWUH� SURYH�� SHU� HVSORUDUH�TXHVWD�IXQ]LRQH��

,PPDJLQLDPR� GL� YROHU� YHGHUH� VROR� L� SURGRWWL� GL� FXL� DEELDPR� XQD� JLDFHQ]D� LQ�PDJD]]LQR� VXSHULRUH� D� ����� SH]]L�� RVVLD� YRJOLDPR� ILOWUDUH� OH� ULJKH� FKH�PRVWUDQR�QHOOD�FRORQQD�'�XQ�QXPHUR�PDJJLRUH�GL�������

6H�QRQ� OR�DYHWH�DQFRUD� IDWWR�� ULPXRYHWH� LO� ILOWUR�GDOOD� FRORQQD�+��SRL� DSULWH� LO�PHQX�D�GLVFHVD�UHODWLYR�DOOD�FRORQQD�'�H�VFHJOLHWH�OD�YRFH�)LOWUD�SHU�QXPHUL�‡�0DJJLRUH�GL��)LJXUD����

Page 26: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�, O�PHQX�GHO�ILOWUR�GHOOD�FRORQQD�'�

([FHO�YL�PRVWUHUj�OD�ILQHVWUD�3HUVRQDOL]]D�ILOWUR�DXWRPDWLFR��)LJXUD�����

)LJXUD�����/D�ILQHVWUD�3HUVRQDOL]]D�ILOWUR�DXWRPDWLFR�

'DO� SULPR� HOHQFR� D� GLVFHVD� VFHJOLHWH� OD� YRFH� PDJJLRUH� GL� H�� QHOO¶HOHQFR�DFFDQWR�� VFULYHWH� ������ $� TXHVWR� SXQWR� SUHPHWH� LO� SXOVDQWH� 2N� SHU� ILOWUDUH�O¶HOHQFR��)LJXUD����

Page 27: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�/¶HOHQFR�ILOWUDWR�

(� VH� LQYHFH� GL� YHGHUH� L� SURGRWWL� GL� FXL� DEELDPR�XQD� VFRUWD� VXSHULRUH� D� �����SH]]L��YROHVVLPR�YHGHUH�L�SURGRWWL�GL�FXL�DEELDPR�XQD�VFRUWD�VXSHULRUH�D������SH]]L��PD�LQIHULRUH�D������SH]]L"��

$YHWH�GXH�SRVVLELOLWj�R�ULPXRYHUH�LO�ILOWUR�H�ULFRPLQFLDUH�GD�FDSR�R�FRUUHJJHUH�LO�ILOWUR�HVLVWHQWH��3URYLDPR�TXHVWD�VHFRQGD�SRVVLELOLWj��6HQ]D�ULPXRYHUH�LO�ILOWUR��DSULWH�GL�QXRYR�LO�PHQX�GHOOD�FRORQQD�'�H�VFHJOLHWH�GL�QXRYR�)LOWUD�SHU�QXPHUL�‡�0DJJLRUH�GL��([FHO� YL� DSULUj� GL� QXRYR� OD� ILQHVWUD� 3HUVRQDOL]]D� ILOWUR� DXWRPDWLFR� JLj�FRPSLODWD�FRQ�OH�LPSRVWD]LRQL�FKH�DYHWH�GHILQLWR�SULPD��)LJXUD�����

)LJXUD���±�/H�LPSRVWD]LRQL�GHO�ILOWUR�

1RL�DEELDPR�ELVRJQR�GL�VSHFLILFDUH�XQ�VHFRQGR�FULWHULR�SHU�LO�ILOWUR��QRQ�VROR�LO�YDORUH� GHYH�HVVHUH�PDJJLRUH� GL�������PD� DQFKH� LQIHULRUH� D� ������'REELDPR�FRPSLODUH�LO�VHFRQGR�JUXSSR�GL�HOHQFKL�D�GLVFHVD��1RWDWH� FKH� TXHVWR� VHFRQGR� JUXSSR� q� VHSDUDWR� GDO� SULPR� FRQ� GHL� SXOVDQWL� GL�RS]LRQH��$1'�H�25��4XHVWL�SXOVDQWL�SHUPHWWRQR�GL�VSHFLILFDUH�LO�PRGR�VH�OD�ULJD�GHYH�HVVHUH�ILOWUDWD�VH�VL�YHULILFDQR�HQWUDPEH�OH�FRQGL]LRQL��$1'��R�DOPHQR�XQD�GHOOH�GXH��25��

Page 28: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

1HO�QRVWUR� FDVR��SHUFKp� OD� ULJD�VLD� ILOWUDWD�DEELDPR�ELVRJQR�FKH�VL� YHULILFKLQR�HQWUDPEH� OH� FRQGL]LRQL�� DOWULPHQWL� YHUUHEEHUR� PRVWUDWH� DQFKH� OH� ULJKH� FKH�FRQWHQJRQR� XQ� YDORUH� PLQRUH� GL� ����� �LQ� TXDQWR� VRGGLVIDQR� OD� VHFRQGD�FRQGL]LRQH��FLRq�VRQR�PLQRUL�GL�������H�OH�ULJKH�FRQ�YDORUL�PDJJLRUL�GL�������LQ�TXDQWR�VRGGLVIDQR�OD�SULPD�FRQGL]LRQH��FLRq�VRQR�PDJJLRUL�GL��������1HO� QRVWUR� FDVR� RFFRUUH� GXQTXH� VFHJOLHUH� $1'� �FKH�� WUD� O¶DOWUR� q� O¶RS]LRQH�SUHGHILQLWD��H�SURYYHGHUH�D�FRPSLODUH�LO�VHFRQGR�FULWHULR��)LJXUD�����

)LJXUD���±�, O�VHFRQGR�FULWHULR�

3UHPHWH�2.�SHU�FRQFOXGHUH�OD�SURFHGXUD�

Page 29: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� � �

,�,�I�IL�LO�OW�WU�UL�L�����

,�ILOWUL���

,O�ILOWUR�DXWRPDWLFR��YL�SUHPHWWH�DQFKH�GL�ILOWUDUH�OH�FHOOH�LQ�EDVH�FRORUL��1HOOD� PRVWULDPR� XQD� WDEHOOD� LQ� FXL� L� SURGRWWL� OH� FXL� FRQIH]LRQL� KDQQR� XQ�FRQWHQXWR�GL�����JU�VRQR�HYLGHQ]LDWH�FRQ�XQR�VIRQGR�FRORUDWR��3URYLDPR�D�ILOWUDUH�OH�ULJKH�FKH�FRQWHQJRQR�TXHVWH�FHOOH�FRORUDWH��

)LJXUD�����/D�WDEHOOD�GD�ILOWUDUH�

9RJOLDPR�ILOWUDUH�VROR� OH� ULJKH�FKH�FRQWHQJRQR�OH�FHOOH�FRQ�OR�VIRQGR�FRORUDWR��3HU�SULPD�FRVD��DSSOLFDWH�LO�ILOWUR�FRPH�DEELDPR�VSLHJDWR�LHUL��4XHVWD� YROWD� GDOOD� WHQGLQD� GHO� ILOWUR� GHOOD� FRORQQD� FKH� FRQWLHQH� L� YDORUL� GD�ILOWUDUH��OD�FRORQQD�&��QHOOHVHPSLR��RFFRUUH�VFHJOLHUH�OD�YRFH�6FHJOLHWH�OD�YRFH�)LOWUD�SHU�FRORUH�H�TXLQGL�LO�FRORUH�GD�ILOWUDUH��)LJXUD����

Page 30: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�)LOWUDUH�SHU�FRORUH�

'DOOD� )LJXUD� �� QRWDWH� FKH� ROWUH� FKH� ILOWUDUH� LQ� EDVH� DG� XQ� FRORUH� q� SRVVLELOH�DQFKH�RUGLQDUH� L� GDWL� LQ�EDVH�DG�XQ�FRORUH�� FRQ� OD�YRFH�2UGLQD�SHU� FRORUH��'L�RUGLQDPHQWL�SDUOHUHPR�LQ�XQD�SURVVLPD�OH]LRQH��

([FHO� DXWRPDWLFDPHQWH� YL� PRVWUHUj� VROR� OH� FHOOH� FKH� SUHVHQWDQR� LO� FRORUH�VHOH]LRQDWR��)LJXUD�����

)LJXUD���±�/H�FHOOH�FRORUDWH�ILOWUDWH�

)LOWUR�DYDQ]DWR�3HU� ILOWUDUH� L� YRVWUL� HOHQFKL� ([FHO� YL� PHWWH� D� GLVSRVL]LRQH� DQFKH� XQ� DOWUR�VWUXPHQWR�� FLRq� LO� )LOWUR�DYDQ]DWR�� ,�GXH� WLSL� GL� ILOWUL� YL� SHUPHWWR�GL� RWWHQHUH�SL�� R� PHQR� JOL� VWHVVL� ULVXOWDWL�� PD� LO� ILOWUR� DYDQ]DWR� KD� LO� YDQWDJJLR� GL

Page 31: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

SUHPHWWHUYL�DQFKH�GL�FUHDUH�XQ�QXRYR�HOHQFR�FRQ�VROR�L�GDWL�ILOWUDWL�H�PDQWHQHUH�LQWDWWR�O¶HOHQFR�RULJLQDOH��

3URYLDPR�VXELWR��3DUWLDPR�GD�XQ�ILOH�VLPLOH�D�TXHOOR�GHOOD�VFRUVD�OH]LRQH��3HU� DSSOLFDUH� LO� ILOWUR� DXWRPDWLFR� RFFRUUH� SUHSDUDUH� RSSRUWXQDPHQWH� LO� IRJOLR��DJJLXQJHWH� LQ�DOWR�����ULJKH�YXRWH�LQ�FLPD�DOO¶HOHQFR�H�QHOOH�SULPD�ULJD�YXRWD�FRSLDWH�OH�LQWHVWD]LRQL�GL�FRORQQD�GHO�YRVWUR�HOHQFR��)LJXUD�����

)LJXUD���±�/¶HOHQFR�SUHSDUDWR�SHU�LO�ILOWUR�DXWRPDWLFR�

/¶DUHD� YXRWD� FRQ� OH� LQWHVWD]LRQL� FRSLDWH� VHUYLUj� FRPH� LQWHUYDOOR� GHL� FULWHUL��RVVLD�VDUj�OR�VSD]LR�LQ�FXL�VFULYHUHPR�L�FULWHUL�SHU�LO�ILOWUR��

,PPDJLQLDPR�GL� YROHU� FUHDUH� XQ� QXRYR� HOHQFR� FKH� FRQWHQJD� VROR� OH� YHUGXUH��7URYLDPR� TXHVWD� LQIRUPD]LRQH� QHOOD� FRORQQD� &�� q� TXHOOD� D� FXL� GRYUHPR�DSSOLFDUH�LO�ILOWUR��

%DVWHUj�VFULYHUH�YHUGXUH�QHOO¶DUHD�GHL�FULWHUL�LQ�FRUULVSRQGHQ]D�GHOOD�FRORQQD�&�QHOOD�SULPD�FHOOD�YXRWD��)LJXUD�����

)LJXUD���±�, �FULWHUL�SHU�LO�ILOWUR�

2UD�L�FULWHUL�VRQR�SURQWL��1RQ�FL�UHVWD�FKH�DSSOLFDUH�LO�ILOWUR�

Page 32: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)DWH�FOLF� LQ�XQ�SXQWR�TXDOVLDVL�GHOO¶HOHQFR�H�QHO�JUXSSR�2UGLQD�H� ILOWUD� GHOOD�VFKHGD�'DWL��SUHPHWH�LO�SXOVDQWH�$YDQ]DWH��([FHO�YL�PRVWUHUj�OD�ILQHVWUD�)LOWUR�DYDQ]DWR��)LJXUD�����

)LJXUD�����/D�ILQHVWUD�)LOWUR�DYDQ]DWR�

6H� O¶HOHQFR� KD� WXWWH� OH� LQWHVWD]LRQL� GHOOH� FRORQQH�� ([FHO� QRQ� DYUj� SUREOHPL� H�VHOH]LRQDUH� FRUUHWWDPHQWH� O¶HOHQFR� GD� ILOWUDUH� H� LQGLFDUQH� OH� FRRUGLQDWH� QHOOD�FDVHOOD�,QWHUYDOOR�HOHQFR��6H�QRQ�ULHVFH�IDWHOR�PDQXDOPHQWH��8QD�YROWD�GHILQLWR�O¶HOHQFR�GRYHWH�VSHFLILFDUH�GRYH�VL�WURYDQR�L�FULWHUL��IDWH�FOLF�QHOOD�FDVHOOD�,QWHUYDOOR�FULWHUL�H�LQVHULWH�TXL�OH�FRRUGLQDWH�GHO�YRVWUR�LQWHUYDOOR�R�GLJLWDQGROH�R�VHOH]LRQDQGROH�GDO�IRJOLR�GL�ODYRUR��)LJXUD�����

)LJXUD���±�6SHFLILFDUH�O¶LQWHUYDOOR�GHL�FULWHUL�

'DWR�FKH�YRJOLDPR�FUHDUH�XQ�QXRYR�HOHQFR�FRQ�L�VROL�GDWL�ILOWUDWL��QHOOD�VH]LRQH�$]LRQH�� VHOH]LRQDWH� O¶RS]LRQH�&RSLD� LQ� XQ¶DOWUD� SRVL]LRQH�� ([FHO� DWWLYHUj� LO�FDPSR�&RSLD� LQ� LQ� FXL� GRYHWH� LQGLFDUH� OD� FRRUGLQDWD� GHOOD� SULPD� FHOOD� GD� FXL�GHYH� LQL]LDUH� LO� QXRYR�HOHQFR��1RL�DEELDPR�VFHOWR�GL� FRPLQFLDUH�D� ULVFULYHUH� LO�QXRYR�HOHQFR�GDOOD�FHOOD�3���)LJXUD����

Page 33: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�6SHFLILFDUH�OD�SRVL]LRQH�GHO�QXRYR�HOHQFR�

2UD�DEELDPR�LQGLFDWR�WXWWR�TXHOOR�FKH�RFFRUUH��SUHPHWH�2N�SHU�FUHDUH�LO�QXRYR�HOHQFR�ILOWUDWR��)LJXUD�����

)LJXUD���±�, O�QXRYR�HOHQFR�

3XUWURSSR�LO�ILOWUR�DYDQ]DWR�QRQ�FL�SHUPHWWH�GL�FRSLDUH�LO�QXRYR�HOHQFR�ILOWUDWR�LQ�XQ�QXRYR�IRJOLR��PD�VROR�QHO�IRJOLR�DWWLYR��6H�YL�RFFRUUH�LQVHULUH�LO�QXRYR�HOHQFR�LQ�XQ�QXRYR�IRJOLR��GRYHWH�VHOH]LRQDUOR�H�WDJOLDUOR�GDOOD�SRVL]LRQH�LQ�FXL�OD�DYHWH�FUHDWR�H�SRL�FRSLDUOR�QHO�QXRYR�IRJOLR��

&RQVLGHUDWH�DQFKH� FKH��XQD�YROWD� FKH�DYHWH� FUHDWR� LO�QXRYR�HOHQFR��TXHVWR�q�GLVWLQWR�GDOO¶HOHQFR�RULJLQDOH��6H� PRGLILFDWH� O¶HOHQFR� RULJLQDOH�� TXHOOR� ILOWUDWR� QRQ� FDPELD�� VH� YROHWH� FKH� OH�QRYLWj�VL�ULIOHWWDQR�DQFKH�VXOO¶HOHQFR�ILOWUDWR��GRYHWH�ULJHQHUDUH�TXHVW¶XOWLPR��

)LOWUR�DYDQ]DWR�FRQ�GXH�R�SL��FULWHUL�&RQ� L� ILOWUL� DXWRPDWLFL�� DEELDPR� LPSDUDWR� DG� DSSOLFDUH� DQFKH� GXH� ILOWUL� LQ�FRQWHPSRUDQHD��Ê�SRVVLELOH�RWWHQHUH�OR�VWHVVR�ULVXOWDWR�FRQ�LO�ILOWUR�DYDQ]DWR��&RQWLQXLDPR� FRQ� O¶HVHPSLR� SUHFHGHQWH� �KR� FRSLDWR� LO� ULVXOWDWR� GHO� ILOWUR�SUHFHGHQWH�LQ�XQ�QXRYR�IRJOLR��TXLQGL�LO� IRJOLR�LQ�FXL�q�O¶HOHQFR�q��SHU�FRVu�GLUH�SXOLWR���,PPDJLQLDPR�GL�YROHU�ILOWUDUH�L�GROFL�FKH�KDQQR�XQ�SUH]]R�G¶DFTXLVWR�LQIHULRUH�DL���HXUR��,O�SUH]]R�G¶DFTXLVWR�VL�WURYD�QHOOD�FRORQQD�*��9RJOLDPR� FKH� VLDQR� YHULILFDWH� HQWUDPEH� OH� FRQGL]LRQL�� SHU� FXL� GRYUHPR�VFULYHUOH�VXOOD�VWHVVD�ULJD�GHOO¶LQWHUYDOOR�GHL�FULWHUL��FRPH�QHOOD�)LJXUD���

Page 34: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD����±�'XH�FULWHUL�GD�YHULILFDUH�LQ�FRQWHPSRUDQHD�

2UD�VLDPR�SURQWL�DG�DSSOLFDUH�LO�ILOWUR��&RPH�SULPD��QHO�JUXSSR�2UGLQD�H�ILOWUD�GHOOD�VFKHGD�'DWL��SUHPHWH�LO�SXOVDQWH�$YDQ]DWH��([FHO�YL�PRVWUHUj�OD�ILQHVWUD�)LOWUR� DYDQ]DWR�� 1HOOD� ILQHVWUD� )LOWUR� DYDQ]DWR� WURYDWH� JLj� FRPSLODWR�� ROWUH�DOO¶LQWHUYDOOR�GHOO¶HOHQFR��DQFKH�TXHOOR�GHL�FULWHUL��)LJXUD������

)LJXUD����±�/D�ILQHVWUD�)LOWUR�DYDQ]DWR�

([FHO� OR� ³ULFRUGD´� GD� SULPD�� ,QIDWWL�� RJQL� YROWD� FKH� VL� XVD� XQ� ILOWUR� DYDQ]DWR�([FHO� DVVHJQD� LO� QRPH� &ULWHUL� �)LJXUD� ���� DOO¶LQWHUYDOOR� FKH� DEELDPR� GHILQLWR�FRPH�LQWHUYDOOR�GHL�FULWHUL��

)LJXUD����±�/¶LQWHUYDOOR�FRQ�QRPH�&ULWHUL�

,QVRPPD�YL�ULPDQH�VROR�GD�VSHFLILFDUH� OD�SRVL]LRQH�GL�GHVWLQD]LRQH�GHOO¶HOHQFR�ILOWUDWR��

6H�YROHWH� ILOWUDUH� L�GDWL� LQ�PRGR�FKH�ULVSRQGDQR�DG�DOPHQR�XQD�IUD�GXH�R�SL��FRQGL]LRQL��GRYHWH�VFULYHUH�OH�YDULH�FRQGL]LRQL�VX�ULJKH�GLYHUVH�QHOO¶LQWHUYDOOR�GHL�FULWHUL��$G�HVHPSLR��OD�)LJXUD����PRVWUD�O¶LQWHUYDOOR�GHL�FULWHUL��FKH�SRUWHUHEEH�D�FUHDUH� O¶HOHQFR�GL� WXWWL� JOL� VWX]]LFKLQL�H�GL� WXWWL� L� SURGRWWL� GD� ULRUGLQDUH� �DQFKH�QRQ�VWX]]LFKLQL��

Page 35: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD����±�, �FULWHUL�

1DWXUDOPHQWH�ULVSHWWR�DJOL�HVHPSL�SUHFHGHQWL��O¶LQWHUYDOOR�GHL�FULWHUL�q�FDPELDWR��SHU�FLz��DQFKH�VH�([FHO�YL�SURSRQH�JLj�O¶LQWHUYDOOR�GHL�FULWHUL�QHOOD�ILQHVWUD�)LOWUR�DYDQ]DWR�� GRYHWH�PRGLILFDUOR� RSSRUWXQDPHQWH� DJJLXQJHQGR� XQD� ULJD� �)LJXUD������

)LJXUD����±�6SHFLILFDUH�LO�JLXVWR�LQWHUYDOOR�GHL�FULWHUL�

/D�)LJXUD����YL�PRVWUD�O¶HOHQFR�ULVXOWDQWH��

)LJXUD������/HOHQFR�ILOWUDWR

Page 36: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� � �

,�,�I�IL�LO�OW�WU�UL�L�����

,Q� TXHVWD� OH]LRQH� HVSORUHUHPR� DOFXQH� FDUDWWHULVWLFKH� DYDQ]DWH� GHL� ILOWUL��&RPLQFHUHPR�DG�HVSORUDUH�XQD�LQWHUHVVDQWH�SRWHQ]LDOLWj�GHL�ILOWUL�DYDQ]DWL��

(OHQFR�XQLYRFR�3DUWLDPR�GD�XQ�ILOH�FRPH�TXHOOR�GHOOD�)LJXUD����

)LJXUD���±�, O�ILOH�GL�SDUWHQ]D�

,PPDJLQLDPR�GL�YROHU�FUHDUH�XQ�HOHQFR�XQLYRFR�GL�WXWWL�L�WLSL�GL�DWWLYLWj�SUHVHQWL�QHOO¶HOHQFR��&RPH�IDUH"�,O�ILOWUR�DYDQ]DWR�FL�YLHQH�LQ�DLXWR��2YYLDPHQWH�� SHU� TXHO� OLPLWH� LQWULQVHFR� GHO� ILOWUR� DXWRPDWLFR� GL� FXL� DEELDPR�SDUODWR� QHOOD� VFRUVD� OH]LRQH�� O¶HOHQFR� GHOOH� DWWLYLWj� GHYH� HVVHUH� FUHDWR� QHOOR�VWHVVR�IRJOLR�GL�ODYRUR�FKH�FRQWLHQH�O¶HOHQFR�GL�RULJLQH��1LHQWH�FL�YLHWD��XQD�YROWD�FUHDWR��GL�VSRVWDUOR�GRYH�FL�VHUYH�

Page 37: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

4XHVWD� YROWD� QRQ� FL� VHUYRQR� FULWHUL�� D� QRL�� LQIDWWL�� VHUYRQR� WXWWL� L� GDWL� GHOOD�FRORQQD�� SUHVL� XQD� YROWD� VROD�� SHU� FXL� QRQ� RFFRUUH� SUHSDUDUH� XQ¶DUHD� GHL�FULWHUL��1RQ�FL�VHUYH�QHPPHQR�DYHUH�WXWWH�OH�FRORQQH�GHOO¶HOHQFR��D�QRL�VHUYRQR�VROR�L�GDWL� GHOOD� FRORQQD�&�� VHOH]LRQDWHOD� IDFHQGR�FOLF� VXOOD� VXD� LQWHVWD]LRQH��SRL� QHO�JUXSSR�2UGLQD�H�ILOWUD� GHOOD�VFKHGD�'DWL��SUHPHWH�LO�SXOVDQWH�$YDQ]DWH��/D�ILQHVWUD�)LOWUR�DYDQ]DWR�q�JLj�FRPSLODWD�SHU�TXDQWR�ULJXDUGD�O¶HOHQFR�G¶RULJLQH��VSHFLILFDWH�XQD�SRVL]LRQH�GL�GHVWLQD]LRQH�H�VHOH]LRQDWH�O¶RS]LRQH�&RSLD�XQLYRFD�GHL�UHFRUG��)LJXUD�����

)LJXUD���±�/H�RS]LRQL�SHU�FUHDUH�XQ�HOHQFR�XQLYRFR�GL�GDWL�

2UD�SUHPHWH�2N�H�RWWHUUHWH�LO�YRVWUR�HOHQFR��)LJXUD�����

)LJXUD���±�/¶HOHQFR�

2UGLQDUH�LQ�EDVH�DOOD�ILQH�,O� VHFRQGR� HVHPSLR� FKH� YL� SURSRQLDPR� SUHYHGH� O¶XVR� GHL� ILOWUL� DXWRPDWLFL��,PPDJLQLDPR�GL�GRYHU� VLVWHPDUH�XQ� OLVWLQR�SUH]]L�XQ�SR¶� WURSSR� OXQJR�� FRPH�TXHOOR�GHOOD�)LJXUD���

Page 38: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�, �GDWL�GL�SDUWHQ]D�

&RQ� GHOOH� ULJKH� URVVH� KR� FHUFDWR� L� HYLGHQ]LDUH� LO� IDWWR� FKH� L� SUH]]L� GHL� QRVWUL�SURGRWWL�VRQR�XJXDOL�GHFLQD�SHU�GHFLQD��FLRq�(�������(�������(�������(�������(������ HG� (������ VRQR� XJXDOL�� (������� � (������� (������� (������� (�������(������VRQR�XJXDOL�H�FRVu�YLD��3HU� FRPSDWWDUH� LO� QRVWUR� OLVWLQR�� FL� EDVWHUHEEH� PRVWUDUH� XQD� VROD� YRFH� SHU�GHFLQD�GDOOD�TXDOH�VDUHEEH�IDFLOH�H�YHORFH�ULFDYDUH�L�SUH]]L�GHJOL�DOWUL�HOHPHQWL�GL�TXHOOD�GHFLQD��3HU� IDU�TXHVWR�SRVVLDPR� ULFRUUHUH�DO� ILOWUR�DXWRPDWLFR��$WWLYDWHOR�� FRPH�DYHWH�LPSDUDWR�QHOOH�VFRUVH�OH]LRQL�SRL�DSULWH�O¶HOHQFR�D�GLVFHVD�UHODWLYR�DOOD�FRORQQD�$�H�VFHJOLHWH�)LOWUD�SHU�WHVWR�‡�WHUPLQD�FRQ��([FHO� DSULUj� OD� ILQHVWUD� 3HUVRQDOL]]D� ILOWUR� DXWRPDWLFR� JLj� SDU]LDOPHQWH�FRPSLODWD��)LJXUD����

Page 39: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�3HUVRQDOL]]DUH�LO�ILOWUR�DXWRPDWLFR�

1HOOD�FDVHOOD�DFFDQWR�VFULYHWH�]HUR������LQ�TXHVWR�PRGR�FKLHGHUHPR�DG�([FHO�GL�PRVWUDUFL�VROR�OH�ULJKH�FKH��QHOOD�FRORQQD�$��FRQWHQJRQR�YDORUL�FKH�ILQLVFRQR�SHU����)LJXUD�����

)LJXUD���±�/H�LPSRVWD]LRQL�SHU�ILOWUDUH�OH�ULJKH�FKH�ILQLVFRQR�FRQ���

3UHPHWH�LO�SXOVDQWH�2N�SHU�DSSOLFDUH�LO�ILOWUR��(FFR�LO�ULVXOWDWR��)LJXUD����

Page 40: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�/¶HOHQFR�ILOWUDWR�

4XHVWR� VHPSOLFH� HVHPSLR� FL� q� VHUYLWR� SHU� PRVWUDUH� FKH� LO� ILOWUR� DXWRPDWLFR�SHUPHWWH� GLYHUVH� RSHUD]LRQL� GL� ILOWUDJJLR� DQFKH� VXO� FRQWHQXWR� GHOOH� FHOOH�� /D�)LJXUD���YL�PRVWUD�OH�YDULH�SRVVLELOLWj�FKH�DYHWH�D�GLVSRVL]LRQH��

)LJXUD���±�)LOWUL�VXO�WHVWR

Page 41: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

1RL� LQWDQWR�YL� SURSRQLDPR�XQ�DOWUR�HVHPSLR��$EELDPR�XQ�HOHQFR� FRPH�TXHOOR�GHOOD� )LJXUD� �� �OR� DEELDPR�GLYLVR� LQ� SL�� SDUWL� H� QH� DEELDPR�RPHVVR�XQD� SHU�TXHVWLRQL�GL� VSD]LR��PD��FRPH�YHGHWH�GDOOH� LQWHVWD]LRQL�GL� ULJD��VL� WUDWWD�GL�XQ�HOHQFR�XQLFR���

)LJXUD���±�, �GDWL�GL�SDUWHQ]D�

6L�WUDWWD�GL�SURGRWWL�SHU�OD�FXUD�GHL�FDSHOOL��YRJOLDPR�ILOWUDUH�VROR�JOL�VKDPSRR��FLRq�OH�ULJKH�FKH�FRQWHQJRQR�OD�SDUROD�VKDPSRR��$WWLYDWH�LO�ILOWUR�DXWRPDWLFR�H�VFHJOLDWH�)LOWUD�SHU�WHVWR�‡�&RQWLHQH�QHOO¶HOHQFR�D�GLVFHVD� GHO� ILOWUR� UHODWLYR� DOOD� � FRORQQD� %�� ([FHO� YL� PRVWUHUj� OD� ILQHVWUD�3HUVRQDOL]]D�ILOWUR�DXWRPDWLFR� JLj�SDU]LDOPHQWH�FRPSLODWD��&RPSOHWDWHOD�FRPH�PRVWUD�OD�)LJXUD����

)LJXUD����±�/D�ILQHVWUD�3HUVRQDOL]]D�ILOWUR�DXWRPDWLFR�FRPSLODWD

Page 42: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

$SSOLFDWH� LO� ILOWUR�� /D� )LJXUD� ��� PRVWUD� LO� ULVXOWDWR�� ,Q� WXWWH� OH� ULJKH� ILOWUDWH�OHJJHWH�OD�SDUROD�VKDPSRR��

)LJXUD����±�, O�ULVXOWDWR

Page 43: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� � �

2�2U�UG�GL�LQ�QD�DP�PH�HQ�QW�WR�R�

2UGLQDPHQWR�

2OWUH� DOOH� RSHUD]LRQL� GL� ILOWUR� VXL� GDWL�� q� SRVVLELOH� DQFKH� RWWHQHUH� GHJOL�RUGLQDPHQWL�VHPSOLFL�RSSXUH�SL��FRPSOHVVL��

&RPLQFLDPR�GD�GXH�FDVL� VHPSOLFL�� FRPH�SULPR�HVHPSLR��PHWWHUHPR� LQ�RUGLQH�DOIDEHWLFR�FUHVFHQWH�O¶HOHQFR�XQLYRFR�GL�DWWLYLWj�FKH�DEELDPR�RWWHQXWR�FRO�ILOWUR�DYDQ]DWR��

��

)LJXUD���±�/¶HOHQFR�GD�RUGLQDUH�

3RUWDWHYL� DOOD� VFKHGD�'DWL� H�QHO�JUXSSR�2UGLQD�H� ILOWUD��SUHPHWH� LO� SXOVDQWH�2UGLQDPHQWR�FUHVFHQWH�HYLGHQ]LDWR�FRQ�XQD�IUHFFLD�QHOOD�)LJXUD����

)LJXUD���±�, O�SXOVDQWH�2UGLQDPHQWR�FUHVFHQWH

Page 44: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� ��

8QD�YROWD�FKH�OR�DYHWH�RUGLQDWR��LO�YRVWUR�HOHQFR�DSSDULUj�FRPH�QHOOD�)LJXUD����

)LJXUD���±�/¶HOHQFR�RUGLQDWR�

1RWDWH�DOFXQH�FRVH��ß� ([FHO�KD�FDSLWR�FKH�OD�SULPD�ULJD�FRQWLHQH�XQD�LQWHVWD]LRQH�H�QRQ�OD�LQFOXGH�QHOO¶RUGLQDPHQWR�

ß� ,�GDWL�GHOOH�SULPH���FRORQQH�QRQ�VRQR�VWDWL�WRFFDWL�FRPH�SRWHWH�IDFLOPHQWH�YHULILFDUH�FRQIURQWDQGR�OD�)LJXUD���H�OD�)LJXUD����9LHQH�RUGLQDWR�VROR�O¶HOHQFR�VHOH]LRQDWR��LQ�TXHVWR�FDVR�FRVWLWXLWR�GD�XQD�VROD�FRORQQD��

3HU�YHULILFDUH�XOWHULRUPHQWH�TXDQWR�DEELDPR�GHWWR�QHOO¶XOWLPR�SXQWR��SURYLDPR�DG�RUGLQDUH�SHU�IDWWXUDWR�OH�ULJKH�GHOO¶HOHQFR�GL�VLQLVWUD�GDO�IDWWXUDWR�SL��DOWR�DO�SL��EDVVR��)DWH� FOLF�� GXQTXH�� DOO¶LQWHUQR� GL� TXHVWR� HOHQFR� H� SUHPHWH� LO� SXOVDQWH�2UGLQDPHQWR�GHFUHVFHQWH�HYLGHQ]LDWR�QHOOD�)LJXUD����

)LJXUD���±�, O�SXOVDQWH�2UGLQDPHQWR�GHFUHVFHQWH�

(FFR�O¶HOHQFR�GRSR�O¶RUGLQDPHQWR��)LJXUD����

Page 45: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�/¶HOHQFR�RUGLQDWR�

1RWDWH�FKH��

ß� 7XWWH�OH�FRORQQH�GHOO¶HOHQFR�VRQR�VWDWH�ULRUGLQDWH��QRQ�VROR�TXHOOD�XVDWD�SHU�O¶RUGLQDPHQWR�

ß� /¶HOHQFR�GL�GHVWUD�QRQ�q�VWDWR�WRFFDWR��

2UGLQDPHQWR�VX�SL��FRORQQH�)LQ� RUD� DEELDPR� RUGLQDWR� L� GDWL� LQ� EDVH� DG� XQD� VROD� FRORQQD�� PD� ([FHO� FL�SHUPHWWH� GL� RWWHQHUH� DQFKH� RUGLQDPHQWL� SL�� FRPSOHVVL�� $� HVHPSLR�� SRVVLDPR�RUGLQDUH�L�QRVWUL�GDWL�SHU�WLSR�GL�DWWLYLWj�H�SRL�SHU�IDWWXUDWR��FLRq�SULPD�WXWWL�JOL�DOLPHQWDUL�GD�TXHOOR�FRO�IDWWXUDWR�SL��DOWR�D�TXHOOR�FRO�IDWWXUDWR�SL��EDVVR��SRL�WXWWL�L�EDU�GD�TXHOOR�FRO�IDWWXUDWR�SL��DOWR�D�TXHOOR�FRO�IDWWXUDWR�SL��EDVVR�H�FRVu�YLD��1RQ�EDVWD�VHPSOLFHPHQWH�IDUH�L�GXH�RUGLQDPHQWL�SHUFKp�LO�VHFRQGR�VFRPELQHUj�FRPSOHWDPHQWH� LO� SULPR�H�RUGLQHUj� WXWWH� OH�DWWLYLWj�GD�TXHOOD� FRO� IDWWXUDWR�SL��DOWR�D�TXHOOD�FRO�IDWWXUDWR�SL��EDVVR��$OORUD�FRPH�SRVVLDPR�IDUH"�'REELDPR�ULFRUUHUH�DOOD�ILQHVWUD�2UGLQD��)LJXUD�����)DWH� FOLF� DOO¶LQWHUQR� GHOO¶HOHQFR�� SRL� SUHPHWH� LO� SXOVDQWH� 2UGLQD� QHO� JUXSSR�2UGLQD�H�ILOWUD�GHOOD�VFKHGD�'DWL�

Page 46: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD�����/D�ILQHVWUD�2UGLQD�

'DOO¶HOHQFR�D�GLVFHVD�2UGLQD�SHU�VHOH]LRQDWH�OD�FRORQQD�D�FXL�YROHWH�DSSOLFDUH�LO�SULPR� RUGLQDPHQWR� �QHO� QRVWUR� FDVR� VDUj� $WWLYLWj��� 3RL�� SUHPHWH� LO� SXOVDQWH�$JJLXQJL�OLYHOOR��$YUHWH�OD�SRVVLELOLWj�GL�VSHFLILFDUH� OD�FRORQQD�D�FXL�DSSOLFDUH�LO�VHFRQGR�RUGLQDPHQWR��QHO�QRVWUR�FDVR�IDWWXUDWR���6LFFRPH� YRJOLDPR� RUGLQDUH� GDO� IDWWXUDWL� SL�� DOWR� DO� SL�� EDVVR�� VHOH]LRQDWH�O¶RS]LRQH� 'DO� SL�� JUDQGH� DO� SL�� SLFFROR� QHOOD� FRORQQD� 2UGLQH� LQ�FRUULVSRQGHQ]D�GL�TXHVWR�VHFRQGR�FULWHULR�GL�RUGLQDPHQWR��/D�)LJXUD���PRVWUD�OD�ILQHVWUD�2UGLQD�GHELWDPHQWH�FRPSLODWD��

)LJXUD�����/D�ILQHVWUD�2UGLQH�FRPSLODWD�

$�TXHVWR�SXQWR�SUHPHWH�2N�SHU�RWWHQHUH�O¶RUGLQDPHQWR�GHVLGHUDWR��)LJXUD����

Page 47: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�/¶HOHQFR

Page 48: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� � �

,�,�J�JU�UD�DI�IL�LF�FL�L�

,�JUDILFL�

�JLXQWR�LO�PRPHQWR�GL�LPSDUDUH�D�UDSSUHVHQWDUH�YLVLYDPHQWH�L�QRVWUL�GDWL��XQ�EXRQ�JUDILFR�DOOH�YROWH�q�SL��HORTXHQWH�GL�SDJLQH�H�SDJLQH�GL�GDWL��

&RPLQFLDPR�FRQ�XQ�HVHPSLR�PROWR�VHPSOLFH��)LJXUD�����

)LJXUD���±�, �GDWL�GL�SDUWHQ]D�

Ê� XQD� SDUWH� GHOO¶HOHQFR� FKH� DEELDPR� XVDWR� QHOOD� VFRUVD� OH]LRQH�� 9RJOLDPR�UDSSUHVHQWDUH�FRQ�XQ�JUDILFR�LO�IDWWXUDWR�GHL�YDUL�HVHUFL]L�FRPPHUFLDOL��)DWH�FOLF�DOO¶LQWHUQR�GHOO¶HOHQFR�FKH�FRQWLHQH�L�GDWL��3RUWDWHYL�DOOD�VFKHGD�,QVHULVFL� GHOOD�EDUUD�PXOWLIXQ]LRQH��1HO�JUXSSR�*UDILFR�WURYDWH�WXWWR�FLz�FKH�RFFRUUH�SHU�FUHDUH�XQ�JUDILFR��)LJXUD�����

)LJXUD���±�*OL�VWUXPHQWL�SHU�LQVHULUH�XQ�JUDILFR

Page 49: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

/D�SULPD�RSHUD]LRQH�GD�IDUVL�q�TXHOOD�GL�VFHJOLHUH�LO�WLSR�GL�JUDILFR�FKH�VL�YXROH�UHDOL]]DUH� �,VWRJUDPPD�� JUDILFR� OLQHDUH�� JUDILFR� D� WRUWD�� JUDILFR� D� EDUUH�«�� H�DSULUH�LO�UHODWLYR�PHQX��)LJXUD�����

)LJXUD���±�&UHDUH�XQ�LVWRJUDPPD�

3ULPD�GL�SURVHJXLUH�QRQ�q�LQXWLOH�ULFRUGDUH�FKH�LO�WLSR�GL�JUDILFR�QRQ�YD�VFHOWR�D�FDVR��PD� GHYH� HVVHUH� DGHJXDWR� D� FLz� FKH� VL� YXROH� HVSULPHUH�� ,VWRJUDPPL� H�JUDILFL�D�EDUUH��DG�HVHPSLR��YL�SHUPHWWRQR�GL�FRQIURQWDUH�YDORUL�GLYHUVL��FRPH�DSSXQWR�L�IDWWXUDWL���XQ�JUDILFR�D�OLQHH�YL�PRVWUD�FRPH�VL�PRGLILFD�XQ�GDWR�QHO�WHPSR� �SHU� IDUH� XQ� HVHPSLR�� SRWUHPPR� UDSSUHVHQWDUH� FRQ� XQD� OLQHD� OH�TXRWD]LRQL�GHO�GROODUR�JLRUQR�SHU�JLRUQR«���&¶q��SRL�� LO� JUDILFR�D� WRUWD� FKH�YL� SHUPHWWH�GL� UDSSUHVHQWDUH�TXDQWR� OH� VLQJROH�SDUWL�LQFLGRQR�VX�XQ�WXWWR��DG�HVHPSLR�TXDQWR�LO�IDWWXUDWR�GHL�VLQJROL�YHQGLWRUL�LQFLGH�VXO�IDWWXUDWR�WRWDOH���'HGLFKHUHPR�OD�OH]LRQH����D�TXHVWR�WLSR�GL�JUDILFL��

1HO�QRVWUR�FDVR�XQ�LVWRJUDPPD�q�SHUIHWWR��SL��DYDQWL�IDUHPR�DOWUL�HVHPSL�FRQ�DOWUL�WLSL�GL�JUDILFR��FRPXQTXH�LO�SURFHGLPHQWR�q�VHPSUH�OR�VWHVVR��'RSR�DYHU�VFHOWR� LO�WLSR�GL�JUDILFR��GDO�PHQX�PRVWUDWR�QHOOD�)LJXUD��� ELVRJQD�VFHJOLHUH� OD� YDULDQWH� FKH� VL� GHVLGHUD� XWLOL]]DUH�� 3HU� TXHVWR� SULPR� HVHPSLR�VFHJOLDPR�LO�SULPR�JUDILFR�LQ�DOWR�D�VLQLVWUD��([FHO�LQVHULUj�XQ�JUDILFR�UHDOL]]DWR�FRQ� OH� LPSRVWD]LRQL� EDVH� H� DJJLXQJHUj� DOOD� EDUUD� PXOWLIXQ]LRQH� OH� VFKHGH�QHFHVVDULH�SHU�OD�JHVWLRQH�GHO�JUDILFR��)LJXUD����

Page 50: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�, O�VHFRQGR�SDVVDJJLR�GHOOD�FUHD]LRQH�JXLGDWD�

$YHWH�D�GLVSRVL]LRQH�QXPHURVH�RS]LRQL��1H�HVSORUHUHPR�TXDOFXQD��FRPLQFLDQGR�GDOOD� SRVVLELOLWj� GL� VSRVWDUH� LO� JUDILFR� GDO� IRJOLR� FRUUHQWH� D�XQ� QXRYR� IRJOLR� GL�ODYRUR�GHGLFDWR�HVFOXVLYDPHQWH�DG�RVSLWDUH�LO�JUDILFR���XQD�RSHUD]LRQH�PROWR�VHPSOLFH��EDVWD�VHOH]LRQDUH�LO�JUDILFR�H�YLVXDOL]]DUH�OD�VFKHGD�3URJHWWD]LRQH�GHJOL�6WUXPHQWL�JUDILFR��4XL��QHO�JUXSSR�3RVL]LRQH��SUHPHWH�LO�SXOVDQWH�6SRVWD�JUDILFR��OXOWLPR�D�GHVWUD���([FHO�YL�PRVWUHUj�OD�ILQHVWUD�6SRVWD�JUDILFR��)LJXUD�����4XL�VFHJOLHWH� ORS]LRQH�1XRYR� IRJOLR� HG�� HYHQWXDOPHQWH�� VSHFLILFDWH� LO� QRPH� FKH� YROHWH� DVVHJQDUH� DO�IRJOLR�GHO�JUDILFR��SRL�SUHPHWH�2N��

)LJXUD���±�/D�ILQHVWUD�6SRVWD�JUDILFR�

,O�JUDILFR�YLHQH�VSRVWDWR�LQ�XQ�IRJOLR�DXWRQRPR��)LJXUD����

Page 51: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�, O�JUDILFR�LQ�XQ�IRJOLR�DXWRQRPR�

�SRVVLELOH�PRGLILFDUH�OD�IRUPDWWD]LRQH�GL�XQ�JUDILFR�LQ�PRGR�UDSLGR�DSSOLFDQGR�XQR�GHJOL�VWLOL�H�GHOOH�FRPELQD]LRQL�GL�FRORUH�SUHLPSRVWDWH��6HOH]LRQDWH�LO�JUDILFR�H�SRUWDWHYL�QHOOD�VFKHGD�3URJHWWD]LRQH�GHJOL�6WUXPHQWL�JUDILFR��4XL� WURYDWH� LO�JUXSSR�6WLOL�JUDILFL� �)LJXUD�����SRWHWH�HVSDQGHUOR�FRQ�ODSSRVLWR� SXOVDQWH� D� IUHFFLQD� SHU� YLVXDOL]]DUH� WXWWL� L� QXPHURVL� VWLOL� D�GLVSRVL]LRQH��

)LJXUD���±�$SSOLFDUH�XQR�VWLOH�D�XQ�JUDILFR�

$OOD� VLQLVWUD�GHO�JUXSSR�6WLOL�JUDILFR�� WURYDWH� LO� JUXSSR�/D\RXW�JUDILFL� LQ� FXL�SRWHWH�VFHJOLHUH�GHL�OD\RXW�SUHGHILQLWL�SHU�LO�JUDILFR��4XHVWL�QRQ�LQIOXLVFRQR�VXOOD�IRUPDWWD]LRQH�GHO�JUDILFR��FRPH�JOL�VWLOL��PD�YL�SHUPHWWRQR�GL�PRVWUDUH�L�WLWROL��OD�OHJHQGD��OD�WDEHOOD�GHL�GDWL�«�LQ�GLYHUVH�FRPELQD]LRQL�

Page 52: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

6H� YHQJRQR� LQVHULWL� HOHPHQWL� WHVWXDOL� FRPH� L� WLWROL�� q� SRVVLELOH� FKH� YROJLDWH�FDPELDUOL�� LQ� TXHVWR� FDVR�� EDVWD� IDUH� GRSSLR� FOLF� VXOO¶HOHPHQWR� GD�PRGLILFDUH��4XHVWR�DSSDULUj�FLUFRQGDWR�GD�XQ�ULTXDGUR�GL�VHOH]LRQH��6HOH]LRQDWH�WXWWR�LO�WHVWR��FDQFHOODWHOR�H�VRVWLWXLWHOR�FRQ�XQ�WHVWR�SL��GHVFULWWLYR��6H�QRQ�YROHWH�XVDUH�XQR�GHL�OD\RXW�SUHLPSRVWDWL��PD�VFHJOLHUH�L�VLQJROL�HOHPHQWL�GD� LQVHULUH� QHO� YRVWUR� JUDILFR�� RFFRUUH� XWLOL]]DUH� OD� VFKHGD� /D\RXW� GHJOL�6WUXPHQWL�JUDILFR��)LJXUD�����

)LJXUD�����/D�VFKHGD�/D\RXW�GHJOL�6WUXPHQWL�JUDILFR�

1HO� JUXSSR� (WLFKHWWH�� WURYDWH� L� SXOVDQWL� UHODWLYL� DL� YDUL� HOHPHQWL� �WLWROR��OHJHQGD��QRPL�GHJOL�DVVL�«��GD�YLVXDOL]]DUH�QHO�JUDILFR��6H�IDWH�FOLF�VXO�SXOVDQWH�UHODWLYR� DOOHOHPHQWR� FKH� YL� LQWHUHVVD�� YHGUHWH� XQ� VRWWRPHQX� FRQ� GLYHUVH�RS]LRQL� UHODWLYH� DOOLQVHULPHQWR� GHOOHOHPHQWR� VWHVVR� �)LJXUD� ���� LQ� SDUWLFRODUH�UHODWLYL�DOOD�VXD�SRVL]LRQH��

)LJXUD���±�'LYHUVH�RS]LRQL�SHU�O¶LQVHULPHQWR�GHOOD�OHJHQGD�

8QD� YROWD� LQVHULWR� OHOHPHQWR�� VDUj� SRVVLELOH� PRGLILFDUOR� FRPH� DEELDPR� YLVWR�VRSUD�

Page 53: Excel 2007 Intermedio

([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

3HU�RJQL� WLSR�GL�HOHPHQWR�VRQR��FRPXQTXH��GLVSRQLELOL�DQFKH�XOWHULRUL�RS]LRQL��DOOD� ILQH�GL�RJQL�VRWWRPHQX�� WURYDWH�OD�YRFH�$OWUH�RS]LRQL�FKH�YL�SHUPHWWH�GL�DFFHGHUH� DG� XQD� ILQHVWUD� FRQ� XOWHULRUL� FRQWUROOL� SHU� OD� SHUVRQDOL]]D]LRQH�GHOOHOHPHQWR�VFHOWR��$�GHVWUD�GHO�JUXSSR�(WLFKHWWH��WURYDWH�L�JUXSSL�$VVL�H�6IRQGR�FKH�SHUPHWWRQR�GL�PRGLILFDUH�JOL�DVVL�H�OR�VIRQGR�GHO�JUDILFR�

Page 54: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� � �

)�)R�RU�UP�PD�DW�WW�WD�DU�UH�H�L�LO�O�J�JU�UD�DI�IL�LF�FR�R�

)RUPDWWDUH�LO�JUDILFR�

*Lj�QHOOD�VFRUVD�OH]LRQH�DEELDPR�LPSDUDWR�D�PRGLILFDUH�O¶DVSHWWR�GL�XQ�JUDILFR��2JJL�YROJLDPR�ULWRUQDUH�VXOO¶DUJRPHQWR��&UHDWH�XQ�LVWRJUDPPD�EDVH�FRL�GDWL��GHO�ILOH�OH]LRQH����3RL�FRPLQFLDPR�FRQ�OH�PRGLILFKH��&RPLQFLDPR�FRQ�GHOOH�PRGLILFKH��SHU�FRVu�GLUH��HVWHWLFKH��([FHO� JHQHUD� XQ� JUDILFR� FRQ� OH� YRFL� VXOO¶DVVH� GHOOH� ;� REOLTXH� �)LJXUD� ����3URYLDPR�D�UDGGUL]]DUOH��

)LJXUD���±�, O�JUDILFR�GL�SDUWHQ]D�

3HU� SRWHU� PRGLILFDUH� O¶DVSHWWR� GL� XQ� DVVH� H� GL� WXWWL� JOL� HOHPHQWL� FKH� OR�ULJXDUGDQR��RFFRUUH�VHOH]LRQDUOR�IDFHQGR�FOLF�VXOO¶DVVH�VWHVVR�R�VX�XQD�GHOOH�YRFL�FKH�VL�WURYDQR�VRWWR�GL�HVVR��4XHVWD�VROX]LRQH�q�SL��UDSLGD��9L�DFFRUJHWH�FKH�XQ�DVVH�q�VWDWR�VHOH]LRQDWR��OH�VXH�HWLFKHWWH�VRQR�VHOH]LRQDWH��)LJXUD����

Page 55: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�8Q�DVVH�VHOH]LRQDWR�

6HQ]D� GHVHOH]LRQDUH� O¶DVVH� �FLRq� VHQ]D�PXRYHUH� LO�PRXVH� H� IDUH� FOLF� DOWURYH��IDWH�FOLF�FRO�WDVWR�GHVWUR�GHO�PRXVH�H��GDO�UHODWLYR�PHQX�FRQWHVWXDOH��VFHJOLHWH�OD�YRFH�)RUPDWR�DVVH��([FHO�YL�PRVWUHUj�OD�ILQHVWUD�)RUPDWR�DVVH��)LJXUD����

Page 56: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�/D�ILQHVWUD�)RUPDWR�DVVH�

6L� WUDWWD� GL� XQD� ILQHVWUD� FRQ� PROWH� VFKHGH� FKH� YL� SHUPHWWRQR� GL� DSSRUWDUH�GLYHUVH�PRGLILFKH�DOO¶DVVH��$G�HVHPSLR��OD�VFKHGD�2S]LRQL�DVVL��PRVWUDWD�QHOOD�)LJXUD� ��� YL� SHUPHWWH� GL� GHILQLUH� O¶DVSHWWR� GHOOH� HWLFKHWWH�� OD� ORUR� GLVWDQ]D�GDOO¶DVVH�� OD� JUDGD]LRQH�� «�� 6SRVWLDPRFL� SLXWWRVWR� QHOOD� VFKHGD�$OOLQHDPHQWR�)LJXUD����

Page 57: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�5XRWDUH�OH�YRFL�GL�XQ�DVVH�

'DOO¶HOHQFR�D�GLVFHVD�2ULHQWDPHQWR�WHVWR��VFHJOLHWH�5XRWD�WXWWR� LO�WHVWR�GL������&KLXGHWH�OD�ILQHVWUD�H��VHPSUH�WHQHQGR�VHOH]LRQDWR�O¶DVVH��SRUWDWHYL�QHOOD�VFKHGD�+RPH�GHOOD�EDUUD�PXOWLIXQ]LRQH��&RQ�L�FRPDQGL�GHO�JUXSSR�&DUDWWHUH��PRGLILFKLDPR�O¶DVSHWWR�GHO�IRQW��1RL� DEELDPR� FDPELDWR� LO� WLSR� GL� IRQW� H� OD� VXD� GLPHQVLRQH�� DEELDPR� VFHOWR� LO�FDUDWWHUH�$YDQW�JDUGH�D����SW��)LJXUD����

Page 58: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�0RGLILFDUH�LO�FDUDWWHUH�

/H�PRGLILFKH�FKH�DEELDPR�DSSRUWDWR�DOO¶DVVH�;��SRVVRQR�HVVHUH�DSSOLFDWH�FRQ�OR�VWHVVR�VLVWHPD�DOO¶DVVH�<��

3HU�HVSORUDUH�QXRYH�SRVVLELOLWj��SURYLDPR�D�PRGLILFDUH� O¶DVSHWWR�GHOOH� FRORQQH�GHO� JUDILFR�� DYHWH� GXH� SRVVLELOLWj� R� PRGLILFDUOH� WXWWH� LQVLHPH� LQ� PRGR� FKH�DEELDPR�WXWWH�OR�VWHVVR�DVSHWWR�R�XQD�DOOD�YROWD��/D�ILQHVWUD�SHU� OD�PRGLILFD�q�LGHQWLFD�LQ�HQWUDPEL�L�FDVL��/D�GLIIHUHQ]D�q�GDWD�VROR�GD�FRPH�VL�VHOH]LRQDQR�OH�FRORQQH� �SDUOLDPR�GL� FRORQQH� SHUFKp� DEELDPR�XQ� LVWRJUDPPD��PD�SRWUHPPR�ODYRUDUH�LQ�PRGR�DVVROXWDPHQWH�DQDORJR�FRQ�OH�IHWWH�GL�XQD�WRUWD���9HGLDPR� FRPH� IDUH�� 3HU� VHOH]LRQDUH� 7XWWH� OH� FRORQQH� IDWH� XQ� VLQJROR� FOLF� VX�XQD� TXDOVLDVL� GHOOH� FRORQQH�� 7XWWH� OH� FRORQQH� VHOH]LRQDWH� VL� SUHVHQWDQR� FRPH�QHOOD�)LJXUD���

Page 59: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�7XWWH�OH�FRORQQH�VHOH]LRQDWH�

1RWDWH�L�SDOOLQL�GL�VHOH]LRQH�DJOL�DQJROL�GL�RJQL�FRORQQD��

3HU� VHOH]LRQDUH� XQD� VLQJROD� FRORQQD�� LQYHFH�� GRSR� FKH� OH� DYHWH� VHOH]LRQDWH�WXWWH�� IDWH� DQFRUD� FOLF� VX� GL� HVVD�� /D� �PRVWUD� FRPH� VL� SUHVHQWD� XQD� FRORQQD�VHOH]LRQDWD��)LJXUD�����

)LJXUD���±�8QD�VLQJROD�FRORQQD�VHOH]LRQDWD

Page 60: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� ��

6LD� FKH� GHVLGHULDWH� PRGLILFDUH� XQD� VROD� FRORQQD� R� WXWWH�� GRSR� DYHU� IDWWR� OD�VHOH]LRQH�RSSRUWXQD��IDWH�FOLF�FRO� WDVWR�GHVWUR�GHO�PRXVH�H��GDO� UHODWLYR�PHQX�FRQWHVWXDOH�� VFHJOLHWH� QHO� SULPR� FDVR� )RUPDWR� FRRUGLQDWD�� QHO� VHFRQGR�)RUPDWR� VHULH� GDWL�� ([FHO� YL� PRVWUD� OD� ILQHVWUD� )RUPDWR� GDWR�� )RUPDWR�VHULH�GDWL��)LJXUD�����

)LJXUD���±�/D�ILQHVWUD�)RUPDWR�FRRUGLQDWD�

/D� ILQHVWUD�D�PROWH�VFKHGH�FKH�SRWHWH�HVSORUDUH�GD�VROL��1RL�YL�SURSRQLDPR�GL�PRGLILFDUH� LO� FRORUH� GHOOH� FRORQQH� VFHJOLHQGROR� IDFHQGR� XQ� FOLF� VXOO¶RSSRUWXQR�FDPSLRQH��

/R� VWHVVR� WLSR� GL� PRGLILFKH� SXz� DQFKH� HVVHUH� DSSOLFDWR� DOO¶DUHD� LQ� FXL� VL�LQVHULVFH� LO� JUDILFR�� FKH� SULPD� YD� RSSRUWXQDPHQWH� VHOH]LRQDWD� FRQ� XQ� FOLF� GHO�PRXVH��)LJXUD����

Page 61: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�/¶DUHD�GHO�WUDFFLDWR�VHOH]LRQDWD�

'RSR� OD� VHOH]LRQH� VFHJOLHWH� OD� YRFH� )RUPDWR� DUHD� GHO� WUDFFLDWR�� ([FHO� YL�DSULUj�OD�ILQHVWUD�)RUPDWR�DUHD�GHO�WUDFFLDWR� SHU�SHUPHWWHUYL�OH�PRGLILFKH��

$OOR�VWHVVR�PRGR�SRWHWH�PRGLILFDUH�O¶DUHD�ELDQFD�LQ�FXL�VL�WURYD�LO�JUDILFR��)DWH�FOLF� VX� GL� HVVD� FRO� WDVWR� GHVWUR� GHO� PRXVH� H�� GDO� UHODWLYR�PHQX� FRQWHVWXDOH��VFHJOLHWH�OD�YRFH�)RUPDWR�DUHD�GHO�JUDILFR��

3HU� OH� PRGLILFKH� DO� JUDILFR�� SRWHWH� DQFKH� VHUYLUYL� GHL� FRPDQGL� GHOOD� VFKHGD�)RUPDWR�GHJOL�VWUXPHQWL�*UDILFR�GHOOD�EDUUD�PXOWLIXQ]LRQH��)LJXUD������

)LJXUD����±�/D�VFKHGD�)RUPDWR�GHOOD�EDUUD�PXOWLIXQ]LRQH

Page 62: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� � �

$�$Q�QF�FR�RU�UD�D�V�VX�XL�L�J�JU�UD�DI�IL�LF�FL�L�

$JJLXQJHUH�GDWL�DG�XQ�JUDILFR�

$QFKH�LQ�TXHVWD�OH]LRQH�FL�RFFXSHUHPR�GL�JUDILFL��&RPLQFLDPR� D� FUHDUH� XQ� VHPSOLFH� LVWRJUDPPD� D� SDUWLUH� GDO� SURVSHWWR� GHOOD�)LJXUD���FKH�UDSSUHVHQWD�O¶DQGDPHQWR�GHOOH�VSHVH�SHU�JOL�DOLPHQWDUL�QHO�FRUVR�GL�XQ�DQQR��

)LJXUD���±�, O�JUDILFR�GL�SDUWHQ]D�

'RYUHVWH�RWWHQHUH�XQ�JUDILFR�FRPH�TXHOOR�GHOOD�)LJXUD���

Page 63: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�, O�JUDILFR�

3URYLDPR� DG� DJJLXQJHUH� DO� SURVSHWWR� GL� SDUWHQ]D� XQD� FRORQQD�� FRPH� QHOOD�)LJXUD����

)LJXUD���±�, �QXRYL�GDWL�

$EELDPR�DJJLXQWR�FLRq�OH�VSHVH�SHU�O¶DEELJOLDPHQWR��9RJOLDPR�IDUH�VL�FKH�DQFKH�TXHVWH�VLDQR�SUHVHQWDWH�QHO�JUDILFR��3RWHWH�IDUH�FOLF�VXO�JUDILFR�SHU�VHOH]LRQDUOR��SRUWDUYL�DOOD�VFKHGD�3URJHWWD]LRQH�GHJOL� VWUXPHQWL� JUDILFR� H�� QHO� JUXSSR� 'DWL�� SUHPHUH� LO� SXOVDQWH� 6HOH]LRQD�GDWL��([FHO�PRVWUHUj�OD�ILQHVWUD�6HOH]LRQD�RULJLQH�GDWL��)LJXUD����

Page 64: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD�����/D�ILQHVWUD�6HOH]LRQD�RULJLQH�GDWL�

8WLOL]]DQGR� OD� FDVHOOD� ,QWHUYDOOR� GDWL� JUDILFR�� SRWHWH� VSHFLILFDUH� LO� QXRYR�LQWHUYDOOR�RULJLQH�GHL�GDWL��$EELDPR��SHUz��D�GLVSRVL]LRQH�XQD�VROX]LRQH�SL��UDSLGD�HG�q�TXHOOD�FKH�RUD�YL�SUHVHQWHUHPR��6HOH]LRQDWH� LO� JUDILFR�� L� GDWL� RULJLQH� DSSDULUDQQR� FLUFRQGDWL� GD� XQ� ERUGR� EOX��)LJXUD�����

)LJXUD���±�$JJLXQJHUH�QXRYL�GDWL�DO�JUDILFR�

6HQ]D� GHVHOH]LRQDUH� LO� JUDILFR�� DYYLFLQDWH� LO� SXQWDWRUH� GHO� PRXVH� D� XQR� GHL�TXDGUDWLQL� GL� VHOH]LRQH� DJOL� DQJROL� GHL� GDWL� H�� TXDQGR� LO� FXUVRUH� GLYHQWD� XQD�IUHFFLD� D� GXH� SXQWH� �)LJXUD� ���� WUDVFLQDWH� ILQR� D� FRPSUHQGHUH� L� GDWL� GD�DJJLXQJHUH��,O�JUDILFR�ULVXOWHUj�DJJLRUQDWR��)LJXUD����

Page 65: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�$JJLXQJHUH�QXRYL�GDWL�DO�JUDILFR�

)LJXUD���±�, O�JUDILFR�DJJLRUQDWR�

/H�WRUWH�3HU�FRQFOXGHUH�LO�QRVWUR�GLVFRUVR�VXL�JUDILFL��YL�SURSRQLDPR�GHJOL�HVHPSL�FRQ�OH�WRUWH� FKH��DEELDPR�GHWWR� LQ�XQD�VFRUVD� OH]LRQH�� VHUYRQR�SHU� UDSSUHVHQWDUH� OH�SDUWL�GL�XQ�WXWWR��3DUWLDPR� FRQ� XQ� HVHPSLR� VHPSOLFH�� 5DSSUHVHQWHUHPR� FRQ� XQD� WRUWD� OD�VLWXD]LRQH� � FKH� YHGHWH� QHOOD� WDEHOOD� H� FKH� UDSSUHVHQWD� OD� ULSDUWL]LRQH� GHO�IDWWXUDWR�DQQXR�GL�XQD�GLWWD��

)LJXUD���±�, �GDWL

Page 66: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

3HU� UHDOL]]DUH� OD� WRUWD��SURFHGHWH�FRPH�DYHWH� IDWWR�SHU�JOL�DOWUL� WLSL�GL�JUDILFR��VHPSOLFHPHQWH�VFHJOLHQGR�OD�WRUWD�DOO¶LQL]LR�GHOOD�SURFHGXUD��'RYUHVWH� RWWHQHUH� XQ� ULVXOWDWR� FRPH� TXHOOR� GHOOD�

)LJXUD����

)LJXUD���±�8Q�JUDILFR�D�WRUWD�

3Xz�HVVHUH�DQFKH�XWLOH�PRVWUDUH��DFFDQWR�D�FLDVFXQD�IHWWD�GHOOD�WRUWD�LO�YDORUH�SHUFHQWXDOH� FKH� UDSSUHVHQWD�H� LO�QRPH�GHOOD� UHJLRQH�D� FXL� VL� ULIHULVFH��$�TXHO�SXQWR�SRWUHPR�DQFKH�HOLPLQDUH�OD�OHJHQGD��3RWUHVWH�VHPSOLFHPHQWH�LQVHULUH�OH�HWLFKHWWH��VFHJOLHQGR�OD�SRVL]LRQH�LQ�FXL�OH�YROWH�GDO�PHQX�GHO�SXOVDQWH�(WLFKHWWH�GDWL�GHO�JUXSSR�(WLFKHWWH�GHOOD�VFKHGD�/D\RXW� GHJOL�VWUXPHQWL�JUDILFR��,Q�TXHVWR�FDVR��SHUz�YLVXDOL]]HUHPPR�VROR�OH�SHUFHQWXDOL��PHQWUH�QRL�YRJOLDPR�DQFKH�L�QRPL�GHOOH�UHJLRQL��,Q�TXHVWR�FDVR��VHPSUH�GDO�PHQX�GHO�SXOVDQWH�PHQX�GHO�SXOVDQWH�(WLFKHWWH�GDWL�GREELDPR

Page 67: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

VFHJOLHUH�OD�YRFH�$OWUH�RS]LRQL�HWLFKHWWH�GDWL��([FHO�YL�PRVWUHUj�OD�ILQHVWUD�)RUPDWR�HWLFKHWWH�GDWL��)LJXUD������4XL��QHOOD�VFKHGD�2S]LRQL�HWLFKHWWD��ROWUH�DOOD�YRFH�9DORUH�FKH�GRYUHEEH�HVVHUH�JLj�VHOH]LRQDWD��VHOH]LRQDWH�OD�YRFH�1RPH�FDWHJRULD��

)LJXUD������/D�ILQHVWUD�)RUPDWR�HWLFKHWWH�GDWL�

$�TXHVWR�SXQWR�DQFKH�LO�QRPH�GHOOH�UHJLRQL�FRPSDULUj�QHO�YRVWUR�JUDILFR��3HU�HOLPLQDUH� OD� OHJHQGD��VFHJOLHWH�1HVVXQD�GDO�PHQX�GHO�SXOVDQWH�/HJHQGD�GHO�JUXSSR�(WLFKHWWH�GHOOD�VFKHGD�/D\RXW� GHJOL�VWUXPHQWL�JUDILFR��/D�)LJXUD����PRVWUD�LO�JUDILFR�ILQLWR�

Page 68: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD����±�0RVWUDUH�OD�SHUFHQWXDOH�H�OD�UHJLRQH�

,Q�TXHVWR�FDVR�([FHO�JLj�GLVSRQHYD�GHL�YDORUL�SHUFHQWXDOL��PD�TXDQGR�FUHD�XQ�JUDILFR�D�WRUWD�q�LQ�JUDGR�GL�FDOFRODUH�OH�SHUFHQWXDOL�GD�VROR��3HU�FKLDULUH�PHJOLR�LO�FRQFHWWR�IDUHPR�XQ�HVHPSLR��

7RUQLDPR� D� ODYRUDUH� FRL� GDWL� GHOOD� )LJXUD� ��� YRJOLDPR� UDSSUHVHQWDUH� FRQ�XQD�WRUWD�TXDQWR� LQFLGRQR� OH� VSHVH�DOLPHQWDUL�GL� RJQL�PHVH�VXOOH� VSHVH�DOLPHQWDUL�WRWDOL�GL�WXWWR�O¶DQQR��

6HOH]LRQDWH� OH� FHOOH� $��%��� H� FUHDWH� XQ� JUDILFR� D� WRUWD�� $SULWH� GL� QXRYR� OD�ILQHVWUD�)RUPDWR�HWLFKHWWH�GDWL��4XHVWD�YROWD�GRYHWH�GHVHOH]LRQDUH�O¶RS]LRQH�9DORUL� H�VHOH]LRQDUH�3HUFHQWXDOL��)LJXUD�����

Page 69: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD����±�&DOFRODUH�OD�SHUFHQWXDOH�

1HOOD� VH]LRQH� 3RVL]LRQH� HWLFKHWWD� VFHJOLHWH� OD� SRVL]LRQH� GHOO¶HWLFKHWWD� SL��DGDWWD�D�IDFLOLWDUH�OD�OHWWXUD�GHOOH�SHUFHQWXDOL�LQVHULWH��/D�)LJXUD����PRVWUD�LO�JUDILFR�ILQLWR

Page 70: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD����±�/H�SHUFHQWXDOL�DFFDQWR�DOOH�IHWWH�

3RWHWH�PRVWUDUH�OH�SHUFHQWXDOL�DQFKH�YLVXDOL]]DQGR�HYHQWXDOL�GHFLPDOL��5LDSULWH�OD�ILQHVWUD�)RUPDWR�HWLFKHWWH�GDWL�H�SRUWDWHYL�DOOD�VFKHGD�1XPHUR��1HOOD� FDVHOOD� &DWHJRULH� VHOH]LRQDWH� SHUFHQWXDOH�� TXLQGL�� QHOOD� FDVHOOD�SRVL]LRQL�GHFLPDOL�VSHFLILFDWH�TXDQWL�GHFLPDOL�YROHWH�XWLOL]]DUH��)LJXUD�����

Page 71: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ���

)LJXUD����±�6SHFLILFDUH�LO�QXPHUR�GHL�GHFLPDOL

Page 72: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� � �

*�*O�OL�L�V�VP�PD�DU�UW�W�D�DU�UW�W�

*OL�VPDUW�DUW�

*OL�6PDUW$UW�VRQR�QXRYR�VWUXPHQWR�LQWURGRWWR�FRQ�2IILFH������FKH�SRWHWH�XVDUH�SHU�LQVHULUH�JUDILFD�GDOODVSHWWR�SURIHVVLRQDOH��3HU� LQVHULUH�XQR�6PDUW$UW��GRYHWH�SRUWDUYL�QHOOD�VFKHGD�,QVHULVFL��QHO�JUXSSR�,OOXVWUD]LRQL�H�SUHPHUH�LO�SXOVDQWH�6PDUW$UW��2IILFH�YL�PRVWUHUj�OD�ILQHVWUD��6FHJOL�HOHPHQWR�JUDILFR�6PDUW$UW��)LJXUD�����

)LJXUD����/D�ILQHVWUD��6FHJOL�HOHPHQWR�JUDILFR�6PDUW$UW�

&RPH�SRWHWH�YHGHUH�GDOOD�)LJXUD����DYHWH�OD�SRVVLELOLWj�GL�VFHJOLHUH�IUD�GLYHUVH�FDWHJRULH�GL�6PDUW$UW�

• (OHQFKL�3UHVHQWDQR� JUXSSL� GL� LQIRUPD]LRQL� FKH� SRVVRQR� HVVHUH� SRVWH� LQ�VHTXHQ]D�R�PHQR

Page 73: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� �

• 3URFHVVL� 3HUPHWWRQR� GL� PRVWUDUH� LQIRUPD]LRQL� FKH� VL� VXVVHJXRQR� LQ�VHTXHQ]D��FRPH�L�GLYHUVL�PRPHQWL�GL�XQ�SURFHVVR�SURGXWWLYR�

• &LFOL�0RVWUDQR�XQ�SURFHVVR�FRQWLQXR��FLFOLFR • *HUDUFKLH�3HUPHWWRQR�GL�SUHVHQWDUH� LQIRUPD]LRQL�JHUDUFKLFKH��FRPH�XQ�RUJDQLJUDPPD�D]LHQGDOH

• 5HOD]LRQL�(YLGHQ]D�OH�UHOD]LRQL�IUD�OH�LQIRUPD]LRQL�SUHVHQWDWH • 0DWULFL�7DEHOOH�GL�GDWL�LQ�UHOD]LRQH�ULJD�SHU�ULJD • 3 LUDPLGL� 0RVWUD� OH� SURSRU]LRQL� FKH� LQWHUFRUURQR� IUD� OH� LQIRUPD]LRQL�SURSRVWH�

8QD�YROWD�VFHOWD� OD�FDWHJRULD��QHO� ULTXDGUR�FHQWUDOH��GRYHWH�VFHJOLHUH� LO� WLSR�GL�6PDUW$UW� FKH�GHVLGHUDWH��4XDQGR�VHOH]LRQDWH�XQ� WLSR��QHO� ULTXDGUR�GL� VLQLVWUD�QH�YHGHWH�XQD�DQWHSULPD�H�XQD�GHVFUL]LRQH��$SSHQD� DYHWH� VFHOWR� LO� WLSR� GL� 6PDUW$UW� FKH� YROHWH� LQVHULUH�� VHOH]LRQDWHOR� H�SUHPHWH� LO� SXOVDQWH� 2.�� 2IILFH� YL� LQVHULUj� QHO� ILOH� � ORJJHWWR� FKH� DYHWH� VFHOWR�YXRWR��)LJXUD�����

)LJXUD���±�/¶RJJHWWR�YXRWR�QHO�ILOH�

1RWDWH� FKH� XQR� 6PDUW$UW� q� FRPSRVWR� GD� GLYHUVH� IRUPH�� SRVWH� OXQD� DFFDQWR�DOODOWUD��DOOLQWHUQR�GHOOH�TXDOL�FL�VRQR�GHL�VHJQDSRVWR�SHU�LO�WHVWR��3RWHWH� GLJLWDUH� LO� WHVWR� GLUHWWDPHQWH� QHO� VHJQDSRVWR�� RSSXUH� ULFRUUHUH� DO�SDQQHOOR� FROORFDWR� DOOD� VLQLVWUD� GHOOR� 6PDUW$UW�� 4XHVWR� SDQQHOOR� q� VROR� �GL�VHUYL]LR�� H� YLHQH� QDVFRVWR� TXDQGR� GHVHOH]LRQDWH� OR� 6PDUW$UW�� 1RQ� VDUj��GXQTXH��Qp�VWDPSDWR��Qp�SURLHWWDWR��3URYLDPR� D� VFULYHUH� QHOOR� 6PDUW$UW� OH� FDWHJRULH� GL� HVHUFL]L� FKH� DEELDPR�XWLOL]]DWR�QHOOH�OH]LRQL�VXL�ILOWUL�

• $OLPHQWDUL • %DU • )DUPDFLD • )UXWWD�H�9HUGXUD • 0DFHOOHULD

Page 74: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� �

• 2UHILFHULD • 3DQHWWHULD • 7HVVXWL�

1HOO¶HVHPSLR� GHOOD� )LJXUD� �� FL� VRQR� VROR� �� ULTXDGUL�� $� QRL� QH� VHUYRQR� ���9HGUHPR�DQFKH�FRPH�LQVHULUH�OH�SDUWL�PDQFDQWL��&RPLQFLDPR�D�VFULYHUH�QHL�VHJQDSRVWR�GLVSRQLELOL� OH�SULPH���FDWHJRULH��)LJXUD�����3HU�SDVVDUH�GD�XQ�VHJQDSRVWR�DOO¶DOWUR�QRQ�SUHPHWH�LO�WDVWR�,QYLR��IDWH�FOLF�VXO�VHJQDSRVWR�LQ�FXL�YROHWH�VFULYHUH��

)LJXUD���±�/H�SULPH�FDWJRULH�

$YUHWH� QRWDWR� FKH�PDQ�PDQR� FKH� GLJLWDWH� OH� OHWWHUH�� LO� WHVWR� VL� ULGLPHQVLRQD�RSSRUWXQDPHQWH�LQ�PRGR�GD�DGHJXDUVL�DOOR�VSD]LR�FKH�KD�D�GLVSRVL]LRQH��

3HU� DJJLXQJHUH� OH� QXRYH� VH]LRQL� WHQHQGR� LO� FXUVRUH� QHOOXOWLPR� WHVWR� GHO�SDQQHOOR�GL� VLQLVWUD�SUHPHWH� LO� WDVWR� ,QYLR�� FRPSDULUj�XQD�QXRYD� IRUPD�FRQ� LO�UHODWLYR�VHJQDSRVWR�SHU�LO�WHVWR��)LJXUD�����

)LJXUD����8Q�QXRYR�VHJQDSRVWR�

3HU�DJJLXQJHUH�XQD�IRUPD�DG�XQR�6PDUW$UW�SRWHWH�DQFKH�SURFHGHUH�FRVu�����9LVXDOL]]DWH� OD� VFKHGD� 3URJHWWD]LRQH� GHJOL� 6WUXPHQWL� 6PDUW$UW��3RUWDWHYL�QHO�JUXSSR�&UHD�HOHPHQWR�JUDILFR��

���)DWH� FOLF� VXO�SXOVDQWH�$JJLXQJL� IRUPD��/D�QXRYD� IRUPD�YHUUj�DJJLXQWD�GRSR�TXHOOD�VHOH]LRQDWD�DO�PRPHQWR�GHOOD�DJJLXQWD��6H��LQYHFH��SUHIHULWH�GHFLGHUH� GRYH� SRVL]LRQDUH� OD� QXRYD� IRUPD�� SUHPHWH� OD� SLFFROD� IUHFFLQD�SRVWD� LQ�EDVVR�DO�SXOVDQWH�$JJLXQJL� IRUPD��2IILFH�YL�PRVWUHUj�XQ�QXRYR�PHQX�LQ�FXL�VFHJOLHUH�GRYH�FROORFDUH�OD�QXRYD�IRUPD�����

$OFXQL� WLSL� GL� 6PDUW$UW�� QRQ� SHUPHWWRQR� GL� DJJLXQJHUH� QXRYH� IRUPH�� $G�HVHPSLR�� LO� WLSR� )UHFFH� RSSRVWH� GHOOD� FDWHJRULD� 5HOD]LRQL� SXz� DYHUH� VROR� ��IRUPH��,O�SXOVDQWH�$JJLXQJL�IRUPD��VH�XVDWH�TXHVWR�6PDUW$UW��q�GLVDELOLWDWR�

Page 75: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� ��

)RUPDWWDUH�XQR�6PDUW$UW�*OL�6PDUW$UW�KDQQR�LO�YDQWDJJLR�GL�HVVHUH�IDFLOPHQWH�IRUPDWWDELOL�LQ�WXWWL�L�ORUR�DVSHWWL��4XDQGR� LQVHULWH� XQR�6PDUW$UW�� SHU� LPSRVWD]LRQH� SUHGHILQLWD�� TXHVWR� q� SLDWWR��VHQ]D� HIIHWWL� GL� WULGLPHQVLRQDOLWj� RG� RPEUH�� PD� q� PROWR� IDFLOH� PRGLILFDUOR�DSSOLFDQGR�XQR�GHJOL�VWLOL�SUHLPSRVWDWL�SHU�TXHO�WLSR�GL�6PDUW$UW�8QD� YROWD� VHOH]LRQDWR� OR� 6PDUW$UW�� WURYDWH� JOL� VWLOL� D� GLVSRVL]LRQH� QHO� JUXSSR�6WLOL� 6PDUW$UW� GHOOD� VFKHGD� 3URJHWWD]LRQH� GHJOL� 6WUXPHQWL� 6PDUW$UW��)LJXUD�����

)LJXUD���±�*OL�VWLOL�SUHLPSRVWDWL�

3RWHWH� YLVXDOL]]DUH� WXWWL� JOL� VWLOL� FKH� DYHWH� D� GLVSRVL]LRQH� XVDQGR� OD� EDUUD� GL�VFRUULPHQWR� SRVWD� D� VXD� GHVWUD� R� OD� IUHFFLQD� FRQ� OD� TXDOH� SRWHWH� YLVXDOL]]DUH�WXWWL�JOL�VWLOL�FRQWHPSRUDQHDPHQWH��

6H� IDWH� SDVVDUH� LO� PRXVH� VXL� YDUL� VWLOL� GLVSRQLELOL�� 2IILFH� YH� QH� PRVWUHUj�ODQWHSULPD�GLUHWWDPHQWH�QHO�GRFXPHQWR��PD�SHU�DSSOLFDUH�UHDOPHQWH�XQR�VWLOH�RFFRUUH�IDUH�FOLF�VX�GL�HVVR��

2OWUH�DOOR�VWLOH��q�SRVVLELOH�PRGLILFDUH�L�FRORUL�GHL�YDUL�HOHPHQWL�GL�XQR�6PDUW$UW��XWLOL]]DQGR�GHOOH�FRPELQD]LRQL�GL�FRORUL�SUHGHILQLWH��3HU�YLVXDOL]]DUOH��GRSR�DYHU�VHOH]LRQDWR�OR�6PDUW$UW��XVDWH�LO�SXOVDQWH�&DPELD�FRORUL�FKH�WURYDWH�DSSHQD�DOOD�VLQLVWUD�GHO�JUXSSR�6WLOL�6PDUW$UW��,Q�TXHVWR�PRGR�YLVXDOL]]HUHWH�XQ�PHQX�FRQ�OH�FRPELQD]LRQL�GL�FRORUL�GLVSRQLELOL��)LJXUD����

Page 76: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�/H�FRPELQD]LRQL�GL�FRORUH�GLVSRQLELOL�

$QFKH�FRQ�OH�FRPELQD]LRQL�GL�FRORUL��2IILFH��DO�SDVVDJJLR�GHO�PRXVH��YL�PRVWUD�ODQWHSULPD� QHO� GRFXPHQWR� VWHVVR�� 3HU� VHOH]LRQDUH� HIIHWWLYDPHQWH� OD�FRPELQD]LRQH�GL�FRORUL�FKH�YL�LQWHUHVVD��IDWH�FOLF�VX�GL�HVVD�

Page 77: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� � �

,�,�V�VX�XE�EW�WR�RW�WD�DO�OL�L�

,�VXEWRWDOL�

2OWUH�DOOH�IXQ]LRQL�GL�RUGLQDPHQWR�H�GL�ILOWUR��([FHO�GLVSRQH�GL�XOWHULRUL�FRPDQGL�SHU�OD�JHVWLRQH�GHL�GDWL��,Q�TXHVWD� OH]LRQH�SDUOHUHPR�GL�6XEWRWDOL�FKH�FL�SHUPHWWRQR�GL�HIIHWWXDUH�GHOOH�RSHUD]LRQL�VXL�GDWL�DSSOLFDQGR�FRQWHPSRUDQHDPHQWH�XQ�ILOWUR��/DYRUHUHPR�FRQ�GHL�GDWL�FKH�JLj�FRQRVFHWH��)LJXUD�����

)LJXUD���±�, �GDWL�

9RJOLDPR� FDOFRODUH� OD� PHGLD� GHO� IDWWXUDWR� GHOOH� YDULH� WLSRORJLH� GL� HVHUFL]LR�FRPPHUFLDOH�

Page 78: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� ��

3HU� SULPD� FRVD� GREELDPR� SUHGLVSRUUH� O¶HOHQFR� RSSRUWXQDPHQWH� RULQDQGROR�SURSULR�SHU�WLSR�GL�DWWLYLWj��FLRq�DSSOLFDUH�XQ�RUGLQDPHQWR�DOIDEHWLFR�FUHVFHQWH�DOOD�FRORQQD�&��8QD�YROWD�RUGLQDWR�O¶HOHQFR��QHO�JUXSSR�6WUXWWXUD�GHOOD�VFKHGD�'DWL�SUHPHWH�LO�SXOVDQWH�6XEWRWDOL��([FHO�DSULUj�OD�ILQHVWUD�6XEWRWDOL��)LJXUD�����

)LJXUD���±�/D�ILQHVWUD�6XEWRWDOL�

$QDOL]]LDPR�TXHVWD�ILQHVWUD�SHU�FDSLUH�FRPH�IXQ]LRQD��1HOO¶HOHQFR�D�GLVFHVD�$G�RJQL� FDPELDPHQWR� LQ� ELVRJQD� VSHFLILFDUH� OD� FRORQQD� LQ� FXL� VL� YHULILFD� LO�FDPELDPHQWR� LQ� IXQ]LRQH� GHO� TXDOH� UDJJUXSSDUH� L� GDWL� SHU� SRL� HVHJXLUH� LO�FDOFROR�� 1HO� QRVWUR� FDVR� VL� WUDWWD� GHOOD� FRORQQD� $WWLYLWj�� GREELDPR�� LQIDWWL��FDOFRODUH�OD�PHGLD�GHO�IDWWXUDWR�GHL�YDUL�HVHUFL]L�FRPPHUFLDOL��'DOO¶HOHQFR�D�GLVFHVD�8VD�OD�IXQ]LRQH��VFHJOLHWH�OD�IXQ]LRQH�LQ�EDVH�DOOD�TXDOH�YROHWH�ODYRUDUH�VXL�GDWL��1HO�QRVWUR�FDVR�VL�WUDWWD�GHOOD�PHGLD��&L� UHVWD�VROR�GD�GLUH�DG�([FHO�D�TXDOL�GDWL�DSSOLFDUH� OD�PHGLD��4XHVWR�GDWR�YD�VSHFLILFDWR� QHO� ULTXDGUR� $JJLXQJL� VXEWRWDOL� $�� QHO� QRVWUR� FDVR� GREELDPR�DSSOLFDUH�XQ�VHJQR�GL�VSXQWD�DOOD�YRFH�IDWWXUDWR��6H�QHOO¶HOHQFR�FL�IRVVHUR�SL��FRORQQH�FRQ�GDWL�QXPHULFL��SRWHWH�VHOH]LRQDUH�LO�FDOFROR�VX�WXWWH�OH�FRORQQH�FKH�GHVLGHUDWH��VHPSOLFHPHQWH�VHOH]LRQDQGROH�QHO�ULTXDGUR�$JJLXQJL�VXEWRWDOL�$��

,Q�RJQL�FDVR��TXDQGR��DYHWH�ILQLWR�GL�GHILQLUH�OH�YRVWUH�LPSRVWD]LRQL��SUHPHWH�LO�SXOVDQWH�2.�SHU�FDOFRODUH�L�VXEWRWDOL��/D�)LJXUD���PRVWUD�LO�ULVXOWDWR�

Page 79: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�, �VXEWRWDOL�

&L�VRQR�PROWH�FRVH�GD�GLUH�VX�TXHVWD�ILQHVWUD��DQGLDPR�FRQ�RUGLQH��

$OOD�ILQH�GL�RJQL�JUXSSR�GL�DWWLYLWj��([FHO�YL�PRVWUD�LO�ULVXOWDWR�FKH�KD�FDOFRODWR��$OOD�ILQH�GL�WXWWR�O¶HOHQFR�FL�PRVWUD�LO�ULVXOWDWR�GHOOD�IXQ]LRQH�VFHOWD�DSSOLFDWD�D�WXWWR�O¶HOHQFR��1HO�QRVWUR�FDVR�YHGLDPR�OD�PHGLD�GL�WXWWL�L�IDWWXUDWL�

Page 80: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� ��

�FRPSDUVD�XQD�EDQGD�ODWHUDOH�FKH�YL�SHUPHWWH�GL�QDVFRQGHUH�H�VFRSULUH�DOFXQL�GDWL�D�VHFRQGD�GHOOH�HVLJHQ]H��3URYDWH�D� IDUH�FOLF�VXL�SLFFROL�VLPEROL�PHQR�����QHOOD� FRORQQD� FHQWUDOH�� /D� VH]LRQH� FRUULVSRQGHQWH� DO� VHJQR� VX� FXL� DYHWH� IDWWR�FOLF� YLHQH� FRPSDWWDWD�� QRQ� VL� YHGRQR� SL�� L� GHWWDJOL�� PD� VROR� LO� VXEWRWDOH�FDOFRODWR��)LJXUD�����

)LJXUD���±�/D�VH]LRQH�DOLPHQWDUL�FRPSDWWDWD�

3HU�ULHVSDQGHUH�OD�VH]LRQH�EDVWD�IDUH�FOLF�VXO�SLFFROR�SL������FKH�KD�VRVWLWXLWR�LO�PHQR��6H�IDWH�FOLF�VXO�SLFFROR����� ��SRVWR�DFFDQWR�DOOH�LQWHVWD]LRQL�GL�FRORQQD��SRWHWH�FRPSDWWDUH�R�HVSDQGHUH�WXWWH�OH�VH]LRQL�LQ�XQD�YROWD�VROD��)LJXUD����

Page 81: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD���±�7XWWH�OH�VH]LRQL�FRPSDWWDWH�

3RWHWH�DQFKH�JHQHUDUH�XQ�JUDILFR� FKH�PRVWUD� VHPSUH� L� GDWL� YLVLELOL�QHO�YRVWUR�HOHQFR�� 4XDQGR� HVSDQGHWH� OH� VH]LRQL� VL� HVSDQGH� LO� JUDILFR�� DOWULPHQWL� GL�FRPSDWWD��6LFXUDPHQWH� VLHWH� FDSDFL� GL� FUHDUH� XQ� JUDILFR� �VH� QRQ� YH� OR� ULFRUGDWH� YL�ULPDQGLDPR� DOOH� OH]LRQL� �������� 2JJL�� SHUz�� YRJOLDPR� SUHVHQWDUYL� XQ� PRGR�DOWHUQDWLYR�H� UDSLGR�SHU�JHQHUDUH�XQ�LVWRJUDPPD�D�SDJLQD�LQWHUD�� ,O�JUDILFR�D�SDJLQD� LQWHUD� LQ� TXHVWR� FDVR� q� FRPRGR�� SHUFKp� TXDQGR� HVSDQGHWH� WXWWH� OH�VH]LRQL�RFFRUUH�YLVXDOL]]DUH�PROWH�YRFL��(FFR� FRPH� IDUH�� IDWH� FOLF� DOO¶LQWHUQR� GHOO¶HOHQFR�� SRL� SUHPHWH� )���� ([FHO�DJJLXQJHUj�XQ�IRJOLR�DOOD�YRVWUD�FDUWHOOD�GL�ODYRUR�FRQ�LO�JUDILFR��)LJXUD�����

)LJXUD���±�, O�JUDILFR�FRQ�OH�VH]LRQL�FRPSDWWDWH

Page 82: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� ��

3HU� FRQFOXGHUH� SURYLDPR�D�YHGHUH� FRPH� VL�PRGLILFD� LO� JUDILFR� VH� HVSDQGLDPR�XQD� VH]LRQH�� 7RUQDWH� VXO� IRJOLR� 1HJR]L� H� SUHPHWH� LO� SLFFROR� SL�� ���� LQ�FRUULVSRQGHQ]D�GHOOD�VH]LRQH�$OLPHQWDUL�SHU�HVSDQGHUOD��/DVFLDWH�OH�DOWUH�VH]LRQL�FRPSDWWDWH��)LJXUD�����

)LJXUD���±�/D�VH]LRQH�$OLPHQWDUL�HVSDQVD�

3RUWDWHYL� GL� QXRYR� QHO� IRJOLR� GHO� JUDILFR�� QRWHUHWH� FKH� VL� q� PRGLILFDWR�DXWRPDWLFDPHQWH�� 1RQ� YHGLDPR� SL�� VROR� OH�PHGLH��PD� DQFKH� LO� IDWWXUDWR� GHL�VLQJROL� QHJR]L� GL� DOLPHQWDUL� �)LJXUD� ���� /H� HWLFKHWWH� DQGUDQQR� VLVWHPDWH� SHU�PLJOLRUDUH�OD�OHJJLELOLWj�GHO�JUDILFR��8QD� SRVVLELOLWj� q� TXHOOD� GL� VHOH]LRQDUH� OH� HWLFKHWWH�� TXLQGL� IDUH� FOLF� FRO� WDVWR�GHVWUR�GHO�PRXVH�H�VFHJOLHUH�)RUPDWR�DVVH��&RPSDULUj�OD�ILQHVWUD�)RUPDWR�DVVH��1HOOD�VFKHGD�2S]LRQL�DVVL�GHVHOH]LRQDUH�OD�YRFH�(WLFKHWWH�FDWHJRULH�D�SL��OLYHOOL��)LJXUD����

Page 83: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� ��

/D�

)LJXUD����PRVWUD�LO�ULVXOWDWR��

)LJXUD���±�, O�JUDILFR�DJJLRUQDWR

Page 84: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD�����/DYRUDUH�VXJOL�DVVL

Page 85: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&���������7XWWL�L�GLULWWL�ULVHUYDWL� ��

)LJXUD����±�, O�JUDILFR�PRGLILFDWR

Page 86: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� � �

$�$Q�QF�FR�RU�UD�D�V�VX�XL�L�V�VX�XE�EW�WR�RW�WD�DO�OL�L�

$QFRUD�VXL�VXEWRWDOL�

&RQWLQXLDPR� D� SDUODUH� GL� VXEWRWDOL�� 3HU� QRQ� VFRPELQDUH� WURSSR� LO� JUDILFR� FKH�DEELDPR�IDWWR�DOOD�ILQH�GHOOD�VFRUVD�OH]LRQH�� ODYRULDPR�VX�XQ�QXRYR�ILOH�FRQ�OR�VWHVVR�WLSR�GL�GDWL�D�FXL�DEELDPR�JLj�DSSOLFDWR�LO�VXEWRWDOL�FKH�FDOFROD�OD�PHGLD��FRPH�TXHOOR�GHOOD�VFRUVD�OH]LRQH���9RJOLDPR�DJJLXQJHUH�D�TXHVWL�VXEWRWDOL��GHJOL�DOWUL�VXEWRWDOL�FKH�FRQWLQR�TXDQWR�HVHUFL]L� FL� VRQR� LQ� RJQL� FDWHJRULD�� FLRq� YRJOLDPR� VDSHUH� TXDQWL� VRQR� JOL�DOLPHQWDUL��TXDQWL�L�EDU«�

)DWH�FOLF�DOO¶LQWHUQR�GHOO¶HOHQFR�H�DSULWH�GL�QXRYR�OD�ILQHVWUD�VXEWRWDOL��)LJXUD�����

)LJXUD���±�&RQWDUH�JOL�HOHPHQWL�GL�RJQL�FDWHJRULD�

4XHVWD�YROWD�OD�IXQ]LRQH�GD�XVDUH�q�&RQWHJJLR��1RQ�LPSRUWD�D�TXDOH�FRORQQD�OD�VL�DSSOLFD��LQIDWWL�QRQ�HVHJXH�QHVVXQD�RSHUD]LRQH�VX�GDWL�QXPHULFL��VL�OLPLWD�D

Page 87: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

FRQWDUH� OH� YRFL�GL� RJQL� FDWHJRULD�H� OH� ULJKH�GD�FRQWDUH� VRQR� OH� VWHVVH� LQ�RJQL�FRORQQD��3UHPHWH�2N�SHU�FDOFRODUH�LO�VXEWRWDOH��([FHO�KD�VRVWLWXLWR�LO�FDOFROR�GHOOD�PHGLD�FRQ�LO�FRQWHJJLR�GHOOH�ULJKH��)LJXUD�����

)LJXUD���±�, O�FRQWHJJLR�GHOOH�ULJKH�

6H� YRJOLDPR� PDQWHQHUH� SL�� GL� XQ� VXEWRWDOH� RFFRUUH� GHVHOH]LRQDUH� O¶RS]LRQH�6RVWLWXLVFL� VXEWRWDOL� FRUUHQWL� QHOOD� ILQHVWUD� VXEWRWDOL�� 1HOOD� )LJXUD� �� YL�PRVWULDPR�XQ�HVHPSLR�FRO�TXDOH�DJJLXQJLDPR�GHL� VXEWRWDOL�FKH�DJJLXQJRQR�LO

Page 88: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

FDOFROR�GHOOD�VRPPD�GHO�IDWWXUDWR�GHL�QHJR]L�GHOOH�YDULH�FDWHJRULH��1HOO¶HVHPSLR�DEELDPR� DQFKH� VFHOWR� GL� GLYLGHUH� OH� YDULH� VH]LRQL� GHOO¶HOHQFR� VX� SL�� SDJLQH��2WWHQLDPR�TXHVWR�ULVXOWDWR�VHOH]LRQDQGR�O¶RS]LRQH�,QWHUUX]LRQH�GL�SDJLQD�IUD�JUXSSL��

)LJXUD���±�/D�ILQHVWUD�VXEWRWDOL�

1RQ� VL� WUDWWD� GL� LQWHUUX]LRQH� VX� GLYHUVL� IRJOL��PD� VX� GLYHUVH� SDJLQH� TXDQGR� LO�GRFXPHQWR�VDUj�VWDPSDWR��8QD�LQWHUUX]LRQH�GL�SDJLQD�YLHQH�YLVXDOL]]DWD�VX�XQ�IRJOLR�([FHO�FRQ�XQD�ULJD�WUDWWHJJLDWD��)LJXUD�����2JQL�YROWD�FKH�YHGHWH�TXHVWD�ULJD�WUDWWHJJLDWD��YHUUj�FUHDWD�XQD�QXRYD�SDJLQD�LQ�VWDPSD��

)LJXUD�����/H�LQWHUUX]LRQL�GL�SDJLQD

Page 89: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

([FHO�YL�PRVWUD�DQFKH� OH� LQWHUUX]LRQL�GL�SDJLQD�YHUWLFDOL�� YL�GLFH��DG�HVHPSLR��FKH�OD�SDJLQD�VWDPSDWD�DUULYHUj�ILQR�DOOD�FRORQQD�(��

/DVFLDPR�� SHU� LO�PRPHQWR�� GD� SDUWH� OH� VWDPSH� FKH� VDUDQQR� DUJRPHQWR� GHOOD�SURVVLPD�OH]LRQH��

3HU�RUD�WRUQLDPR�DL�VXEWRWDOL�VHPSOLFHPHQWH�SHU�GLUH�FKH�VH�YROHWH�ULPXRYHUH�L�VXEWRWDOL�� GRYHWH� ULDSULUH� OD� ILQHVWUD�6XEWRWDOL� H� SUHPHUH� LO� SXOVDQWH�5LPXRYL�WXWWL��

&RQFOXGLDPR�TXHVWD� OH]LRQH�GDQGR�XQ�RFFKLDWD�DO� VLVWHPD�XVDWR�GD�([FHO�SHU�FDOFRODUH�L�VXEWRWDOL��6H�RVVHUYDWH�OD�)LJXUD����QRWHUHWH�FKH�([FHO�XWLOL]]D�OD�IXQ]LRQH�6XEWRWDOH��

)LJXUD���±�/D�IXQ]LRQH�FKH�FDOFROD�L�VXEWRWDOL�

�XQD�IXQ]LRQH�FKH�ULFKLHGH�GXH�DUJRPHQWL��LO�SULPR�LQGLFD�TXDOH�IXQ]LRQH�YLHQH�XVDWD�SHU�LO�FDOFROR�GHL�VXEWRWDOL��,O�WLSR�GL�IXQ]LRQH�q�HVSUHVVD�FRQ�XQ�QXPHUR��$O�FRQWHJJLR�FRUULVSRQGH�LO�QXPHUR����(FFR�JOL�DOWUL�QXPHUL��

1XPHUR� )XQ]LRQH��� 0(',$��� &217$�180(5,��� &217$�9$/25,��� 0$;��� 0,1��� 352'2772��� '(9�67��� '(9�67�323��� 6200$���� 9$5���� 9$5�323

Page 90: Excel 2007 Intermedio

0LFURVRIW�([FHO������EDVH� /H]LRQH����

$OHVVDQGUD�6DOYDJJLR���0HUOLQ�:L]DUG�'0&�������� 7XWWL�L�GLULWWL�ULVHUYDWL� ��

2OWUH� DO� QXPHUR� GHOOD� IXQ]LRQH�� OD� IXQ]LRQH� 6XEWRWDOL� ULFKLHGH� GL� VSHFLILFDUH�O¶LQWHUYDOOR�GHL�GDWL�VX�FXL�YROHWH�ODYRUDUH��

3RWHWH�XVDUH�TXHVWD�IXQ]LRQH�DQFKH�VHQ]D�ULFRUUHUH�DL�VXEWRWDOL�GL�([FHO�