Summary of 12 Trucos que debes SABER SI O SI, si haces FÓRMULAS en EXCEL.

00:00:00 - 00:20:00

The video discusses tips for creating efficient formulas in Excel. The tips include organizing the formula correctly, using the tab key to write the function name in one column and the input values in another column, duplicating the formula in the same column, and using the fill and clear features. The final tip is to use the find feature to locate a specific cell.

• 00:00:00 The video discusses tips for Excel formulas that if followed, will result in easier and more efficient formulas. The first tip is to organize the formula correctly so that it is easier to read. The second tip is to use the tab key to write the name of the function in one column, and the input values in another column. The third tip is to use the "duplicate" feature in the cell to duplicate the formula in the same column, and then edit the copy. The fourth tip is to use the "fill" feature to fill in the values in a cell. The fifth tip is to use the "clear" feature to clear the cells in a worksheet. The final tip is to use the "find" feature to find a specific cell.
• 00:05:00 The video explains how to identify an error in a formula by looking for references that are not coloring in according to expected colors. For example, if a reference is not blue, it may be an error. Once the error is found, it is easy to fix by replacing the incorrect reference with a valid one.
• 00:10:00 In this video, 12 tricks for Excel formulas are shown. Some of these tricks are how to change a reference's movement, how to fix a reference, and how to make a reference stay in the same column. Finally, one trick to remember is to make a reference stay in the same row.
• 00:15:00 In this video, the presenter demonstrates how to assign a name to a cell in Excel. First, he looks for a column with a numeric value that he needs to assign a name to. Next, he selects the entire row and the column, and clicks the "Refresh" button. This refreshes the worksheet and updates the name in the selected cell.
• 00:20:00 These 12 tips will help you excel in Excel formulas. Internet is required to access the help for this function, which includes videos of exercises to help you learn the individual steps. I hope you've enjoyed these tips, and that they've helped you learn more effectively. Subscribe to my channel to stay up-to-date on my tips, and let's see how we can achieve success together!