objective

Develops extraordinary skills in the use of Microsoft Excel, Access and VBA for the solution of problems of great magnitude and complexity in businesses that require the integration of spreadsheets, databases and automation.


Benefits of the program

  • You will learn a working methodology in Excel and VBA effective, efficient, orderly and automatable.
  • • you will turn on automatically updating data and Excel charts in PowerPoint presentations.
  • You will know the Structured Query Language (SQL) and its functions.
  • You will be able to automate a large part of the operations that can be carried out in spreadsheets through macros in VBA.
  • You will develop graphic interface applications with a programming language oriented to objects and events.
  • You will create customized functions in VBA that will allow you to perform calculations specific to your specialty in a fast and orderly manner.


Addressed to

Graduates in administration, internal audit, accounting, finance, investments, planning, valuation, treasury and sales administration; commercial, brand and product management; personnel from the areas of market intelligence and business, marketing, budgeting and trade marketing.


Content of the program

The seminar in Excel Business consists of a module, which totals 40 hours of study in total.

Module 1. Excel Business (40 hours)

  • Tips for the agile handling of Excel.
  • Advanced functions
  • Dynamic table (Pivot Table).
  • Scenario analysis and sensitivity (Data Table).
  • Optimization (Goal Seek and Solver).
  • Automation of reports.
  • Introduction to the Visual Basic for Applications interface.
  • Macro recorder
  • Macros.
  • Introduction to object-oriented programming and events.
  • Objects, methods and basic properties.
  • Identifiers, constants and data variables and operators.
  • Control structures.
  • Standard controls.
  • Data Arrangements and Matrix Operations.
  • Microsoft Office objects.
  • Introduction to databases.
  • Connection and Microsoft Access objects.
  • Connection of dynamic tables from Excel to Access.
  • Structured Query Language (SQL) Basic.
  • Integrator Exercise: Development of a complete and automated system.
  • Automation of reports strategies.
  • Practical cases.
Program taught in:
Spanish

See 129 more programs offered by Tecnológico de Monterrey (Educación Continua Presencial) »

Last updated October 28, 2018
This course is Campus based
Start Date
Request Info
June 29, 2019
Duration
40 
Part-time
Full-time
Price
19,400 MXN
Deadline
By locations
By date
Start Date
End Date
Application deadline
Start Date
June 29, 2019
End Date
Application deadline
Start Date
End Date
Application deadline
Start Date
End Date
Application deadline
Start Date
End Date
Application deadline
Start Date
End Date
Application deadline
Start Date
End Date
Application deadline
Start Date
End Date
Application deadline
Location
Application deadline
End Date
Location
Application deadline
End Date
Location
Application deadline
End Date
Location
Application deadline
End Date
Location
Application deadline
End Date
Location
Application deadline
End Date
Location
Application deadline
End Date

June 29, 2019

Location
Application deadline
End Date