MELHORE 10x no EXCEL com CHATGPT 🚀

Como usar o Chat PT no Excel

In this video, the presenter demonstrates how to use the Chat PT tool in Excel to improve your skills in building formulas and creating algorithms in VBA. The first example shows how to create a formula that evaluates whether students have passed, failed or need an exam based on their grades. The second example shows how to create a formula that separates names from email addresses.

Creating a Pass/Fail/Exam Formula

• Use the Chat PT tool to create a formula that evaluates whether students have passed, failed or need an exam based on their grades.

• Check the syntax of the generated formula and correct any errors such as using commas instead of semicolons.

• Replace cell A1 with B2 since that is where the grade is located.

• Copy and paste the corrected formula for all students.

Separating Names from Email Addresses

• Use the Chat PT tool to create a formula that separates names from email addresses.

• Translate any English terms used in the generated formula into Portuguese using an online translator if necessary.

• Correct any errors in syntax or cell references such as replacing A1 with A2.

• Manually replace any missing parts of the formula before copying it for all email addresses.

Overall, this video provides useful examples of how to use Chat PT in Excel for various tasks.

Using VBA to Classify and Format Data in Excel

In this section, the speaker demonstrates how to use VBA to classify and format data in Excel.

Using VBA to Classify and Format Data

• The speaker explains that with VBA, it is possible to program commands for Excel to perform tasks automatically.

• The speaker requests that the chatbot create a code in VBA that will classify students based on their performance and color-code their cells accordingly.

• After generating the code, the speaker copies and pastes it into Excel. They note that one thing to watch out for is when the code is split between two locations.

• The speaker runs the code, which successfully classifies and formats the data according to their specifications.

Accessing VBA in Excel

• To access VBA in Excel, simply press Alt + F11. From there, you can create new modules or edit existing ones.

Conclusion

In this section, the speaker concludes by encouraging viewers to subscribe for more content related to Excel and other topics.

Final Thoughts

• The speaker thanks viewers for watching and encourages them to subscribe for more content related to Excel and other topics.