Translated by Google
Introduction to programming applications in VBA (Excel)
From 31.26 £ /h
Microsoft Office applications contain a development environment which allows the operation of these applications to be adapted to the concrete needs of its users.
I offer you an introduction to programming in Visual Basic for Applications, in order to allow you to get started with macros and the interaction that you can bring to your Excel files.
On the menu :
* Editor interface
* Macro recording
* Analysis of the code generated by the macro recorder
* Programming basics: types of variables, execution flow control instructions and common functions
* Preview of the Excel object model
I offer you an introduction to programming in Visual Basic for Applications, in order to allow you to get started with macros and the interaction that you can bring to your Excel files.
On the menu :
* Editor interface
* Macro recording
* Analysis of the code generated by the macro recorder
* Programming basics: types of variables, execution flow control instructions and common functions
* Preview of the Excel object model
Extra information
You must have an official version of Microsoft Excel software (minimum version 2016)
Location
Online from Belgium
About Me
Computer scientist (more precisely: analyst-programmer) since the last century (it's been old, I know), I turned to teaching a few years ago now.
I am now an office automation trainer (Word, Excel, Access, Outlook, Powerpoint, VBA) and a programming teacher (all languages: it is the substantive core that is taken from it)
I am now an office automation trainer (Word, Excel, Access, Outlook, Powerpoint, VBA) and a programming teacher (all languages: it is the substantive core that is taken from it)
Education
Graduate in IT management - Business School of Namur
Certificate of Educational Aptitudes - Technical Institute of Namur (Social Promotion)
Certificate of Educational Aptitudes - Technical Institute of Namur (Social Promotion)
Experience / Qualifications
Computer scientist (analyst-programmer) since 1998:
* Family Allowance Fund (application management + XML exchanges with social security)
* UCM Social Secretariat: management of exchanges with the ONSS; Business Intelligence with SAS
Teacher since September 2020:
* ITN Promotion Sociale (technopedagogue - office automation)
* Business Administration School - SPW (office automation - programming)
* IEPSCF - Namur Cadets (office automation teacher)
* Family Allowance Fund (application management + XML exchanges with social security)
* UCM Social Secretariat: management of exchanges with the ONSS; Business Intelligence with SAS
Teacher since September 2020:
* ITN Promotion Sociale (technopedagogue - office automation)
* Business Administration School - SPW (office automation - programming)
* IEPSCF - Namur Cadets (office automation teacher)
Age
Teenagers (13-17 years old)
Adults (18-64 years old)
Seniors (65+ years old)
Student level
Beginner
Duration
60 minutes
The class is taught in
French
English
Dutch
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
Starting from your needs (school work such as TFE, dissertations or institutional to hand in), I will accompany you, step by step, to allow you to take in hand and improve your use of the Microsoft Word software:
* Layout, character and paragraph formatting;
* Insertion of tables, images, SmartArt or other objects;
* Management of layouts, sections and table of contents;
* Management of styles, advanced editing elements;
* Direct mail;
* Creation of macros, text blocks, forms;
(non-exhaustive list)
* Layout, character and paragraph formatting;
* Insertion of tables, images, SmartArt or other objects;
* Management of layouts, sections and table of contents;
* Management of styles, advanced editing elements;
* Direct mail;
* Creation of macros, text blocks, forms;
(non-exhaustive list)
Good-fit Instructor Guarantee