ChatGPT: https://chat.openai.com/
Link to the excel sheet in this video: https://exceltutorial.net/wp-content/...
0:00 - Intro
1:04 - Get data from another sheet
2:47 - Convert Currency
4:15 - Sum formula
4:25 - Calculate totals by currency
5:47 - Other Ideas
In this video, I'll show you how to become an Excel master with the help of ChatGPT. You'll learn how to build complex formulas like a pro, giving you the skills you need to take your Excel skills to the next level. Whether you're a beginner or an experienced user, this video will provide you with the knowledge and techniques you need to master Excel's powerful formula features. I'll guide you through step-by-step instructions and provide you with helpful tips and tricks to make the most of Excel's formula capabilities. So, watch this video and start building complex formulas like a pro today!
In the video above we're getting ChatGPT to do Vlookups (simple ones and calculations based on them), unique, and sumifs. We're also going to do these across sheets.
Смотрите видео Build Complex Excel Formulas With ChatGPT! онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Excel Tutorial 26 Январь 2023, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 532 раз и оно понравилось 6 людям.