Curso Macros Excel

Features Curso Macros Excel

Detailed Agenda: Unit 1 Introduction to Programming Excel Macros 1.1 Objects, Properties and Methods1.2 Object Oriented Programming1.3 Data Types1.4 Conditionals1.5 Logical Operators1.6 Test Functions1.7 Repetitive StructuresUnit 2 Practice 1: Validation of cells and task automation2.1 Data Entry2.2 Security and ValidationUnit 3 Practice 2: Format and sending data3.1 Automated cell format3.2 Send information to other sheetsUnit 4 Practice 3: Form and Safety Information for 4.1 Entry form data4.2 Security and cell ranges4.3 Safety of the leaves and the Excel workbookUnit 5 Practice 4: Validation Form fields and duplicates 5.1 Data Validation by form5.2 Validate for duplicate items and deleteUnit 6 Lesson 5: Forms and Reports 6.1 Forms Management (Textbox, Combobox, Buttons and LabelsUnit 7 Practice 6: Generation of reports in a new book 7.1 Automate reports generationUnit 8 Lesson 7: Entering External Information, Validation and Formatting 8.1 Entry information from external sources (TXT)8.2 Entry information from external sources (Web)Unit 9 Practice 8: Reports, sending information and Macros Security            9.1 Log information to a TXT file9.2 Display and eye leaves depending on the type of reportSecurity 9.3 macrosUnit 10 Practice 9: Automate Graphics 10.1 Generate bar graphs combined report10.2 Generating line graphs combined reportGenerate graphic combined 10.3