Getting the Most from Your Spreadsheets with GenAI

Overview

Artificial intelligence (AI) has rapidly become a phenomenon; a much-talked-about technological sea change. It's also a major disruptive force in the world of business. Generative AI tools can provide value in many ways, one of which is by assisting people who work with data stored in spreadsheets. No matter what spreadsheet software you use, what the data is about, or how it's structured, you can use freely available generative AI tools to enhance your productivity and help you find solutions to problems that can guide crucial business decisions. And, you can do all of this without having to pay for expensive AI integrations into your spreadsheet software. You just need to know what generative AI can do for you, what free tools to leverage, and the right questions to ask to get the most from your spreadsheets. This course is designed for professionals in a variety of roles who currently use spreadsheets to accomplish business tasks, and who want to enhance their use of spreadsheets by leveraging freely available generative AI tools. In this course, you will: select and use generative AI tools to generate spreadsheet content, use generative AI to enhance your productivity while working in spreadsheets, and use generative AI to solve spreadsheet-related problems. This course assumes the use of Microsoft Excel for spreadsheet-related tasks, but other spreadsheet programs like Google Sheets should be sufficient. You also need access to free accounts for major genAI services like ChatGPT and Gemini.

Syllabus

Using AI to Generate Spreadsheet Content

Recent innovations in artificial intelligence have resulted in tools that can generate a variety of content based on some input you provide. Whether you're a data analyst, salesperson, financial professional, or anyone else who uses spreadsheets in their day-to-day work, you may find these tools can solve task-related problems, impart key knowledge, or just make working with data much easier.

Enhancing Your Spreadsheet Productivity with GenAI

Now that you've learned the basics of generative AI and have had some initial practice with it, you can begin to explore more of its capabilities. In this lesson, you'll learn how to use generative AI to hone your spreadsheet skills and increase your productivity in applications like Microsoft® Excel® and Google Sheets™.

Solving Problems Using GenAI

You've used generative AI to address various needs in your spreadsheets, like using well-crafted formulas to reveal useful insights from your data. But, you'll also be in a position where you need to solve general business problems using your data, but you're not sure how to approach those solutions. In this lesson, you'll focus on using AI to solve problems it is effective at solving, while minimizing time spent on problems it struggles to solve.