Valla diana excel
Transcript of Valla diana excel
![Page 1: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/1.jpg)
UNIVERSIDAD NACIONAL DE CHIMBORAZO
NOMBRE: diana valla
DEBER DE INFORMATICA
FECHA: 04/02/2014
![Page 2: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/2.jpg)
LECCIÓN 1
INTRODUCCIÓN
![Page 3: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/3.jpg)
LECCION 2
ABRIR EXEL 2010
![Page 4: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/4.jpg)
LECCION 3
INTERFAZ EXCEL 2010
![Page 5: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/5.jpg)
LECCION 4
ARCHIVO GUARDAR
![Page 6: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/6.jpg)
LECCIÓN 5
FILAS Y COLUNMAS-CELDAS
![Page 7: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/7.jpg)
LECCION 6
BARRA DE ACCESO RAPIDO
![Page 8: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/8.jpg)
LECCION 7
DESPALSARZE ENTRE CELDAS, FILAS Y COLUMNAS
![Page 9: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/9.jpg)
LECCION 8
AJUSTES PARA FILAS Y COLUMNAS
![Page 10: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/10.jpg)
Lección 9
HERRAMIENTA DE ZOOM
![Page 11: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/11.jpg)
LECCION 10
FORMATO DE TABLA- ALINEAR Y APLICAR NEGRITA
![Page 12: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/12.jpg)
LECCION 11
FORMATO DE TABLA –DIBUJAR BORDE
![Page 13: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/13.jpg)
LECCION 12
![Page 14: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/14.jpg)
FORMATO A LA TABLA - ORDENAR ALFABÉTICAMENTE E INSERTAR FILAS
LECCION 13
![Page 15: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/15.jpg)
FORMATO A LA TABLA - INSERTAR COLUMNAS
LECCION 14
![Page 16: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/16.jpg)
INSERTAR Y ELIMINAR HOJAS
LECCION 15
![Page 17: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/17.jpg)
FORMATOS DE FUENTE, CÓMO CAMBIAR EL ASPECTO DEL TEXTO Y LOS NÚMEROS
![Page 18: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/18.jpg)
LECCION 16
FORMATOS DE FUENTE
![Page 19: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/19.jpg)
LECCION 17
ALINEAR Y AJUSTAR EN RELACIÓN AL ANCHO DE UNA CELDA
LECCION 18
Aplicar formatos - Dibujar bordes a Tabla, Formato a cantidades y
Combinar Celdas
![Page 20: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/20.jpg)
LECCION 19
APLICAR FORMATOS - DIBUJAR BORDES A TABLA, FORMATO A CANTIDADES Y
COMBINAR CELDAS
![Page 21: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/21.jpg)
LECCION 20
OPERACIONES CON SUMAS
![Page 22: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/22.jpg)
![Page 23: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/23.jpg)
LECCION 21
OPERACIONES CON SUMAS
LECCION 22
![Page 24: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/24.jpg)
OPERACIONES EN UNA CELDA - SUMA, MULTIPLICACIÓN, DIVISIÓN Y COMBINADAS
LECCION 23
![Page 25: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/25.jpg)
Generación automática de nombres
![Page 26: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/26.jpg)
LECCION 24
Biblioteca de Funciones
![Page 27: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/27.jpg)
Lección 25
Biblioteca de Funciones - Insertar funciones (Contar)
![Page 28: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/28.jpg)
Lección 26
Generación automática de series alfanuméricas lógicas
![Page 29: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/29.jpg)
Lección 27
Asignar un Rango de Celdas
![Page 30: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/30.jpg)
Lección 28
Operaciones con Rangos
![Page 31: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/31.jpg)
Lección 29
Cortar, Copiar y Pegar
![Page 32: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/32.jpg)
![Page 33: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/33.jpg)
Lección 30
Función Auto rellenó
![Page 34: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/34.jpg)
Lección 31
Copiar Fórmulas
![Page 35: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/35.jpg)
Lección 32
Copiar Fórmulas 2
![Page 36: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/36.jpg)
Lección 33
Insertar Gráficos
![Page 37: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/37.jpg)
Lección 34
Modificar Gráficos
![Page 38: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/38.jpg)
Lección 35
Eliminar Filas y Columnas
![Page 39: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/39.jpg)
Lección 36
Crear Organigramas con Smart Art
![Page 40: Valla diana excel](https://reader033.fdocument.pub/reader033/viewer/2022042516/559c56a31a28ab991c8b482a/html5/thumbnails/40.jpg)
Lección 37
Modificar Organigramas