Summary of Macros Excel, Cap. 13 Relación de facturas. Práctica final 3/3 @ADNDC @adanjp

00:00:00 - 00:40:00

In this video tutorial, the instructor provides a comprehensive overview of the final chapter of their Excel macros course, focusing on the relationship between invoices. They guide viewers on how to access the developer tab in Excel and explain the steps involved in capturing user input and calculating values based on that input. The video addresses formatting issues, calculating taxes, and demonstrates how to execute the macro for inputting invoice data. The importance of copying formulas and creating a "Continuar" section to continue inputting invoices without re-executing the macro is also discussed. The video ends with the instructor encouraging viewers to practice and customize the system and expressing their appreciation for those who have completed the course.

• 00:00:00 In this section, the video tutorial introduces the final chapter of their Excel macros course, which focuses on the relationship between invoices. The instructor guides viewers on how to open Excel and access the developer tab in versions 2010 and 2013. They explain the different sections within the visual basic panel and discuss the steps involved in capturing user input and calculating values based on that input. They also address an issue that occurred in a previous tutorial where all the data was cleared when an incorrect invoice number was entered. Overall, this section provides a comprehensive overview of the final exercise in the course.
• 00:05:00 In this section of the video, the speaker explains how to format numbers and percentages in Excel. They demonstrate how to change the format to accounting or currency, and how to add decimal places. The speaker also addresses a previous issue with formatting cells that was caused by an error in the data. They then proceed to explain how to calculate the VAT (value-added tax) and the IRPF (personal income tax) using formulas. Finally, the speaker demonstrates how to execute the macro to input invoice data, but mentions that the macro does not copy the formulas, and suggests adding an instruction to allow for continuing to input invoices without re-executing the macro.
• 00:10:00 In this section, the video discusses the creation of a "Continuar" (Continue) section in the Excel macro. This section prompts the user to decide whether they want to enter more invoices or not. If the user chooses to continue, the macro copies the formulas from the previous section to ensure their functionality. The video also explains the variables and parameters needed to create the decision message box, such as the message, style, and title. The importance of copying the formulas before receiving the user's response is emphasized to avoid losing the formulas if the macro continues without copying them.
• 00:15:00 In this section, the instructor explains how to position the cursor and select a range of cells in Excel. The procedure involves copying and pasting instructions, as well as using the "selection" and "copy" functions to copy formulas and values. The instructor also demonstrates how to define a range of cells and specify where to paste the copied data.
• 00:20:00 In this section of the video, the speaker explains how to use macros in Excel to create a relationship between invoices. They begin by naming the active row and column, and then select the range of cells based on the active row. They then use the "paste" function to copy and paste the formulas from the cells above to the cells below. The speaker also discusses the option of adding more invoices and explains that if the user chooses to do so, the macro will return to the beginning and execute again. Finally, they mention that the macro can be tested by clicking on the "play" button.
• 00:25:00 In this section, the YouTuber explains how a macro in Excel is being used to input invoice data. The macro selects a range, prompts for invoice details such as the invoice number, date, supplier, base amount, and tax rates. It then proceeds to enter the information and verify if the data is correct. If the user chooses to continue entering more invoices, the macro copies the previous data and pastes it, allowing for easy input of multiple invoices. The video also addresses an error in the code and demonstrates how to create an ending section that automatically closes the dialog box.
• 00:30:00 In this section, the user is instructed on how to create a button that will allow users to input invoices without having to see the underlying code. The button is created using Excel's form controls and linked to the macro that has been created. The user is also shown how to save the macros properly so that they are included when the file is shared with others. The importance of enabling macros for the file to function properly is also highlighted. Overall, this section focuses on making the input of invoices user-friendly and accessible to non-programmers.
• 00:35:00 In this section, the speaker demonstrates how to enter invoice details using the macro in Excel. They input the invoice number, date, supplier name, invoice amount, and the types of taxes, such as VAT and IRPF. The system verifies the entered information, and if correct, allows the user to enter more invoices. The speaker encourages viewers to practice and customize the system to include features like a company logo and a more visual interface. They also mention that the next season of tutorials will cover more complex topics, but assure viewers that if they understood the basics, they will find it easy. The speaker extends their appreciation to those who have completed the first season of tutorials and announces the start date for the next season, along with a gift for the viewers who have reached this point. They ask for feedback on the course and express their pride in sharing knowledge freely.
• 00:40:00 In this section, the speaker expresses their gratitude to the viewers who watched the video until the end and states that they deserve to have access to the files and knowledge shared. They discourage sharing the files with the rest of the world, as they believe only those who have a thirst for learning deserve it. The speaker also invites viewers to subscribe to their channel and follow them on various social media platforms to stay updated on future courses and content.