Business intelligence with Excel

Thumbnail

This course develops the knowledge and skills required to create practical and interactive dashboards (control panels) based on innovative techniques for using MS Excel. These tools will facilitate better and faster decision-making for your institution, business or company

Facilitator:
 J. Jesús Romero Lozano
Aimed at:

Managers; supervisors; executives; team leaders; financial, marketing and customer service executives; data analysts; people in charge of preparing reports; and anyone interested in contributing to information analysis in order to make more informed decisions about an area or process.
Duration:
 45 hours
Study plan:
  1. Introduction to dashboards.                                   
  2. Development of the data model.  
  3. Graphs - initial techniques.    
  4. Dashboard: Best practices.   
  5. Interactive graphs.     
  6. Automation tools.  
  7. Adding interactivity.
  8. Advanced graphs.     
  9. Extra skills.

Previous requirements:

  • Intermediate knowledge of MS Excel (minimum use of 8 hours a week). Experience in the use and development of formulas, dynamic tables, graphs and filters.
  • Laptop for every session.

Note: Knowledge or experience of Macros (VBA Visual Basic for Applications) is not required. Dashboards are generated through MS Excel tools and functions. The workshop has computers with Office MS Excel 2010 and 2013 for Windows. (We recommend the 2013 version).

Request more information
about this program

Download the enrollment
application here

 

  • Thumbnail

    Effective business management

    In this course participants develop the knowledge, skills and abilities needed to manage organizations effectively, through the design and implementation of strategies that generate high-value competitive advantages.

  • Thumbnail

    Basic finance

    Understand the importance of finance in organizations, and apply tools that will allow you to make decisions that lead to the optimization of financial resources and an increase in their value.

  • Thumbnail

    Basic programming

    Participants develop basic programming skills and knowledge that will enable them to enter more advanced programming courses in the future in order to create business applications on different platforms.