Online Training
Microsoft Excel 2019 Expert Course, VBA, Business Intelligence, KPI, DAX and Dashboards + University Degree
650 hours
5 ECTS
Spanish
Educational institutions


Request information
Online Training
650 hours
5 ECTS
Spanish
Educational institutions


Request information
Multilingual support
Digital certificate included
Assistant Phia
- 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.
IT, Programming, Offices, Teaching, Administration, Secretariat, Office automation.
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.