BOOKS - Hands-on ChatGPT in Excel: Enhance Your Excel Workbooks with ChatGPT
US $6.82
96144
96144
Hands-on ChatGPT in Excel: Enhance Your Excel Workbooks with ChatGPT
Author: Mitja Martini
Year: December 11, 2023
Format: PDF
File size: PDF 38 MB
Language: English
Year: December 11, 2023
Format: PDF
File size: PDF 38 MB
Language: English
With the new LABS.GENERATIVEAI function from Microsoft's Excel Labs add-in, you now can create ai-infused tools with ChatGPT right within Excel. This book will teach you how to do it - no programming knowledge required. The book goes step-by-step from data in Excel to basic prompting in ChatGPT to making use of the generated text in Excel. It also provides examples of advanced prompt engineering techniques for Excel. In this book you will how to setup everything to start with prompting ChatGPT from Excel,how to use Excel functions to create good ChatGPT prompts,how to prompt ChatGPT to generate data that you can use in Excel formulas,how to create Excel functions to make use of the ChatGPT generations,how to add logic to your prompt flows in Excel,how to leverage advanced prompting techniques in Excel, andwhat you need to consider to create safe and responsible AI solutions.When you will do the labs and excercises in the book you will certainly realize that there are endless possibilities. Here are some examples of what you can do when you combine ChatGPT with Excel.generate creative content with guardrails you define in Excelextract or summarize information from data - this is like flash fill powered by ChatGPTclassify information according to defined criteriaanswer questions about data in your Excel workbookanalyze the sentiment of a textIn this book you will learn everything you need to know to start developing prompt flows in Excel. If you think this is complicated, let me convince you that it is actually quite simple. To unlock all of these possibilities, you basically just need to know how touse the new LABS.GENERATIVEAI function,prompt ChatGPT to get results you can work with in Excel, anduse a hand full of other Excel functions to write prompts and work with completions.I am confident that you will be able to create your own "AI-infused" Excel tools at the end of the book. The main precondition of this book are foundational to mid-level Excel skills. Just by reading the book you can probably already gain the knowledge you need to go. However, to make the most out of this book, you should do the labs and play with the examples that are provided with this book.If you want to learn how to create your own "ai-infused" tools with ChatGPT and Excel, this book is for you! To my knowledge it is the first book of it's kind.