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

Name: Microsoft Excel 2019 Expert Course, VBA, Business Intelligence, KPI, DAX and Dashboards + University Degree en Perú
Brand: EUROINNOVA INTERNATIONAL ONLINE EDUCATION
SKU: 279136-2503
Availability: InStock

icon-image--AbjlOSDZzVEJNY0s3S__icon_7yVPEV

650 hours

icon-image--AcnI1bkFZTjZZaTE3U__icon_xJgfxr

5 ECTS

icon-image--AWUI0N2tWMzVrNzMzT__icon_DgE8xz

Spanish

The new financial scenarios and business projections require planning and control strategies that require correct treatment of the maximum amount of information possible. Companies are no longer limited to making graphs with the fundamental data to support their forecasts and projections, but require a more in-depth analysis of the information, capturing as much as possible in reports and summary tables. One of the main tools that we can find on the market for preparing these reports is Microsoft Excel 2019, which goes beyond the basic notions and superficial treatment of the data. It is one of the most important office spreadsheet processors in the world, providing useful functionalities such as dynamic tables, macros from the VBA programming language or business intelligence tools such as PowerPivot or Power View.

Instituciones educativas

S/. 2,422

Request information

I'm interested I'm interested

I'm interested

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.

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.

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.