208,00€
Exento de IVA
Aprender a crear tablas de datos y tablas dinámicas, así como el empleo de filtros, criterios y resúmenes de las mismas.
Crear escenarios en los que ver rápidamente el cambio de ciertos valores que afecten a la hoja de cálculo. También ver cómo conseguir un objetivo desconocido a partir de unos criterios especificados.
Importar datos desde fuentes externas y utilizar funciones de bases de datos. Creación y uso de macros.
Crear cuadros de diálogo tanto predeterminados como propios. Aprender a trabajar en grupo compartiendo el libro de trabajo y asignando permisos a usuarios.
1) Funciones y cálculos complejos en Excel
2) Trabajo con datos hipotéticos
3) Listas y filtros
4) Datos externos
5) Tablas dinámicas
6) Colaboración
7) Macros
Público General
Otros cursos relacionados
4 horasTeleformación
25 horas Teleformación
7 horas</br />Aula virtual
30 horas Teleformación
Libros relacionados
Directivos de las empresas
Papel: 16,00€ (IVA Incluido)
La prevención de riesgos laborales constituye un área más de gestión en las empresas con independencia de su tamaño.Cómo elaborar el manual ambiental de la empresa según la norma ISO 14001:2004
Papel: 19,00€ - eBook: 11,43€ (IVA Incluido)
Hoy en día las empresas son muy conscientes de la importancia que para ellas supone el medio ambiente, bien sea como oportunidad de diferenciación de sus productos frente a la competencia, bien como punto de discusión con sus grupos de interés, o bien por el coste que representa.Cómo implantar la cultura preventiva en la empresa
Papel: 29,00€ (IVA Incluido)
El presente libro concreta el concepto "Cultura Preventiva" en algo así como "trabajar para el siguiente" lo que lo hace gestionable empresarialmente.Sistemas de archivo y documentación 2.0 en la empresa
Papel: 20,00€ - Ebook: 14,00€ (IVA Incluido)
Todos, empleados por cuenta ajena, profesionales liberales, funcionarios y emprendedores, nos vemos en un momento u otro abrumados por el volumen de la información que está a nuestra disposición y que, sin embargo, en el momento que se necesita, a veces no aparece.Cookie | Duración | Descripción |
---|---|---|
_GRECAPTCHA | 5 months 27 days | This cookie is set by the Google recaptcha service to identify bots to protect the website against malicious spam attacks. |
cookielawinfo-checkbox-advertisement | 1 year | Set by the GDPR Cookie Consent plugin, this cookie is used to record the user consent for the cookies in the "Advertisement" category . |
cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
cookielawinfo-checkbox-analytics | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics". |
cookielawinfo-checkbox-functional | 11 months | The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional". |
cookielawinfo-checkbox-necessary | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary". |
cookielawinfo-checkbox-others | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other. |
cookielawinfo-checkbox-performance | 11 months | This cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance". |
CookieLawInfoConsent | 1 year | Records the default button state of the corresponding category & the status of CCPA. It works only in coordination with the primary cookie. |
elementor | never | This cookie is used by the website's WordPress theme. It allows the website owner to implement or change the website's content in real-time. |
PHPSESSID | session | This cookie is native to PHP applications. The cookie is used to store and identify a users' unique session ID for the purpose of managing user session on the website. The cookie is a session cookies and is deleted when all the browser windows are closed. |
viewed_cookie_policy | 11 months | The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data. |
Cookie | Duración | Descripción |
---|---|---|
bcookie | 1 year | LinkedIn sets this cookie from LinkedIn share buttons and ad tags to recognize browser ID. |
bscookie | 1 year | LinkedIn sets this cookie to store performed actions on the website. |
lang | session | LinkedIn sets this cookie to remember a user's language setting. |
lidc | 1 day | LinkedIn sets the lidc cookie to facilitate data center selection. |
UserMatchHistory | 1 month | LinkedIn sets this cookie for LinkedIn Ads ID syncing. |
Cookie | Duración | Descripción |
---|---|---|
_ga | 2 years | The _ga cookie, installed by Google Analytics, calculates visitor, session and campaign data and also keeps track of site usage for the site's analytics report. The cookie stores information anonymously and assigns a randomly generated number to recognize unique visitors. |
_ga_K64EM3X0WF | 2 years | This cookie is installed by Google Analytics. |
_gcl_au | 3 months | Provided by Google Tag Manager to experiment advertisement efficiency of websites using their services. |
utm_campaign | past | Google Ad Services sets this cookie to store session campaign value if present. |
utm_content | past | This cookie is used for storing the session content value if present. |
utm_source | past | This cookie is used to record from where the visitor came to the website orginally. This information is used by the website operator to know the efficiency of their marketing. |
utm_term | past | This cookie is used to record from where the visitor came to the website orginally. This information is used by the website operator to know the efficiency of their marketing. |
Cookie | Duración | Descripción |
---|---|---|
_fbp | 3 months | This cookie is set by Facebook to display advertisements when either on Facebook or on a digital platform powered by Facebook advertising, after visiting the website. |
fr | 3 months | Facebook sets this cookie to show relevant advertisements to users by tracking user behaviour across the web, on sites that have Facebook pixel or Facebook social plugin. |
IDE | 1 year 24 days | Google DoubleClick IDE cookies are used to store information about how the user uses the website to present them with relevant ads and according to the user profile. |
test_cookie | 15 minutes | The test_cookie is set by doubleclick.net and is used to determine if the user's browser supports cookies. |
utm_medium | past | This cookie is used to record from where the visitor came to the website orginally. This information is used by the website operator to know the efficiency of their marketing. |
Cookie | Duración | Descripción |
---|---|---|
_learn_press_session_5167216fe626261582c1f3324b159ee2 | 2 days | No description |
_tt_enable_cookie | 1 year 24 days | No description |
_ttp | 1 year 24 days | No description |
_wordpress_lp_guest | 1 hour | No description |
AnalyticsSyncHistory | 1 month | No description |
past | No description available. | |
gclid | past | No description |
handl_ip | 1 month | No description available. |
handl_landing_page | 1 month | No description available. |
handl_original_ref | 1 month | No description available. |
handl_ref | 1 month | No description available. |
handl_url | 1 month | No description available. |
li_gc | 5 months 27 days | No description |
urlFachada | 1 month | No description |
username | past | No description available. |