Getting the Most from Your Spreadsheets with GenAI

This class is designed for people new to using AI tools, such as ChatGPT - Gemini - or Copilot, in the workplace. People with experience using these tools for their job functions may find some of the content covered to be beginner or overview level.

Description

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 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.

Course Objectives:

In this course, you will use generative AI to assist you as you work with spreadsheets. You will:

Select and use generative AI tools to generate spreadsheet content.
Use generative AI to enhance your productivity while working in spreadsheets.
Use generative AI to solve spreadsheet-related problems.

Target Student:

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.

Course Content

Lesson 1: Using AI to Generate Spreadsheet Content

Topic A: Generate Spreadsheet Content

Topic B: Using the Right GenAI Tool for the Job

Lesson 2: Enhancing Your Spreadsheet Productivity with GenAI

Topic A: Ask GenAI for Basic Help

Topic B: Ask GenAI for Help Performing Specific Tasks

Lesson 3: Solving Problems Using GenAI

Topic A: Identify Problem-Solving Limitations of GenAI

Topic B: Solve Problems Strategically Using GenAI

Similar courses

This is a mixed version class, appropriate for anyone using Excel 2016/2019/2021/2023, as well as Office 365 subscribers with automatic updates from Microsoft. Attention will be given to nuances between the program versions as applicable for the students in each class. For those using 2013 and earlier, please contact your Learning Consultant before enrolling in class.

More Information

Doing data analysis work is about more than learning a software program (Excel, Power BI, Tableau, etc.) - you need to understand the concepts and theory too. This one day course gets you up to speed (and can be useful either before or after your software classes).

More Information

Students registering for class will need to let Logical Operations know whether they are using Windows 10 or Windows 11.

More Information

Students registering for class will need to let Logical Operations know whether they are using Windows 10 or Windows 11.

More Information

No previous experience of Copilot required; however, the student will require an existing Copilot for Microsoft 365 license to participate in hands on exercises, as there is currently no trial license available to Microsoft partners for this product.

More Information

4 Half Day Sessions

More Information

This class is a follow-up to the more basic/entry level AI classes offered at Logical Operations. Students in this class should have prior experience in an AI course offered by Logical Operations. It is recommended that students have previously taken either one of our "How to Create and Use a Prompt" classes or one of our "Getting the Most out of your Spreadsheets/Documents/Presentations with GenAI" classes.

More Information