Learn to use AI to write complex Excel formulas in just 20 minutes. Master prompting techniques for VLOOKUP, SUMIF, nested IFs, and formula debugging with practical exercises.
If Excel formulas have ever slowed you down, this free micro course shows you a faster path. In about 20 minutes you will learn how to use AI to write the formulas you need, from straightforward lookups to multi-condition aggregations and nested logic, so you spend less time troubleshooting syntax and more time getting results from your data.
The course is structured around one focused module that takes you from the basics to the practical. You will start by understanding how AI reads and reasons about spreadsheet data, then move into prompting techniques for formulas like VLOOKUP and SUMIF. From there, you tackle complex nested IFs and learn how to use AI as a formula debugger when something does not behave as expected. A hands-on practice session at the end lets you apply each technique before you finish.
This course is a strong fit for students, analysts, office workers, and anyone who uses Excel regularly but does not come from a programming background. No prior formula experience is required. Complete the lessons and pass the final exam to earn a certificate of completion you can share on LinkedIn or add to your resume.
1 modules • 5 lessons
Finish every lesson and pass the final exam to earn this free, shareable certificate.
Certificate of Completion
has successfully completed
12 lessons · Final exam passed
Michail Ouroumis
Founder, FreeAcademy.ai
Sample preview. Your name appears on the certificate when you complete the course. Learn more
The course teaches you how to use AI tools to write and fix Excel formulas on demand. You will work through prompting strategies for common formulas like VLOOKUP, SUMIF, and nested IFs, and you will practice debugging formulas by describing errors to AI instead of hunting through documentation.
Yes, the course is completely free and requires no account to start. You can also earn a certificate of completion by finishing all lessons and passing the final exam, which you can add to your resume or LinkedIn profile.
No prior formula knowledge is assumed. The course begins with how AI understands spreadsheets, so even if you have only used Excel for basic data entry you will be able to follow along from the first lesson.
The course focuses on VLOOKUP, SUMIF, and nested IF formulas as the main examples, and it covers the prompting approach you can reuse with any formula type. There is also a dedicated lesson on debugging, which applies to any formula that is returning unexpected results.
The course is designed to be completed in around 20 minutes. It follows a single focused module with five lessons, including a practice session, so you can fit it into a lunch break or short study block.
Master ChatGPT for workplace efficiency. Learn practical techniques for emails, meetings, reports, data analysis, presentations, research, problem-solving, and building personal productivity workflows. Each lesson solves one real work task - perfect for office workers, managers, and knowledge workers.
Learn to extract structured data from PDF documents using AI tools like ChatGPT and Claude. Master techniques for tables, forms, scanned documents, and converting to spreadsheet formats.
Learn to use AI to create, optimize, and tailor resumes that get noticed. Master prompts for bullet points, job description matching, ATS optimization, cover letters, and LinkedIn profiles.
Learn to use AI as a writing partner without losing your voice. Master brainstorming, overcoming writer's block, outlining, editing, rewriting for different audiences, research assistance, and the ethics of AI in writing.
Master the complete job hunting process using AI. Learn to find relevant jobs, tailor applications, prepare for interviews, negotiate salaries, craft networking messages, and write effective follow-up emails.
Master Perplexity AI for accurate, sourced research. Learn effective query writing, understand sources and citations, use Pro Search features, and develop academic research workflows. Perfect for researchers, students, journalists, and anyone who needs fact-checked information.
