Summary of Macros Excel, Cap. 7 Selección de Hojas - Sheets @ADNDC @adanjp

00:00:00 - 00:25:00

In the tutorial section of this YouTube video titled "Macros Excel, Cap. 7 Selección de Hojas - Sheets @ADNDC @adanjp", the speaker Adam JP provides a detailed tutorial on how to select sheets within Excel. The tutorial begins with the basics of selecting cells and filas, followed by the selection of sheets in a workbook. The speaker demonstrates how to select a specific sheet using various techniques such as using the Active Cell function, the Select function, and the "saints" attribute or reserved word. The presenter emphasizes the importance of using macros to automate repetitive tasks such as selecting cells and sheets, and how variables can be used to further improve the user's experience. The video concludes with a reminder to check out the presenter's YouTube channel for more tutorials on macros in Excel and to follow them on social media platforms for updates.

• 00:00:00 In this section of a YouTube video titled "Macros Excel, Cap. 7 Selección de Hojas - Sheets @ADNDC @adanjp," the speaker, Adam JP, provides a tutorial on how to select sheets within Excel. The tutorial begins with the basics of selecting filas, columnas, and celda, and then moves on to the selection of sheets in a workbook. The tutorial includes selecting a sheet in workbook, selecting a sheet in the developer tab, selecting all sheets in the workbook, and selecting a sheet in a macro using variables or constants, among others.
• 00:05:00 In this section, the speaker continues explaining how to use macros, specifically how to select worksheets. They begin by stating that selection within a worksheet can be accomplished using either row and column labels or labels and numbers, depending on the user's preference. The speaker then demonstrates how to select a particular range of cells within a worksheet by typing a combination of A and B or inserting a space and tabulation into the selection, followed by typing the name of the variable being used. For example, the speaker uses the "HojaSeleccionada" variable to select the worksheet they desire, using the "ентре comillas" or "." notation depending on their preference. The speaker also notes that using variables allows for more flexibility in selecting worksheets, such as through the use of complex formulas or relationships within a given worksheet.
• 00:10:00 In this section of the video, the presenter explains how to select a specific range of cells using the "Selection of Sheets" macro. The presenter advises viewers to take into account certain values that are already established in the worksheet and to use those values to select specific cells. The presenter suggests using the "change the name" function to rename a sheet and then uses the "Select" property to select a specific range of cells. The presenter also explains how to use the "active set" function to copy and paste a value from one cell to another. The presenter concludes by emphasizing the importance of understanding the " Selection of Sheets" macro and its various components.
• 00:15:00 In this section of the YouTube video "Macros Excel, Cap. 7 Selección de Hojas - Sheets @ADNDC @adanjp", the host starts by demonstrating how to select a specific sheet using the Active Cell function. The host uses the word traveled and provides an example of how the Active Cell function can be used to select a sheet number based on cell content. The host then follows up by demonstrating how to select a range of cells using the Select function. The host also uses the Atributes feature to specify which range of cells should be selected and demonstrates how to use the Select function to select the range from the active cell to the last cell in the current row. Finally, the host shows how to use the Select function to select a specific sheet based on its sheet number,itable.
• 00:20:00 In this section, the speaker explains how to use Excel to select and manipulate data in different sheets. To select a range of cells in Excel, you must specify the coordinates of the first cell in the range, which is usually represented as the letter and number combination, starting from column 1. The speaker demonstrates how to do this by selecting a range of cells, then saving it and exiting to the original sheet, and finally specifying the active sheet to retrieve the data. The speaker also mentions using the "saints" attribute or reserved word to select a specific sheet in Excel.
• 00:25:00 In this section of the YouTube video titled "Macros Excel, Cap. 7 Selección de Hojas - Sheets @ADNDC @adanjp", the presenter discusses the process of selecting a specific sheet in Microsoft Excel using the "Select" feature. The presenter first explains that the video will not cover much on macros but will focus on the basics of Excel, which is important when starting to learn macros. The presenter then gives instructions on how to select a specific sheet in Excel, explaining how to use the "instruction" feature, coordinating a cell's location using parentheses, and how to check the selected sheet. The presenter then talks about the importance of using variables in macros and how these can help improve the user's experience when creating macros. Lastly, the presenter reminds the audience to check out the YouTube channel for more tutorials on macros in Excel, and to follow them on social media platforms for updates on new courses and tutorials.