Using Excel as a database with VBA

Connect Excel to external data using VBA and turn it into a database or application to manage data from different source

Created by: Dan Prodi
Project Manager and Software Architect

Created by: Pipi Rahayu
Instructor ar Udemy

What Will I Learn?

• use VBA to manage Excel table
• connect Excel with databases using VBA
• use VBA dictionaries to manage data
• manage complex Pivot tables using VBA in Excel
• turn Excel into a database and application

Requirements

• Basic knowledge of PC Windows and/or MAC
• Basic knowledge of Microsoft Excel
• Basic knowledge of VBA macros

Target audience

• who has to manage data in Excel
• who needs to make data analysis with Excel
• who wants to use VBA to manipulate Excel tables
• who wants to use VBA to use dictionaries as data structure
• who wants to connect Excel with external data
• who needs to manage pivot tables with VBA