Curso Macros Excel

Fully Online Course Excel Macros practical

Curso Macros Excel

Excel macros programming course

Make your own applications with Macros Excel

Practices in Macros Excel

Basic programming course in Excel free

In this video tutorial we will teach how to develop applications with Visual Basic. We will go step by step explaining in a practical way the development of desktop applications or better known as Macros Excel.

Detailed agenda:

Unit 1 Introduction to programming in Macros Excel

1.1 Objects, Properties and Methods

1.2 Object oriented programming

1.3 Data types

1.4 conditional structures

1.5 Logical operators

1.6 Check functions

1.7 repetitive structures

Unit 2 Practice 1: Validation of cells and task automation

2.1 Data income

2.2 Security and validation

Unit 3 Practice 2: Format and data sent

3.1 Automated cell format

3.2 Send information to other sheets

Unit 4 Practice 3: Information by form and security

4.1 Data income per form

4.2 Safety of ranges and cells

4.3 Safety of the leaves and the Excel book

Unit 5 Practice 4: Validation of fields in form and duplicate elements

5.1 Data validation per form

5.2 Validate if there are duplicate elements and delete them

Unit 6 Practice 5: Forms and reports

6.1 Form management (Textbox, Combobox, buttons and labels

Unit 7 Practice 6: Generation of reports in a new book

7.1 Automate the reports reports

Unit 8 Practice 7: Income of external information, validation and format

8.1 Income of information from external sources (TXT)

8.2 Income of information from external sources (web)

Unit 9 Practice 8: Reports, sent information and security of macros

9.1 Enter information to a TXT file

9.2 Show and ocular leaves according to the type of report

9.3 Macros Safety

Unit 10 Practice 9: Automatize graphics

10.1 generate bars graphs of the combined report

10.2 generate graphs of combined report lines

10.3 Generate combined graphics

What's new in the latest version 10.0