Udemy - Using Excel as a database with VBA torrent

Using Excel as a database with VBA
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz
Language: English | Size: 1.87 GB | Duration: 15h 18m
Connect Excel to external data using VBA and turn it into a database or application to manage data from different source
What you'll 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
Description
This course has been created to teach how to turn an Excel workbook into a Database application using VBA.

Before creating the database application in the first sections I explain the main VBA data structures which are helpful to manage data to be imported to Excel and to be exported from Excel ranges to external sources e.g. databases, web services , XML files, text files and JSON files.

In details, the course includes:

Overview of VBA. Very important for those that are starting off with VBA. In this section the students will know how to access and know the Excel Developer Ribbon. the VBA Editor, the concept of macro and the concept of macro security and will get acquainted with topics e.g. the workbook object, worksheet object, cells and ranges. You will learn how to record a VBA macro. You will understand the VBA Project structure and composition, the Worksheet Module Code, the Workbook and Worksheet Properties and Methods, the General variables and subroutines, concepts e.g. Variables and Constants (Public and Private Variables), Subroutines and Functions (Public and Private Subroutines and Functions), User Defined Functions, VBA and Worksheet Modules and Variable Types and Declarations.