Excel nivel intermedio

Warning (2): Trying to access array offset on value of type null [APP/View/Layouts/pages4.ctp, line 459]Code Context                                <div class="row">
                                    <div class="col-12 text-center">
                                        <h3><?php echo $usuario['nombre'].' '.$usuario['apellidos'];?></h3>
include - APP/View/Layouts/pages4.ctp, line 459
View::_evaluate() - CORE/Cake/View/View.php, line 971
View::_render() - CORE/Cake/View/View.php, line 933
View::renderLayout() - CORE/Cake/View/View.php, line 546
View::render() - CORE/Cake/View/View.php, line 481
Controller::render() - APP/Controller/Controller.php, line 968
PagesController::courseext() - APP/Controller/PagesController.php, line 3759
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 115

Warning (2): Trying to access array offset on value of type null [APP/View/Layouts/pages4.ctp, line 459]Code Context                                <div class="row">
                                    <div class="col-12 text-center">
                                        <h3><?php echo $usuario['nombre'].' '.$usuario['apellidos'];?></h3>
include - APP/View/Layouts/pages4.ctp, line 459
View::_evaluate() - CORE/Cake/View/View.php, line 971
View::_render() - CORE/Cake/View/View.php, line 933
View::renderLayout() - CORE/Cake/View/View.php, line 546
View::render() - CORE/Cake/View/View.php, line 481
Controller::render() - APP/Controller/Controller.php, line 968
PagesController::courseext() - APP/Controller/PagesController.php, line 3759
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 115

