Microsoft Excel 2019 Expert Course, VBA, Business Intelligence, KPI, DAX and Dashboards + University Degree Microsoft Excel 2019 Expert Course, VBA, Business Intelligence, KPI, DAX and Dashboards + University Degree

Online Training

Microsoft Excel 2019 Expert Course, VBA, Business Intelligence, KPI, DAX and Dashboards + University Degree

icon-image--AbjlOSDZzVEJNY0s3S__icon_7yVPEV

650 hours

icon-image--AcnI1bkFZTjZZaTE3U__icon_xJgfxr

5 ECTS

icon-image--AWUI0N2tWMzVrNzMzT__icon_DgE8xz

Spanish

Educational institutions

Logo institución
Logo institución
$2.662.000

Request information

Microsoft Excel 2019 Expert Course, VBA, Business Intelligence, KPI, DAX and Dashboards + University Degree

Request information Request information

Details to take into account

icon-image--AUzhDQ3dCN3hXZ1RaS__icon_p9pcRc

Multilingual support

icon-image--AQVZldVUybkd2c2xSS__icon_ptJqNh

Digital certificate included

icon-image--AV0haRDQrMjBZRURoV__icon_zyt3R8

Assistant Phia

Objectives

- Offer the student the necessary knowledge in spreadsheets to perform the most advanced operations in Microsoft Excel, with special emphasis on recording macros with VBA and the application of Excel in business intelligence. - Work, analyze and use data tables and lists. - Know and manage databases, graphs, diagrams, logical functions and other basic tools. - Learn to apply the most advanced functions of Excel. - Learn to write macros using the VBA programming language in Excel. - Have the VBA programming fundamentals necessary for its correct application in Excel. - Know how to take advantage of Excel tools for the development of business intelligence strategies. - Know how advanced business intelligence tools work in Excel such as PowerPivot, DAX expression language, Power View, PowerQuery or PowerMaps. - Detect and create the KPIs of a business project and translate them into a comprehensive dashboard through PowerPivot.

Content

Career opportunities

IT, Programming, Offices, Teaching, Administration, Secretariat, Office automation.

What it prepares you for

This training program aims to provide students with specific and in-depth knowledge of Microsoft Excel, offering them the possibility of customizing the application to the needs of any organization. The course begins by presenting basic functionalities such as recording Office macros but also continues writing macros from the VBA (Visual Basic for Applications) programming language. In addition, a substantially practical vision is offered so that the student can apply everything learned in their professional environment and be able to detect and visualize data in a more intuitive, simple and easy way.

Addressed to

Aimed at all those professionals from any business sector who wish to master Microsoft Excel to prepare data analysis and issue reports of any kind (financial, accounting, analytical, sales, etc.). It is also aimed at students who want to deepen their knowledge of the most advanced tools of Microsoft Excel 2019 and their application for the design of business systems.

Methodology

Our training is 100% online, which allows students to self-regulate their study and adapt it to their own needs. We are committed to personalized and autonomous teaching, with an approach based on critical thinking and constructivism.

We have a highly specialized teaching team that will accompany you throughout the entire teaching-learning process. This will allow you to personalize your training even more, since we adapt to your pace and needs.

You will have access to our learning platform, MyLXP, from any device and at any time of the day, allowing you to decide how and when to study. All of this is possible thanks to our Educa LXP (Learning Experience Platform) methodology, an environment designed to boost your educational progress, encourage innovation and offer a personalized learning experience adapted to each need.

Certificación

Double Degree: - Expert Degree in Microsoft Excel 2019, VBA, Business Intelligence, KPI, DAX and Dashboards issued by EUROINNOVA INTERNATIONAL ONLINE EDUCATION, member of the AEEN (Spanish Association of Business Schools) and recognized with academic excellence in online education by QS World University Rankings - University Degree in Advanced Excel 2019 with 5 ECTS University Credits.
Logo certificado Logo certificado
Diploma certificado Diploma certificado

Becas EducaHub

Haz tu formación más accesible: financia al 0% interés y obtén becas personalizadas.

-25%

Beca Alumni

