
AI is transforming how we work—and our students need to be ready to use AI in their future careers. As educators, we have a responsibility to help them understand how to use tools like ChatGPT responsibly and effectively. That means helping them see AI not as a shortcut or cheating aid, but as a tool that improves efficiency and enhances analysis.
Tracie Miller and I chose Excel as the foundation for teaching AI because most students already have a basic comfort level with it, which makes learning AI concepts more accessible. That familiarity makes it easier to focus on how AI can enhance what they’re doing—whether that’s generating complex formulas, cleaning data, or analyzing trends.
To help faculty integrate AI into their classes, we have created a set of free resources that includes:
- 24 step-by-step tutorial videos showing how to use Excel’s built-in AI features or how to use ChatGPT to leverage use of Excel
- Assignments for each tutorial, including both hands-on exercises and conceptual essay questions
- Multiple-choice questions
- Teaching tips, suggested solutions, and classroom activities like a Kahoot! quiz, crossword, and word search
For example, one of the tutorials included in the free resource package focuses on Excel’s built-in dynamic array formulas. Students are guided step by step through functions like SEQUENCE, UNIQUE, TEXTSPLIT, and TRANSPOSE—all of which allow a single formula to return multiple results that “spill” across rows or columns. The tutorial helps students understand how these formulas work, when to use them, and how AI features in Excel can make data tasks faster and smarter. It’s hands-on and gives students immediate opportunities to apply what they’ve learned in related Excel exercises.
All these materials are designed to make it easy to bring AI into your accounting course in a practical, structured way—whether you’re teaching Excel, accounting, analytics, or any business-related course.
Want access to all the tutorials, assignments, and the full instructor guide?
Click here to request the full AI+Excel resource instructor guide
The request form is quick – please use your school email address. Also – check your spam folder. We send out the instructor guide about once a week and a lot of times it goes to spam – so check your spam folder.
We hope you find the tutorials and related resources helpful.
Have a great day!
Wendy Tietz