Aprende macros

Features Aprende macros

Detailed agenda: Unit 1 Introduction to Programming in Excel Macros 1.1 Objects, Properties and Methods1.2 Object Oriented Programming1.3 Data Types1.4 Conditional Structures1.5 Logical Operators1.6 Check Functions1.7 Repetitive structuresUnit 2 Practice 1: Validation of cells and automation of tasks2.1 Data entry2.2 Security and validationUnit 3 Practice 2: Formatting and Sending data3.1 Automated cell formatting3.2 Send information to other sheetsUnit 4 Practice 3: Information by Form and Security 4.1 Data entry by form4.2 Range and cell security4.3 Excel sheet and workbook securityUnit 5 Practice 4: Validation of Form Fields and Duplicate Elements 5.1 Data validation by form5.2 Validate if there are duplicate elements and delete themUnit 6 Practice 5: Forms and Reports 6.1 Management of forms (Textbox, Combobox, Buttons and LabelsUnit 7 Practice 6: Report generation in a new book 7.1 Automate report generationUnit 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 file9.2 Show and hide sheets according to the type of report9.3 Macro securityUnit 10 Practice 9: Automate Graphs 10.1 Generate bar graphs from the combined report10.2 Generate line charts from the combined report10.3 Generate combo chart