# AI for Excel Course Online Canonical URL: ## Overview This course shows experienced Excel users how to use artificial intelligence to dramatically cut down the time spent on repetitive, tedious spreadsheet tasks. You will learn to use AI tools including ChatGPT, Claude, and Microsoft Copilot as intelligent assistants for formula creation, data cleaning, analysis, and automation. Through hands-on demonstrations and practical exercises, you will discover how to prompt AI effectively to generate complex formulas you would otherwise spend hours researching, clean messy datasets in minutes rather than days, create VBA macros without writing code from scratch, and transform raw data into actionable insights faster than ever before. Whether you are a Financial Analyst managing monthly reports, an HR professional overseeing employee data, or a Project Manager tracking complex schedules, this course will show you how AI can become your most powerful Excel productivity partner. ## What you'll learn - Develop effective AI prompts to produce accurate Excel formulas, including complex nested functions that would otherwise take hours to research or troubleshoot - Use AI to automate time consuming data cleaning tasks such as standardizing formats, merging or splitting text, removing duplicates, and correcting inconsistencies - Utilize AI assistants to decode existing formulas, resolve errors, and identify optimizations for slow performing spreadsheets - Apply AI to speed up data analysis, from generating insights and building visualizations to producing VBA macros for repetitive workflows ## Prerequisites Attendees must have beginner Excel skills equivalent to our Excel Fundamentals course, including basic functions and formulas, printing, formatting, basic charts, and tables. ## Curriculum #### Module 1: AI Fundamentals for Excel Users - Understand what AI can (and cannot) do for your Excel work - Overview of AI tools: ChatGPT, Claude, Microsoft Copilot, and others - How AI "thinks" about spreadsheets—and why that matters for getting good results - Setting realistic expectations: AI as assistant, not replacement - Security and data privacy considerations when using AI with sensitive data #### Module 2: Mastering AI Prompts for Formula Generation - The anatomy of an effective Excel prompt: context, examples, and constraints - Generating simple to complex formulas on demand (VLOOKUP, INDEX-MATCH, nested IFs, array formulas) - Prompt techniques for dynamic formulas that adapt to your data - Troubleshooting formulas with AI: explaining errors and suggesting fixes - Hands-on practice: Building a prompt library for your most common formula needs #### Module 3: Automating Data Cleaning with AI - Identifying data cleaning tasks AI handles best - Prompting AI to standardize inconsistent data (dates, names, addresses, phone numbers) - Using AI to generate formulas for splitting and combining text - Detecting and handling duplicates, outliers, and missing values - Hands-on practice: Cleaning a messy real-world dataset using AI-generated solutions #### Module 4: AI-Assisted Data Analysis and Insights - Asking AI the right questions about your data - Generating summary statistics and identifying trends with AI guidance - Using AI to suggest appropriate chart types and visualization approaches - Creating data narratives: Having AI help explain what the numbers mean - Hands-on practice: Analyzing a dataset and generating insights with AI assistance #### Module 5: VBA and Macro Generation with AI - When automation makes sense: Identifying repetitive workflows to streamline - Prompting AI to write VBA macros for common tasks (formatting, reporting, data manipulation) - Understanding and modifying AI-generated code (even if you're not a programmer) - Testing, debugging, and refining macros with AI support - Hands-on practice: Creating a macro to automate a repetitive reporting task #### Module 6: Building Your AI-Enhanced Excel Workflow - Integrating AI into your daily Excel routine without disrupting productivity - Creating a personal prompt library for recurring tasks - When to use AI vs. when to do it yourself: A practical decision framework - Keeping up with rapidly evolving AI capabilities - Developing an action plan for continued AI skill-building ## Instructors ### Reid Johnson — Instructor Reid isn't just someone who knows CAD and BIM; he's a licensed architect and contractor who deeply integrates these technologies into every facet of his career. His hands-on experience as a practitioner building real-world projects provides him with an invaluable understanding of how BIM and CAD streamline workflows and enhance design. This practical foundation led him to Autodesk, where he shared his expertise, helping others effectively leverage these powerful tools. Throughout his professional journey, Reid also dedicates himself to education, consistently teaching university courses and shaping the next generation of design professionals by equipping them with essential CAD skills. His unique blend of practical experience, industry knowledge gained at Autodesk, and passion for teaching positions Reid as a true specialist in BIM and CAD technology, capable of bridging the gap between theory and real-world application. **Credentials:** - Autodesk Fusion Certified User - Autodesk Revit Certified Professional - Autodesk Certified Instructor - Licensed Architect - Licensed General Contractor ### David Nguyen — Instructor David is the AEC Software Specialist at VDCI, with a Bachelor of Science in Construction Management and an Associate’s degree of science in Drafting and General Design from ITT Technical Institute. A San Diego native with over 12 years working in the Design Industry and construction industry, David brings his construction and design expertise to help all students achieve their goals in the field. Outside of his professional life, David loves attending concerts, festivals, playing his guitar and restoring and repairing all types of vehicles. **Credentials:** - OSHA 30 hr. Construction Safety Certified - Construction Software: SketchUp, Bluebeam Revu, Autodesk Suite (AutoCAD, Fusion, REVIT) - Mechanical Software: PTC CREO Parametric, Solidworks, MasterCAM ## Pricing **Tuition:** $649