¡Premiamos tu fidelidad y confianza! Si anteriormente has completado algún curso o master en Euroinnova, te ofrecemos una beca del 25 %.

-20%

Beca desempleo

Mejorar tu perfil profesional se convierte en la mejor manera de aumentar tus posibilidades de encontrar un trabajo. ¡Invierte en formación con esta beca del 20 %! Eso sí, será imprescindible que acredites tu situación como desempleado.

-15%

Beca emprende

¿Estás emprendiendo y quieres actualizar tu conocimiento? ¡Aprovecha esta beca del 15% de descuento! Como requisito debes saber que tendrás que estar dado de alta como autónomo, además de contar con la última declaración-liquidación del IVA.

-15%

Beca recomienda

¿Te han recomendado alguna de nuestras formaciones? Si vienes de parte de una persona que ha estudiado previamente en nuestra institución educativa, ¡contarás con una beca de 15%!

-15%

Beca grupo

¡Fórmate en grupo para no perder el foco! Si decides matricularte con tres o más personas en cualquier formación de nuestro catálogo, disfrutaréis de una beca del 15 %.

-20%

Beca discapacidad

¡Apostamos por una educación inclusiva y de calidad! Beca del 20 % destinada a aquellas personas que tengan una discapacidad igual o superior al 33%. Imprescindible presentar certificado de discapacidad.

-20%

Beca familia numerosa

Somos conscientes del esfuerzo que muchas familias realizan para que sus hijos/as reciban una buena educación. Por ello, tenemos una beca del 20% para aquellas familias formadas por tres o más descendientes. Imprescindible presentar el documento que acredita dicha condición.

Related training

Master AI Course with Gemini
image-block-47481500270805

EUROINNOVA INTERNATIONAL ONLINE EDUCATION

Master AI Course with Gemini

icon-image--ANlFPVW1HaVZORlcxV__icon_zk7t3d

1 hours

icon-image--AcWRyeEl4ZzBZUDRwY__icon_cKcHTw

On-line

icon-image--ARWNTdU02Q0U5RE14R__icon_R4QF8H

0 ECTS

$0
Logo institución
Free Neuroeducation course
image-block-46865557749973

EUROINNOVA INTERNATIONAL ONLINE EDUCATION

Free Neuroeducation course

icon-image--ANlFPVW1HaVZORlcxV__icon_zk7t3d-1

25 minutes

icon-image--AcWRyeEl4ZzBZUDRwY__icon_cKcHTw-1

On-line

icon-image--ARWNTdU02Q0U5RE14R__icon_R4QF8H-1

0 ECTS

$0
Logo institución
Free course in Inspirational Leadership
image-block-46865541300437

EUROINNOVA INTERNATIONAL ONLINE EDUCATION

Free course in Inspirational Leadership

icon-image--ANlFPVW1HaVZORlcxV__icon_zk7t3d-2

60 minutes

icon-image--AcWRyeEl4ZzBZUDRwY__icon_cKcHTw-2

On-line

icon-image--ARWNTdU02Q0U5RE14R__icon_R4QF8H-2

0 ECTS

$0
Logo institución
Free Psychopedagogy course
image-block-46862898626773

EUROINNOVA INTERNATIONAL ONLINE EDUCATION

Free Psychopedagogy course

icon-image--ANlFPVW1HaVZORlcxV__icon_zk7t3d-3

25 minutes

icon-image--AcWRyeEl4ZzBZUDRwY__icon_cKcHTw-3

On-line

icon-image--ARWNTdU02Q0U5RE14R__icon_R4QF8H-3

0 ECTS

$0
Logo institución
Free Sustainability and Social Responsibility Course: ESG Keys
image-block-46865535729877

EUROINNOVA INTERNATIONAL ONLINE EDUCATION

Free Sustainability and Social Responsibility Course: ESG Keys

icon-image--ANlFPVW1HaVZORlcxV__icon_zk7t3d-4

30 minutes

icon-image--AcWRyeEl4ZzBZUDRwY__icon_cKcHTw-4

On-line

icon-image--ARWNTdU02Q0U5RE14R__icon_R4QF8H-4

0 ECTS

$0
Logo institución