Microsoft Excel 2019, VBA, Business Intelligence, KPI, DAX and Commanding + University Titulation Expert course + university degree

Institución Educativa
Mode Online
Duration 650 horas
Credits 5 ECTS
Languages Spanish
¥106,600
Pago en cuotas sin intereses Acceso para siempre para consultar tu curso

Request information

Reconocidos por
Acreditados por

Plan de estudios

Summary

The new financial scenarios and business projections require planning and control strategies that require proper treatment of the maximum possible amount of information. Companies are not only limited to graphics with the fundamental data to sustain their forecasts and projections, but also require a deeper analysis of the information, exposing as much as possible in reports and summary tables. One of the main tools that we can find in the market for the elaboration of these reports is Microsoft Excel 2019, where it goes beyond the basic notions and the surface treatment of the data. This is one of the most important office spreadsheet processors worldwide, having functionalities as useful as dynamic tables, macros from the VBA programming language or Businessintelligence tools such as PowerPivot or Power View.

Goals

- Offer the student the necessary knowledge in spreadsheets to perform the most advanced operations of Microsoft Excel, making special emphasis on the recording of Macros with VBA and the application of Excel in Business Intelligence. - Work, analyze and use tables and data lists. - Know and handle databases, graphics, diagrams, logical functions and other basic tools. - Learn to apply the most advanced functions of Excel. - Learn to write macros from the VBA programming language in Excel. - Have the necessary VBA programming foundations for its correct application in Excel. - Know how to take advantage of Excel tools for the development of Businessintelligence strategies. - Know the operation of advanced Businessintelligence tools in Excel such as PowerPivot, Dax Expressions Language, Power View, Powerquery or PowerMaps. - Detect and create the KPI of a business project and capture them in a comprehensive control picture through PowerPivot.

Professional exits

Computer science, programming, offices, teaching, administration, secretariat, office.

To prepare you

This training program aims to provide students with specific and deep knowledge of Microsoft Excel, offering them the possibility of customizing the application to the needs of any organization. The course begins by raising basic functionalities such as the recording of Office Macros but continues to write Macros from the VBA programming language (Visual Basic for applications). 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 the data in a more intuitive, simple and simple way.

Who is it addressed

Aimed at all those professionals in any business sector who wish to dominate Microsoft Excel for the elaboration of data analysis and issuance of any kind (financial, accounting, analytical, sales, etc.). It also addresses students who want to deepen the knowledge of the most advanced tools of Microsoft Excel 2019 and in their application for the design of business systems.

Methodology

Our methodology combines technology, pedagogy and empathy for a tailored learning.

You mark the rhythm, you decide the way and an artificial intelligence accompanies you to learn better, with meaning and purpose.

Realized personalized learning

Your style, interest and level define the route. You are the starting point.

Constructivism in action

Explore, experience and apply. Learning means understanding, not memorizing.

He who accompanies you, not who directs you

Phia, our artificial intelligence assistant guides you without limiting your autonomy.

Evaluation without pressure

Continuous and adaptive feedback. Because learning is a process, not a figure.

Certificación

Logo certificado-1
Logo certificado-2

Double degree: - Degree of expert at Microsoft Excel 2019, VBA, Business Intelligence, KPI, DAX and command cadres with issued by Euroinnova International Online Education, member of the AEEN (Spanish Association of Business Schools) and recognized with the academic excellence in online education by QS World University Rankings - University degree in Advanced Excel 2019 ECTS.

Logo certificado-1 Logo certificado-2

Scholarships

EDUCAHUB Scholarships

Make your most accessible training: Finish 0% interest and get personalized scholarships.

In Eduahub we believe that education must be available to everyone. Therefore, we offer a scholarship plan that facilitates your access to practical, current and quality training, eliminating economic barriers.

-25%

Alumni Scholarship: For former students of Eduahub.

-20%

Unemployment scholarship: if you prove to be unemployed.

-20%

Numerous family scholarship: for families with 3 or more children.

-20%

Disability scholarship: For people with disabilities ≥33%.

-15%

Emprende Scholarship: For self -employed that accredit your activity.

-15%

Scholarship recommends: If you come recommended by an alumnus.

-15%

Group scholarship: For joint inscriptions of 3 or more people.

An entire educational universe, on a single platform.

An intuitive environment that guides you to form autonomously and with purpose.

Know more

Learn at your pace

Courses, masters and official degrees. 100% online, flexible and at your pace.

Access from anywhere

Available 24/7 on mobile, tablet or PC. You decide when and how to train.

Phia, your mentor ia

It challenges you, motivates you and customizes your path. Learn with a guide that evolves with you.

LX One Plus: Without limit formation

Unlock soft skills, languages and more. Advances towards integral and continuous formation.