Martini M. Hands-on ChatGPT in Excel: Enhance Your Excel Workbooks with ChatGPT

Independently published, 2023. — 198 p.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 is 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 set 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 exercises 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 quite simple.To unlock all of these possibilities, you 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 handfulExcel functions to write prompts and work with completions.I am confident that you will be able to create your “AI-infused” Excel tools at the end of the book. The main precondition of this book is 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 in this book.