tag:blogger.com,1999:blog-7373868747610851792024-03-14T08:41:21.740-07:00Conociendo Herramientas Avanzadas de ExcelRebeccahttp://www.blogger.com/profile/13473860599626288589noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-737386874761085179.post-71106598193410601602012-01-30T17:57:00.000-08:002012-01-30T18:27:16.197-08:00Paso: 5La tabla de datos se verà modificada de la siguiente manera.<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEis3gg2qlneDvDTbCIvmmMT7lTbsfHWBNmtSnzZ8YBkBqh2NzpQQR99y3cEfY5FI94Fxc-7dqA7DeJsi2-C0yvcG36FrgfVd2XzZl_NJp0lIXqLGiGqqHmHvQxduKFMM3skdbvi0ZIye6U/s1600/Imagen+4.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="248" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEis3gg2qlneDvDTbCIvmmMT7lTbsfHWBNmtSnzZ8YBkBqh2NzpQQR99y3cEfY5FI94Fxc-7dqA7DeJsi2-C0yvcG36FrgfVd2XzZl_NJp0lIXqLGiGqqHmHvQxduKFMM3skdbvi0ZIye6U/s400/Imagen+4.JPG" width="400" /></a></div><div class="separator" style="clear: both; text-align: center;"></div><br />
<br />
<div class="separator" style="clear: both; text-align: center;"></div><br />
<div class="separator" style="clear: both; text-align: center;"></div>Rebeccahttp://www.blogger.com/profile/13473860599626288589noreply@blogger.com0tag:blogger.com,1999:blog-737386874761085179.post-25591625273259861472012-01-30T13:48:00.000-08:002012-01-30T14:44:14.995-08:00Paso 4:En forma automática aparecerán los siguientes cuadros de diálogos:<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEig2e6sb4HQAa6yUBOb7SHyZUdIZcmqLs73ExDVviI4KEcZ81OEX9v1QeAgpRXU1cMr5BzG6jXO6DJdPx2ID9uGIv-q-WHzhIuqnkUYfmxJwCELIA9JRtIiUiJ040V1BIfBZDMX_f1rMbk/s1600/Imagen+3.JPG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="205" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEig2e6sb4HQAa6yUBOb7SHyZUdIZcmqLs73ExDVviI4KEcZ81OEX9v1QeAgpRXU1cMr5BzG6jXO6DJdPx2ID9uGIv-q-WHzhIuqnkUYfmxJwCELIA9JRtIiUiJ040V1BIfBZDMX_f1rMbk/s400/Imagen+3.JPG" width="400" /></a></div><br />
5. Lo ordenaremos por producto, valores, <b>A a Z</b> y luego aceptar. <br />
6. Para el cuadro subtotales:<br />
<ul><li>Para cada cambio en: <b>Producto.</b></li>
<li>Usar función: <b>Suma.</b></li>
<li> Agregar subtotal a: <b>Cantidad vendida en $ </b></li>
</ul>Rebeccahttp://www.blogger.com/profile/13473860599626288589noreply@blogger.com0tag:blogger.com,1999:blog-737386874761085179.post-50517427374935620582012-01-28T08:41:00.001-08:002012-01-30T14:27:42.186-08:00Paso 3:<div class="separator" style="clear: both; text-align: left;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCrfVrLwRat3vE942aJCaQTjJcvSO1bXbzoeBwFC2MYjhEzk01XYqfle3-_tWHyDFiTKj5Ia5remaVunEcJAD2Ea51Ge9BSVMr7ciBND1IA_p6pQ1RLHqj51R5jcvy-A5XB6CUyxLDbjQ/s1600/Imagen+2.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="212" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjCrfVrLwRat3vE942aJCaQTjJcvSO1bXbzoeBwFC2MYjhEzk01XYqfle3-_tWHyDFiTKj5Ia5remaVunEcJAD2Ea51Ge9BSVMr7ciBND1IA_p6pQ1RLHqj51R5jcvy-A5XB6CUyxLDbjQ/s400/Imagen+2.JPG" width="400" /></a> </div><div class="separator" style="clear: both; text-align: left;">2.Seleccionaremos solamente la columna producto. </div><div class="separator" style="clear: both; text-align: left;">3.Click en el menú <b>Dato</b>s, </div><div class="separator" style="clear: both; text-align: left;">4.Luego click en el botón <b>Ordenar de A a Z </b>del grupo <b>ordenar y Filtrar.</b></div><div class="separator" style="clear: both; text-align: left;"> </div><br />
<div class="separator" style="clear: both; text-align: left;"></div><div class="" style="clear: both; text-align: left;"> </div>Rebeccahttp://www.blogger.com/profile/13473860599626288589noreply@blogger.com0tag:blogger.com,1999:blog-737386874761085179.post-87504691063932749632012-01-28T08:32:00.000-08:002012-01-30T17:40:31.105-08:00Paso 2:<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRWbmsFnq-En1u7TwEVX7eFnWtVRa4_J9BUGyyJUVcLFsh10M806i8hwDMXM_o66I4cn2Yl6rQSYbpVbXY_pnnFvNVpH1PKa6CAsZhZ7FFzM2sVLyb8dn4i_fpQnjdPh4AU1mmOJmbZmo/s1600/Imagen+1.JPG" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="236" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgRWbmsFnq-En1u7TwEVX7eFnWtVRa4_J9BUGyyJUVcLFsh10M806i8hwDMXM_o66I4cn2Yl6rQSYbpVbXY_pnnFvNVpH1PKa6CAsZhZ7FFzM2sVLyb8dn4i_fpQnjdPh4AU1mmOJmbZmo/s400/Imagen+1.JPG" width="400" /></a> 1. Luego que hemos abierto Excel, le daremos click en el menú <b>Datos.</b> Posteriormente en el grupo<b> Esquema</b><b> </b>se encuentra<b> </b>en el botón <b>Subtotal</b>. <br />
<div style="text-align: right;"></div><div style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none;"><img height="48" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgbLlvxph8Zw7A6EflG5Lqxe9r3Su4-g0q4K7N3_siMAZOE4RkDAeWLkvNScKv2nYCP7ANcj0zVxXRKNKMHvd6LOtHapx5PXmYzvHfi2ZOQVMhqkD2RHhg9vTJE8rNaXSgXGkHv3HwFsdY/s320/Imagen+1.JPG" style="filter: alpha(opacity=30); left: 25px; mozopacity: 0.3; opacity: 0.3; position: absolute; top: 21px; visibility: hidden;" width="96" /> </div>Rebeccahttp://www.blogger.com/profile/13473860599626288589noreply@blogger.com0tag:blogger.com,1999:blog-737386874761085179.post-74044893113351367742012-01-14T07:23:00.001-08:002012-01-14T07:26:56.559-08:00Video de Sub-totales<iframe allowfullscreen="" frameborder="0" height="315" src="http://www.youtube.com/embed/zqiQ81kpsQI" width="420"></iframe>Rebeccahttp://www.blogger.com/profile/13473860599626288589noreply@blogger.com1tag:blogger.com,1999:blog-737386874761085179.post-22611338181024624292011-12-17T07:26:00.000-08:002011-12-17T09:15:47.098-08:00Paso 1:Lo primero que haremos es darle click en el botòn inicio, todos los programas, posteriormente click en Microsoft office y luego abiremos Excel 2007.<br />
<br />
<div class="separator" style="clear: both; text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-m9e-BbALo0MRkRIdr_iC4fPsWESiDUXUONWlZWTjfrLYedmhbBHGUnwTPbZ0KQ4uxztg26PCplStCVEKRTEfCuB8SLwadh_gE95lZIN4nwnMf3XtihRozXQS9XQMNh66LOsQtfmge3E/s1600/Inicio.JPG" imageanchor="1" style="clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" oda="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh-m9e-BbALo0MRkRIdr_iC4fPsWESiDUXUONWlZWTjfrLYedmhbBHGUnwTPbZ0KQ4uxztg26PCplStCVEKRTEfCuB8SLwadh_gE95lZIN4nwnMf3XtihRozXQS9XQMNh66LOsQtfmge3E/s1600/Inicio.JPG" /></a></div>Rebeccahttp://www.blogger.com/profile/13473860599626288589noreply@blogger.com0tag:blogger.com,1999:blog-737386874761085179.post-23055953706503041412011-12-03T10:10:00.000-08:002012-01-07T09:23:07.157-08:00Bienvenido a mi Blogs!!!<div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: left; cssfloat: left; float: left; margin-bottom: 1em; margin-right: 1em; text-align: center;"><img border="0" height="291" mda="true" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjhvuqnLx2Aw9N0A-d_KcfPOZL1LzCN3BtbpHWmRye7OdmMyd9YhHdzDh7zIwMCAAv19FGqMOpfbnkSV__PF77HJzb4DbbfxjNHqix84O8X0SoqpCOl0VXw9XQmkyRhaZyWCpwxZ2nfOr8/s320/Logo+de+Excel.jpg" width="320" /></div>En este blog conoceremos una de las diferentes herramientas Avanzadas que nos brinda Excel, ya que muchas personas no conocen muy a fondo esta herramienta. Inicialmente te presentarè la herramienta <br />
<div class="separator" style="border-bottom: medium none; border-left: medium none; border-right: medium none; border-top: medium none; clear: both; text-align: left;"></div><div style="text-align: left;"> de sub-total.</div>Rebeccahttp://www.blogger.com/profile/13473860599626288589noreply@blogger.com0