tag:blogger.com,1999:blog-28103825509411646152024-03-05T18:03:43.920-08:00CURSO DE EXCELcarloshttp://www.blogger.com/profile/13515135295406502167noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-2810382550941164615.post-72538518779532088002010-09-17T16:21:00.001-07:002010-11-26T15:45:15.307-08:00EXCEL BASICO Y AVANZADO<div class="MsoNormal" style="margin: 0cm 0cm 10pt;"><div align="center" class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 10pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: center;"><div style="text-align: left;"><div style="text-align: left;"><span lang="ES-VE" style="font-family: "Times New Roman", "serif"; font-size: 14pt; mso-ansi-language: ES-VE; mso-bidi-font-weight: bold; mso-fareast-font-family: SimSun; mso-fareast-language: ZH-CN; mso-font-kerning: 18.0pt;"></span><br />
<div align="center" class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: center;"><b style="mso-bidi-font-weight: normal;"><span style="color: black; font-size: 14pt; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: Helvetica; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;"><span style="font-family: Calibri;">Dirección práctica: <a href="http://www.box.net/shared/vh7v2da5lg">viernes</a></span></span></b><br />
<br />
<b style="mso-bidi-font-weight: normal;"><span style="color: black; font-size: 14pt; mso-ascii-font-family: Calibri; mso-ascii-theme-font: minor-latin; mso-bidi-font-family: Helvetica; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES; mso-hansi-font-family: Calibri; mso-hansi-theme-font: minor-latin;"><span style="font-family: Calibri;">BASES DE DATOS</span></span></b></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; letter-spacing: -0.1pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES; mso-themecolor: text1;">Una ba</span><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES; mso-themecolor: text1;">s<span style="letter-spacing: -0.1pt;">e de da</span>t<span style="letter-spacing: -0.1pt;">os e</span>s<span style="letter-spacing: -0.1pt;"> una c</span>o<span style="letter-spacing: -0.1pt;">le</span>c<span style="letter-spacing: -0.1pt;">c</span>i<span style="letter-spacing: -0.1pt;">ón de inform</span>a<span style="letter-spacing: -0.1pt;">c</span>i<span style="letter-spacing: -0.1pt;">ón que de a</span>l<span style="letter-spacing: -0.1pt;">guna m</span>a<span style="letter-spacing: -0.1pt;">ne</span>r<span style="letter-spacing: -0.1pt;">a pose</span>e<span style="letter-spacing: -0.1pt;"> un orde</span>n<span style="letter-spacing: -0.1pt;">. </span></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; letter-spacing: 0.85pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES; mso-themecolor: text1;">Conceptos sobre bases de datos </span></b></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; letter-spacing: -0.35pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES; mso-themecolor: text1;">Campos</span></b><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; letter-spacing: -0.25pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES; mso-themecolor: text1;">: Son los títulos o nom</span><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES; mso-themecolor: text1;">b<span style="letter-spacing: -0.25pt;">re de la</span>s<span style="letter-spacing: -0.25pt;"> c</span>o<span style="letter-spacing: -0.25pt;">lum</span>n<span style="letter-spacing: -0.25pt;">a</span>s<span style="letter-spacing: -0.25pt;">, se de</span>f<span style="letter-spacing: -0.25pt;">ine</span>n<span style="letter-spacing: -0.25pt;"> la e</span>s<span style="letter-spacing: -0.25pt;">truc</span>t<span style="letter-spacing: -0.25pt;">ura de</span> <span style="letter-spacing: -0.25pt;">ba</span>s<span style="letter-spacing: -0.25pt;">e de da</span>t<span style="letter-spacing: -0.25pt;">os. Ca</span>d<span style="letter-spacing: -0.25pt;">a</span><span style="letter-spacing: -0.35pt;"> </span><span style="letter-spacing: -0.1pt;">c</span>o<span style="letter-spacing: -0.1pt;">lum</span>n<span style="letter-spacing: -0.1pt;">a o c</span>a<span style="letter-spacing: -0.1pt;">m</span>p<span style="letter-spacing: -0.1pt;">o de</span>b<span style="letter-spacing: -0.1pt;">e c</span>o<span style="letter-spacing: -0.1pt;">nte</span>n<span style="letter-spacing: -0.1pt;">e</span>r<span style="letter-spacing: -0.1pt;"> da</span>t<span style="letter-spacing: -0.1pt;">os de</span>l<span style="letter-spacing: -0.1pt;"> m</span>i<span style="letter-spacing: -0.1pt;">sm</span>o<span style="letter-spacing: -0.1pt;"> tipo, por e</span>j<span style="letter-spacing: -0.1pt;">e</span>m<span style="letter-spacing: -0.1pt;">plo fe</span>c<span style="letter-spacing: -0.1pt;">ha</span>s<span style="letter-spacing: -0.1pt;">, nom</span>b<span style="letter-spacing: -0.1pt;">re</span>s<span style="letter-spacing: -0.1pt;">, pre</span>c<span style="letter-spacing: -0.1pt;">ios o porc</span>e<span style="letter-spacing: -0.1pt;">nta</span>j<span style="letter-spacing: -0.1pt;">e</span>s<span style="letter-spacing: -0.1pt;">. </span></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; letter-spacing: -0.1pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES; mso-themecolor: text1;">R</span></b><b style="mso-bidi-font-weight: normal;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES; mso-themecolor: text1;">e<span style="letter-spacing: -0.1pt;">g</span>i<span style="letter-spacing: -0.1pt;">st</span>r<span style="letter-spacing: -0.1pt;">os</span></span></b><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; letter-spacing: -0.1pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES; mso-themecolor: text1;">: </span><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; letter-spacing: -0.25pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES; mso-themecolor: text1;">Son los da</span><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES; mso-themecolor: text1;">t<span style="letter-spacing: -0.25pt;">os e</span>n<span style="letter-spacing: -0.25pt;"> sí, a c</span>a<span style="letter-spacing: -0.25pt;">da uno le c</span>o<span style="letter-spacing: -0.25pt;">rre</span>s<span style="letter-spacing: -0.25pt;">ponde una fila</span>,<span style="letter-spacing: -0.25pt;"> pa</span>r<span style="letter-spacing: -0.25pt;">a c</span>a<span style="letter-spacing: -0.25pt;">da da</span>t<span style="letter-spacing: -0.25pt;">o ha</span>b<span style="letter-spacing: -0.25pt;">rá un re</span>g<span style="letter-spacing: -0.25pt;">istro.</span><span style="letter-spacing: -0.1pt;"> </span></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; letter-spacing: 0.85pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES; mso-themecolor: text1;">Crear una base de datos en Excel </span></b></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><br />
</div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; letter-spacing: -0.25pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES; mso-themecolor: text1;">Ba</span><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-fareast-font-family: "Times New Roman"; mso-fareast-language: ES; mso-themecolor: text1;">s<span style="letter-spacing: -0.25pt;">ta</span>r<span style="letter-spacing: -0.25pt;">á c</span>o<span style="letter-spacing: -0.25pt;">n e</span>s<span style="letter-spacing: -0.25pt;">c</span>r<span style="letter-spacing: -0.25pt;">ibir los nom</span>b<span style="letter-spacing: -0.25pt;">re</span>s<span style="letter-spacing: -0.25pt;"> de los c</span>a<span style="letter-spacing: -0.25pt;">m</span>p<span style="letter-spacing: -0.25pt;">os e</span>n<span style="letter-spacing: -0.25pt;"> la fila supe</span>r<span style="letter-spacing: -0.25pt;">ior e inic</span>i<span style="letter-spacing: -0.25pt;">a</span>r<span style="letter-spacing: -0.25pt;"> la digita</span>c<span style="letter-spacing: -0.25pt;">ión de los re</span>g<span style="letter-spacing: -0.25pt;">istros e</span>n<span style="letter-spacing: -0.25pt;"> la</span>s<span style="letter-spacing: -0.25pt;"> fila</span>s<span style="letter-spacing: -0.25pt;"> infe</span>r<span style="letter-spacing: -0.25pt;">iore</span>s<span style="letter-spacing: -0.25pt;"> </span></span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><br />
</div><div class="padding-1" style="margin: 12pt 7.5pt 3.75pt 0cm; text-indent: 0cm;"><b style="mso-bidi-font-weight: normal;"><span style="color: black; font-size: 12pt; mso-themecolor: text1;">TABLA DINAMICA</span></b></div><div class="padding-1" style="margin: 12pt 7.5pt 3.75pt 0cm; text-indent: 0cm;"><span style="color: black; font-size: 12pt; mso-themecolor: text1;">Una tabla dinámica consiste en el resumen de un conjunto de datos, atendiendo a varios criterios de agrupación, representado como una tabla de doble entrada que nos facilita la interpretación de dichos datos. Es dinámica porque nos permite ir obteniendo diferentes totales, filtrando datos, cambiando la presentación de los datos, visualizando o no los datos origen, etc...</span></div><div class="padding-1" style="margin: 12pt 7.5pt 3.75pt 0cm; text-indent: 0cm;"><span style="color: black; font-size: 12pt; mso-themecolor: text1;">Veamos cómo podemos crear una tabla dinámica a partir de unos datos que ya tenemos. </span></div>________________________________________<br />
<br />
<span lang="ES-VE" style="font-family: "Times New Roman", "serif"; font-size: 14pt; mso-ansi-language: ES-VE; mso-bidi-font-weight: bold; mso-fareast-font-family: SimSun; mso-fareast-language: ZH-CN; mso-font-kerning: 18.0pt;">COMBINACIONES DE TECLAS EN EXCEL 2007</span></div><br />
<br />
<table border="1" cellpadding="0" cellspacing="0" class="MsoTableGrid" style="border-bottom: medium none; border-collapse: collapse; border-left: medium none; border-right: medium none; border-top: medium none; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; mso-yfti-tbllook: 1184;"><tbody>
<tr style="mso-yfti-firstrow: yes; mso-yfti-irow: 0;"><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; border-right: windowtext 1pt solid; border-top: windowtext 1pt solid; mso-border-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 133pt;" valign="top" width="177"><div align="justify" class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: center;"><b style="mso-bidi-font-weight: normal;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Combinación Teclas</span></b></div></td><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: #ece9d8; border-right: windowtext 1pt solid; border-top: windowtext 1pt solid; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 233.9pt;" valign="top" width="312"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Resultado</span></b></div></td></tr>
<tr style="mso-yfti-irow: 1;"><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 133pt;" valign="top" width="177"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Ctrl + 1</span></b></div></td><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: #ece9d8; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 233.9pt;" valign="top" width="312"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Formato Celdas.</span></div></td></tr>
<tr style="mso-yfti-irow: 2;"><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 133pt;" valign="top" width="177"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Shift + F11</span></b></div></td><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: #ece9d8; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 233.9pt;" valign="top" width="312"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Inserta Nueva Hoja.</span></div></td></tr>
<tr style="mso-yfti-irow: 3;"><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 133pt;" valign="top" width="177"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Ctrl + ,</span></b></div></td><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: #ece9d8; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 233.9pt;" valign="top" width="312"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Inserta fecha actual en una celda.</span></div></td></tr>
<tr style="mso-yfti-irow: 4;"><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 133pt;" valign="top" width="177"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Ctrl + Shift + .</span></b></div></td><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: #ece9d8; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 233.9pt;" valign="top" width="312"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Inserta Hora actual en una celda.</span></div></td></tr>
<tr style="mso-yfti-irow: 5;"><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 133pt;" valign="top" width="177"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Ctrl + Inicio</span></b></div></td><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: #ece9d8; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 233.9pt;" valign="top" width="312"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Te coloca al comienzo de una hoja.</span></div></td></tr>
<tr style="mso-yfti-irow: 6;"><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 133pt;" valign="top" width="177"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Ctrl + Fin</span></b></div></td><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: #ece9d8; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 233.9pt;" valign="top" width="312"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Te coloca al final de la hoja.</span></div></td></tr>
<tr style="mso-yfti-irow: 7;"><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 133pt;" valign="top" width="177"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Ctrl + :</span></b></div></td><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: #ece9d8; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 233.9pt;" valign="top" width="312"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Te coloca la hora en una celda.</span></div></td></tr>
<tr style="mso-yfti-irow: 8;"><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 133pt;" valign="top" width="177"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Ctrl + N</span></b></div></td><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: #ece9d8; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 233.9pt;" valign="top" width="312"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Coloca el contenido de la celda en Negrita</span></div></td></tr>
<tr style="mso-yfti-irow: 9;"><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 133pt;" valign="top" width="177"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Shift + F2</span></b></div></td><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: #ece9d8; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 233.9pt;" valign="top" width="312"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Insertar un comentario en una Celda.</span></div></td></tr>
<tr style="mso-yfti-irow: 10;"><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 133pt;" valign="top" width="177"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Shift + Alt + =</span></b></div></td><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: #ece9d8; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 233.9pt;" valign="top" width="312"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Inserta la función suma</span></div></td></tr>
<tr style="mso-yfti-irow: 11;"><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 133pt;" valign="top" width="177"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Alt - Tab</span></b></div></td><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: #ece9d8; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 233.9pt;" valign="top" width="312"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Cambia entre aplicaciones.</span></div></td></tr>
<tr style="mso-yfti-irow: 12; mso-yfti-lastrow: yes;"><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: windowtext 1pt solid; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 133pt;" valign="top" width="177"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Ctrl + F2</span></b></div></td><td style="background-color: transparent; border-bottom: windowtext 1pt solid; border-left: #ece9d8; border-right: windowtext 1pt solid; border-top: #ece9d8; mso-border-alt: solid windowtext .5pt; mso-border-left-alt: solid windowtext .5pt; mso-border-top-alt: solid windowtext .5pt; padding-bottom: 0cm; padding-left: 5.4pt; padding-right: 5.4pt; padding-top: 0cm; width: 233.9pt;" valign="top" width="312"><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 0pt; text-align: justify;"><span style="color: black; font-family: "Times New Roman", "serif"; font-size: 12pt; mso-themecolor: text1;">Vista preliminar.</span></div></td></tr>
</tbody></table><br />
<br />
<span lang="ES-VE" style="font-family: "Times New Roman", "serif"; font-size: 14pt; mso-ansi-language: ES-VE; mso-bidi-font-weight: bold; mso-fareast-font-family: SimSun; mso-fareast-language: ZH-CN; mso-font-kerning: 18.0pt;">¿ QUÉ ES UNA FÓRMULA EN EXCEL ?</span></div></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 10pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;"><span lang="ES-VE" style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-ansi-language: ES-VE; mso-fareast-font-family: SimSun; mso-fareast-language: ZH-CN;">Las fórmulas en Excel son expresiones que se utilizan para realizar cálculos o procesamiento de valores, produciendo un nuevo valor que será asignado a la celda en la cual se introduce dicha fórmula. En una fórmula, por lo general,<span style="mso-spacerun: yes;"> </span>intervienen valores que se encuentran en una o más celdas de un libro de trabajo. Las fórmulas están conformadas por operadores de cálculo, operandos y, con frecuencia, por funciones. Para introducir una fórmula en una celda, se debe entrar como primer carácter el signo igual ( El signo igual<span style="mso-spacerun: yes;"> </span>=<span style="mso-spacerun: yes;"> </span>le indica a Excel que los caracteres que le siguen<span style="mso-spacerun: yes;"> </span>constituyen una fórmula ). <b style="mso-bidi-font-weight: normal;">Cuando se escribe la fórmula no se deben dejar espacios en blanco dentro de la misma</b>.</span></div><div class="MsoNormal" style="line-height: normal; margin: 0cm 0cm 10pt; mso-margin-bottom-alt: auto; mso-margin-top-alt: auto; text-align: justify;"><span lang="ES-VE" style="font-family: "Times New Roman", "serif"; font-size: 12pt; mso-ansi-language: ES-VE; mso-fareast-font-family: SimSun; mso-fareast-language: ZH-CN;">Por ejemplo,<span style="mso-spacerun: yes;"> </span>la<span style="mso-spacerun: yes;"> </span>fórmula<span style="mso-spacerun: yes;"> </span><b style="mso-bidi-font-weight: normal;">=A5+A4*3 <span style="mso-spacerun: yes;"> </span></b>expresa que<b style="mso-bidi-font-weight: normal;"><span style="mso-spacerun: yes;"> </span></b>se multiplique<span style="mso-spacerun: yes;"> </span>el valor que contiene la celda <b style="mso-bidi-font-weight: normal;">A4</b> por el valor constante<span style="mso-spacerun: yes;"> </span><b style="mso-bidi-font-weight: normal;">3</b> y, a continuación, se le sume el valor que contiene la celda <b style="mso-bidi-font-weight: normal;">A5</b> al anterior resultado ( como se verá mas adelante la multiplicación <b style="mso-bidi-font-weight: normal;">*</b> tiene mayor prioridad que la suma <b style="mso-bidi-font-weight: normal;">+ </b>).<span style="mso-spacerun: yes;"> </span>Si la celda <b style="mso-bidi-font-weight: normal;">A5</b> contiene el valor numérico <b style="mso-bidi-font-weight: normal;">15</b>, la celda <b style="mso-bidi-font-weight: normal;">A4</b> contiene el valor numérico <b style="mso-bidi-font-weight: normal;">4</b>, entonces, esta fórmula al ser calculado por el Excel<span style="mso-spacerun: yes;"> </span>producirá<span style="mso-spacerun: yes;"> </span><b style="mso-bidi-font-weight: normal;">27</b> como resultado final, el cual será asignado a la celda en la que se ingresó la fórmula.</span><br />
<br />
PREGUNTAS<br />
<br />
<div style="text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="color: #333333; font-family: "Verdana", "sans-serif"; font-size: 9pt;">¿Qué tipos de OPERADORES UTILIZA EXCEL?</span></b></div><div style="text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="color: #333333; font-family: "Verdana", "sans-serif"; font-size: 9pt;">¿Qué es una FUNCION EXCEL?</span></b></div><div style="text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="color: #333333; font-family: "Verdana", "sans-serif"; font-size: 9pt;">¿Cuál es la prioridad de los operadores EXCEL?</span></b></div><div style="text-align: justify;"><b style="mso-bidi-font-weight: normal;"><span style="color: #333333; font-family: "Verdana", "sans-serif"; font-size: 9pt;">¿Qué es una MACRO en EXCEL?.</span></b></div><br />
<br />
Tomado de: <a href="http://isis.faces.ula.ve/">http://isis.faces.ula.ve/</a></div></div><div style="text-align: left;"><a href="mailto:corpuexcel@gmail.com">corpuexcel@gmail.com</a></div>carloshttp://www.blogger.com/profile/13515135295406502167noreply@blogger.com