Scribd
Upload
3 views1 page

Advanced Excel & VBA Training Course

This document describes the content of a training course on advanced Microsoft Excel and Visual Basic for Applications (VBA). The training will cover 20 topics ranging from an introduction to Excel, to advanced functions, to VBA programming, and will conclude with summary exercises and a final project.

Translated by

ScribdTranslations
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
3 views1 page

Advanced Excel & VBA Training Course

This document describes the content of a training course on advanced Microsoft Excel and Visual Basic for Applications (VBA). The training will cover 20 topics ranging from an introduction to Excel, to advanced functions, to VBA programming, and will conclude with summary exercises and a final project.

Translated by

ScribdTranslations
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

ADVANCED MICROSOFT EXCEL TRAINING & VISUAL BASIC FOR

APPLICATION (VBA)

TRAINING CONTENT
This training program will include detailed explanations through examples those who
The following major points are as follows. Find the detailed training program on
[Link]

1-General Introduction to the EXCEL software


2-Management of cells, columns, and rows
3-Simple formatting of spreadsheets
4-Management of tables
5-Conception and Management of Formulas
6-The usual Excel functions and their uses
7-Graphs on Excel
8-Advanced functions and their uses
9-Mise en forme conditionnelle avancée sur Excel
10- Protecting your data by securing it with an access code.
11- Layout of the contents of a wallet
12- General Introduction to Visual Basic Programming
13- Macro Recording and Code Analysis
14- Creation of Programs with and without User Form Interface
15- Creation of functions and adding them to Excel functions
16- Application creations to open your files, software, and pages
web directly via command buttons from a simple sheet
Excel
17- Creation of custom applications for pre-sizing
Structures with Excel and Visual Basic
18- Creation of custom dimensioning calculation applications
Structures with Excel and Visual Basic
19- Autres utilités de VBA avec (Autocad ) en dessinant automatiquement
the elements from a VBA program

20- Synthesis exercises and final project.

Formateur : KAREMBE Abdoulaye


Civil Engineer

You might also like