Aprende macros

Detailed agenda:


Unit 1 Introduction to Programming in Excel Macros

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 automation of tasks
2.1 Data entry

2.2 Security and validation

Unit 3 Practice 2: Formatting and Sending data

3.1 Automated cell formatting

3.2 Send information to other sheets


Unit 4 Practice 3: Information by Form and Security

4.1 Data entry by form

4.2 Range and cell security

4.3 Excel sheet and workbook security


Unit 5 Practice 4: Validation of Form Fields and Duplicate Elements

5.1 Data validation by form

5.2 Validate if there are duplicate elements and delete them



Unit 6 Practice 5: Forms and Reports


6.1 Management of forms (Textbox, Combobox, Buttons and Labels


Unit 7 Practice 6: Report generation in a new book

7.1 Automate report generation

Unit 8 Practice 7: Entry of External Information, Validation and Format

8.1 Entry of information from external sources (TXT)

8.2 Entry of information from external sources (Web)

Unit 9 Practice 8: Reports, Sending Information and Security of Macros

9.1 Enter information to a TXT file

9.2 Show and hide sheets according to the type of report

9.3 Macro security



Unit 10 Practice 9: Automate Graphs



10.1 Generate bar graphs from the combined report

10.2 Generate line charts from the combined report

10.3 Generate combo chart