Translated by Google
VBA (Visual Basic for Application) - Excel, Access, SQL
From 43.32 C$ /h
First part, introduction to algorithms, up to a desired level for data management
Second part, application of algorithmic notions for vba applications and to acquire habits to face any situation and be autonomous in language without having to use objects. In this part, parallels can be made with other functional languages where programming languages are applied in a similar way (Python, PHP, Javascript ...)
Third part, introduction to the Excel data model (Collections, Objects, Methods). For this part, we forget the algos and we use the objects which reduce the number of lines of code. In this part, we will also discuss the macro recorder which can be very useful for this part.
Fourth part, approach an advanced level to manage files (create, modify, extract information), access databases ...
Second part, application of algorithmic notions for vba applications and to acquire habits to face any situation and be autonomous in language without having to use objects. In this part, parallels can be made with other functional languages where programming languages are applied in a similar way (Python, PHP, Javascript ...)
Third part, introduction to the Excel data model (Collections, Objects, Methods). For this part, we forget the algos and we use the objects which reduce the number of lines of code. In this part, we will also discuss the macro recorder which can be very useful for this part.
Fourth part, approach an advanced level to manage files (create, modify, extract information), access databases ...
Location
At student's location :
- Around Antony, France
Online from France
About Me
Experience of more than 10 years in automation on Excel spreadsheet, in multinationals, SMEs in France and England
I also had to work remotely as a freelance for various interlocutors in various countries.
I also had to work remotely as a freelance for various interlocutors in various countries.
Education
DCG (Diploma in Accounting and Management) obtained at CNAM-INTEC between 2003 and 2008
License and Masters in business management at the University of Paris 12 in 2002.
BTS in international trade
License and Masters in business management at the University of Paris 12 in 2002.
BTS in international trade
Experience / Qualifications
Accounting and accounting management (good notions in business accounting and transversal matters (logistics, payroll ...)
Age
Teenagers (13-17 years old)
Adults (18-64 years old)
Seniors (65+ years old)
Student level
Beginner
Intermediate
Duration
60 minutes
90 minutes
The class is taught in
French
English
Skills
Availability of a typical week
(GMT -05:00)
New York
Mon
Tue
Wed
Thu
Fri
Sat
Sun
00-04
04-08
08-12
12-16
16-20
20-24
Good-fit Instructor Guarantee