Warning (2): Trying to access array offset on value of type null [APP/View/Layouts/pages4.ctp, line 465]Code Context                                                    echo $Usuario['tipo'];
                                                } else {
                                                    if (Configure::read('Admin_acceso_casos')==1 && $Usuario['tipo']=='Administrador'){
include - APP/View/Layouts/pages4.ctp, line 465
View::_evaluate() - CORE/Cake/View/View.php, line 971
View::_render() - CORE/Cake/View/View.php, line 933
View::renderLayout() - CORE/Cake/View/View.php, line 546
View::render() - CORE/Cake/View/View.php, line 481
Controller::render() - APP/Controller/Controller.php, line 968
PagesController::courseext() - APP/Controller/PagesController.php, line 3759
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 115

Warning (2): Trying to access array offset on value of type null [APP/View/Layouts/pages4.ctp, line 468]Code Context                                                        echo __("Administrador");
                                                    }else{
                                                        if ($Usuario['tipo']=='Administrador'){
include - APP/View/Layouts/pages4.ctp, line 468
View::_evaluate() - CORE/Cake/View/View.php, line 971
View::_render() - CORE/Cake/View/View.php, line 933
View::renderLayout() - CORE/Cake/View/View.php, line 546
View::render() - CORE/Cake/View/View.php, line 481
Controller::render() - APP/Controller/Controller.php, line 968
PagesController::courseext() - APP/Controller/PagesController.php, line 3759
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 115

Usuario

Warning (2): Trying to access array offset on value of type null [APP/View/Layouts/pages4.ctp, line 483]Code Context                                        <?php
                                            
                                            echo $this->Html->image('temas/'.Configure::read('Generalconf.Temavisual').'/iconos/sin_usuario.jpg', array('alt' =>$usuario['nombre'].' '.$usuario['apellidos'], 'title' => $usuario['nombre'].' '.$usuario['apellidos'],'id'=>'foto_usuario_barra_grande','style'=>'margin:5px;'));
include - APP/View/Layouts/pages4.ctp, line 483
View::_evaluate() - CORE/Cake/View/View.php, line 971
View::_render() - CORE/Cake/View/View.php, line 933
View::renderLayout() - CORE/Cake/View/View.php, line 546
View::render() - CORE/Cake/View/View.php, line 481
Controller::render() - APP/Controller/Controller.php, line 968
PagesController::courseext() - APP/Controller/PagesController.php, line 3759
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 115

Warning (2): Trying to access array offset on value of type null [APP/View/Layouts/pages4.ctp, line 483]Code Context                                        <?php
                                            
                                            echo $this->Html->image('temas/'.Configure::read('Generalconf.Temavisual').'/iconos/sin_usuario.jpg', array('alt' =>$usuario['nombre'].' '.$usuario['apellidos'], 'title' => $usuario['nombre'].' '.$usuario['apellidos'],'id'=>'foto_usuario_barra_grande','style'=>'margin:5px;'));
include - APP/View/Layouts/pages4.ctp, line 483
View::_evaluate() - CORE/Cake/View/View.php, line 971
View::_render() - CORE/Cake/View/View.php, line 933
View::renderLayout() - CORE/Cake/View/View.php, line 546
View::render() - CORE/Cake/View/View.php, line 481
Controller::render() - APP/Controller/Controller.php, line 968
PagesController::courseext() - APP/Controller/PagesController.php, line 3759
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 115

Warning (2): Trying to access array offset on value of type null [APP/View/Layouts/pages4.ctp, line 483]Code Context                                        <?php
                                            
                                            echo $this->Html->image('temas/'.Configure::read('Generalconf.Temavisual').'/iconos/sin_usuario.jpg', array('alt' =>$usuario['nombre'].' '.$usuario['apellidos'], 'title' => $usuario['nombre'].' '.$usuario['apellidos'],'id'=>'foto_usuario_barra_grande','style'=>'margin:5px;'));
include - APP/View/Layouts/pages4.ctp, line 483
View::_evaluate() - CORE/Cake/View/View.php, line 971
View::_render() - CORE/Cake/View/View.php, line 933
View::renderLayout() - CORE/Cake/View/View.php, line 546
View::render() - CORE/Cake/View/View.php, line 481
Controller::render() - APP/Controller/Controller.php, line 968
PagesController::courseext() - APP/Controller/PagesController.php, line 3759
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 115

Warning (2): Trying to access array offset on value of type null [APP/View/Layouts/pages4.ctp, line 483]Code Context                                        <?php
                                            
                                            echo $this->Html->image('temas/'.Configure::read('Generalconf.Temavisual').'/iconos/sin_usuario.jpg', array('alt' =>$usuario['nombre'].' '.$usuario['apellidos'], 'title' => $usuario['nombre'].' '.$usuario['apellidos'],'id'=>'foto_usuario_barra_grande','style'=>'margin:5px;'));
include - APP/View/Layouts/pages4.ctp, line 483
View::_evaluate() - CORE/Cake/View/View.php, line 971
View::_render() - CORE/Cake/View/View.php, line 933
View::renderLayout() - CORE/Cake/View/View.php, line 546
View::render() - CORE/Cake/View/View.php, line 481
Controller::render() - APP/Controller/Controller.php, line 968
PagesController::courseext() - APP/Controller/PagesController.php, line 3759
ReflectionMethod::invokeArgs() - [internal], line ??
Controller::invokeAction() - APP/Controller/Controller.php, line 499
Dispatcher::_invoke() - CORE/Cake/Routing/Dispatcher.php, line 193
Dispatcher::dispatch() - CORE/Cake/Routing/Dispatcher.php, line 167
[main] - APP/webroot/index.php, line 115

Ir a mi panel de aprendizaje

Desconectar

Catálogo

Excel nivel intermedio

» Catálogo » Ofimática

Excel nivel intermedio

PROGRAMA:

Excel nivel intermedio– 12 horas

UNIDAD 1: Operaciones con fórmulas y funciones

Resumir datos con funciones
Realizar operaciones condicionales con funciones
Dar formato y modificar el texto con funciones
Macros

UNIDAD 2: Tablas y gráficos

Tablas de datos
Creación y edición de gráficos
Formato e impresión de gráficos

Contenido

Módulo:
Unidad 1: Operaciones con fórmulas y funciones y macros

Operaciones con fórmulas, funciones y macros

00:00:00

Resumen Unidad 1: Operaciones con fórmulas, funciones y macros

00:00:00

TESTS

1

Módulo:
Caso práctico de Unidad 1

Descarga de archivo del caso práctico

00:00:00

Caso práctico de la Unidad 1: Operaciones con fórmulas, funciones y macros.

00:00:00

Caso práctico de la Unidad 1: Operaciones con fórmulas, funciones y macros - Solución

00:00:00

Módulo:
Unidad 2: Tablas y gráficos

Tablas y gráficos

00:00:00

Resumen Tablas y gráficos

00:00:00

TESTS

1

Módulo:
Casos prácticos de Unidad 2: Tablas y gráficos

Caso practico

00:00:00

Caso practico - Solución

00:00:00

Módulo:
Actividad final

Descarga fichero actividad final

00:00:00

Actividad final

00:00:00

Solución Actividad final

00:00:00

Metodología

Curso 100% online con acceso a la plataforma de contenido 24/7 y tutorización de dudas

Este trabajo está licenciado bajo CC BY-NC-SA 4.0

Impartido por

Sonia Mendoza Orella

Profesor/a

Tereza Valtierra

Profesor/a

También te puede interesar...

Excel: trabajar con libros y hojas, crear vistas e imprimir

8 horas

PowerPoint 2016 nivel intermedio

12 horas

PowerPoint 2016 nivel avanzado

8 horas

Organízate en la nube

10 horas

Excel nivel avanzado

8 horas

Excel nivel básico

16 horas

12 horas

Accede ahora

Certificado acreditativo

Tutorías disponibles

Criterios