PRDV433: Course Map | Saylor Academy

© Saylor Academy 2010-2026 except as otherwise noted. Excluding course final exams, content authored by Saylor Academy is available under a Creative Commons Attribution 3.0 Unported license. Third-party materials are the copyright of their respective owners and shared under various licenses. See detailed licensing information. Saylor Academy®, Saylor.org®, and Harnessing Technology to Make Education Free® are trade names of the Constitution Foundation, a 501(c)(3) organization through which our educational activities are conducted.

Course Syllabus

Course Learning Outcomes

Course Map

Course Map

Course Introduction

Course Syllabus

Course Learning Outcomes

Course Map

Unit 1: Introduction to Generative AI in Excel

1.1. Overview of Generative AI Tools

1.2: Artificial Intelligence in Excel

1.3. Prompt Engineering Basics for Spreadsheet Tasks

1.4. Security, Privacy, and Ethical Use of Generative AI in Excel

Unit 2: Generating Formulas Using Generative AI

2.1: Generating Basic Excel Formulas

2.2: Writing Prompts for Advanced Formula Generation

2.3: Creating Complex Formulas

Unit 3: Data Analysis Using Generative AI

3.1: Cleaning and Extracting Data

3.2: Basic Data Analysis

3.3: Generating Visuals, Highlighting Trends, and Summarizing Data

Unit 4: Automating Excel with Generative AI

4.1: Introduction to Macros and VBA in Excel

4.2: Writing Basic Macros

4.3: Explaining and Optimizing VBA Code

4.4: Automating Routine Tasks

Certificate Final Exam

Course Feedback Survey