Hands-on ChatGPT in Excel

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 learn 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, and what 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 Excel extract or summarize information from data - this is like flash fill powered by ChatGPT classify information according to defined criteria answer questions about data in your Excel workbook analyze the sentiment of a text In 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 to use the new LABS.GENERATIVEAI function, prompt ChatGPT to get results you can work with in Excel, and use 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.