AI Prompts for Coding & Technical Tasks

In this lesson, you'll learn how to use Google Sheets' ARRAYFORMULA function with AI assistance to automate data processing across entire columns. You'll learn how to create effective prompts that let AI turn your business logic into Sheets formulas.

This lesson teaches you how to use the AI assistant Claude to decipher, analyze, and fix complex or error-prone Excel formulas. You'll learn how to create effective prompts for problem diagnosis and how to improve Claude's responses through an iterative approach.

This lesson is designed for non-programmers to learn how to use ChatGPT to create Python scripts for data cleaning. You'll learn how to describe your requirements precisely, specify constraints, and get practical, usable code from AI.

This lesson introduces you to ChatGPT Code Interpreter, a powerful tool that lets you analyze data files (such as CSV) without any programming knowledge. You'll learn how to write effective prompts to ask business questions and how to use an iterative approach to get the best results.

In this lesson, you'll learn how to use ChatGPT to generate SQL SELECT queries, even if you don't know SQL syntax. The focus will be on crafting precise and detailed prompts that allow the AI to turn natural language into effective database queries.

In this lesson, you'll learn how to use Claude AI to create SQL JOIN queries, even if you're not a programmer. You'll learn how to combine data from multiple tables and get accurate, explained results.

In this lesson, you'll learn how to use ChatGPT to create Regex (regular expressions), even without programming knowledge. You'll learn how to precisely describe the text patterns you want to the AI, and how to use the resulting Regex for data search, cleanup, and anonymization.

In this lesson, you'll learn how to use ChatGPT Code Interpreter to convert JSON files to CSV format, without any programming knowledge. You'll learn how to describe your business requirements to AI in plain language and get accurate data in the structure you want.

In this lesson, you'll learn how to use Claude AI to automatically draft technical documentation. You'll learn why it's important to define the audience and format in your prompt, and how to get accurate, usable results through an iterative approach.

In this lesson, you'll learn how to use ChatGPT to efficiently generate links with UTM parameters. You'll learn why UTM parameters are critically important for marketing campaign analytics, and how to create a precise prompt so the AI maintains naming conventions and avoids errors.

In this lesson, you'll learn how to use Claude AI to create small HTML/CSS blocks without any programming knowledge. You'll learn how to write precise and detailed prompts to get functional and editable web fragments for your projects.

In this lesson, you'll learn how to use ChatGPT to automate Google Apps Script tasks, without any programming knowledge. You'll learn how to write an effective prompt that has the AI turn your business logic into a script, and how to refine the resulting output.

In this lesson, you'll learn how to use ChatGPT Code Interpreter not only to generate data, but also to check the accuracy and logic of existing charts. You'll learn the principles of creating effective prompts that let the AI perform a critical analysis and provide you with reliable feedback.

In this lesson, you'll learn how to use Claude AI to generate QA test cases for quality-assuring technical solutions (formulas, scripts). You'll learn the principles of creating effective prompts and the importance of iterative refinement to obtain reliable, practically usable test tables.

In this lesson, you'll learn how to turn a complex technical task into a single, structured brief for AI. You'll learn how to request multiple artifacts at once (formula, SQL, script, tests) and manage your communication with AI like a small project.