Excel: funciones y macros

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: funciones y macros

» Catálogo » Ofimática

Excel: funciones y macros

Programa: Funciones y macros

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

Contenido

Módulo:
Operaciones con fórmulas, funciones y macros

Funciones y Macros

00:00:00

Resumen Funciones y Macros

00:00:00

TESTS

1

Módulo:
Casos prácticos Funciones y Macros

Archivo de trabajo para el caso práctico

00:00:00

Caso practico

00:00:00

Caso practico - Solución

00:00:00

Módulo:
Actividad final

Archivos de trabajo para actividad final

00:00:00

Actividad final

00:00:00

Soluciones 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...

PowerPoint 2016 nivel básico

8 horas

Excel: tablas dinámicas y gráficos

10 horas

Word Office 2016 nivel avanzado

16 horas

PowerPoint 2016 nivel intermedio

12 horas

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

8 horas

Hodeian lan egin eta kolaboratu

10 horas

8 horas

Accede ahora

Certificado acreditativo

Tutorías disponibles

Criterios