Lesson 1: Ask AI to Write a Python Script for an Excel Job No sign-up needed.
Every course, exam and certificate is free. Premium only removes ads and adds extras.
Last updated
Let ChatGPT, Claude or Gemini write small Python scripts for boring Excel jobs, then run them free in Google Colab. Combine files, clean messy columns, build summary tables, split a sheet into many files and format the output. Learn to check AI-written code and keep data private. Free certificate.
If you spend hours every month copying sheets together, cleaning the same messy columns or splitting one big file into many, this short course shows you how to hand that work to a Python script, without learning to code first. An AI chatbot such as ChatGPT, Claude or Gemini writes the script. You learn to describe the job clearly, run the script for free in Google Colab in your web browser, and check that the result is right. You will combine many Excel files into one, clean extra spaces, mixed capitals, duplicates, dates and numbers stored as text, and build summary tables like pivot tables with pandas. Then you will split one sheet into a file per region or client, download them as a zip, and format the output with bold headers, number formats and live SUM formulas using openpyxl. Along the way you get a simple routine for checking AI-written code: row counts, one known total, a few sample rows and a small test copy. The last lesson turns your script into a reusable monthly tool and shows how to keep private data out of chatbots. Built for students, finance and accounting learners and office workers who use Excel or Google Sheets. Six short lessons with in-browser pandas practice, quizzes, a final exam and a free certificate.
3 modules • 6 lessons
Finish every lesson and pass the final exam to earn this free, shareable certificate.
Certificate of Completion
has successfully completed
6 lessons · Final exam passed
Michail Ouroumis
Founder, FreeAcademy.ai
Sample preview. Your name appears on the certificate when you complete the course. Learn more
Teaching a class or training a team? Assign this course for free
No. An AI chatbot writes the scripts. You learn to describe the job, run the script, read what it does in Excel terms and check the result. Knowing basic Excel is enough.
No. You run everything in Google Colab, which works in a web browser with a free Google account. The lessons also have in-browser pandas practice.
Yes. In Google Colab, pandas reads and writes Excel files, and openpyxl adds formatting like bold headers, number formats and formulas.
Only share what your school or employer allows. The AI only needs column names and a few example rows, so the course shows you how to use fake sample data instead of real values.
About 55 minutes across six short lessons. Each lesson has a quiz, and there is a final exam with a free certificate when you pass.
Learn how much electricity and water AI really uses. See what one prompt costs compared with everyday things, where a data center's energy and water go, how training compares with daily use, why communities debate new data centers, how to use AI with less waste, and what comes next. No code. Free certificate.
Learn to clean messy data using AI without writing any code. Spot data problems, fix inconsistent text, handle missing values and duplicates, reformat columns, and build a reusable cleaning workflow with ChatGPT and Claude.
Master data visualization using Matplotlib and Seaborn. Learn to create compelling visualizations from basic plots to advanced statistical charts. Practice with real datasets and build visualization skills for data science, analytics, and business reporting.
Learn Python from zero with a focus on AI and data science. Master the language essentials, then use ChatGPT, Claude, and Gemini as coding tutors while you build real projects with NumPy, pandas, matplotlib, and scikit-learn. Perfect for university students and early-career learners. No prior coding required, and you earn a free certificate to add to your LinkedIn and resume.
Master JSON parsing, manipulation, and transformation with hands-on exercises. Learn to navigate complex data structures, transform API responses, and build data pipelines in your browser.
Discover the economic forces driving AI products. Learn cost structures, pricing strategies, two-sided markets, compute commodities, and network effects through the lens of ChatGPT and other AI services.
