Course Information
Registration period
Year-round Recruitment
Course Level
Study Mode
Duration
2 Hour(s) 4 Minute(s)
Language
English
Taught by
Kyle Pew • 2,000,000+ Students
Rating
Course Overview
Learn SQL directly in Microsoft Excel using a free add-in—no database setup or coding experience required!
Are you an Excel power user ready to take the next step in your data journey? This course was built just for you.
"SQL for Excel Users" is your fast track to learning SQL—the language of data—in a way that feels familiar, practical, and instantly useful. If you know your way around formulas, filters, and PivotTables but feel stuck when it comes to managing larger, more complex datasets, it’s time to unlock SQL right inside Excel. No installations. No intimidating database setup. Just you, Excel, and the skills to command your data like a pro.
In this action-packed, beginner-friendly course, you’ll learn how to write SQL queries directly in Excel using a lightweight add-in. You’ll go from SELECT to JOIN, from WHERE to GROUP BY, all while working with the kinds of datasets you already use every day. Think of SQL as the next logical step in your Excel evolution—and we're going to make it simple, fast, and fun.
Whether you’re in analytics, finance, marketing, HR, or any data-driven role, this course will empower you to query smarter, report faster, and finally bridge the gap between Excel and true database power.
Enroll now and add SQL to your Excel toolkit—your future self (and your boss) will thank you.
Course Content
- 7 section(s)
- 44 lecture(s)
- Section 1 Excel SQL - Course Introduction and Setup
- Section 2 Your First SQL Queries in Excel
- Section 3 Filtering Excel Data with SQL WHERE Clause
- Section 4 SQL Functions for Everyday Excel Users
- Section 5 Querying Structured Excel Tables
- Section 6 SQL Table Joins - Working Across Multiple Excel Sheets
- Section 7 Congratulations
What You’ll Learn
- Write and run SQL queries directly inside Microsoft Excel using a simple, built-in SQL editor
- Use SQL SELECT, WHERE, and ORDER BY statements to retrieve and filter Excel data
- Apply aggregate functions like SUM(), AVG(), COUNT() and group results using GROUP BY
- Use conditional logic with CASE, IN, BETWEEN, and LIKE to perform advanced filtering
- Perform SQL-style joins across multiple Excel tables—replacing the need for VLOOKUP or XLOOKUP
- Convert worksheet ranges into structured Excel Tables and query them using SQL
- Understand when to use SQL vs. Excel formulas, PivotTables, or Power Query for analysis
Skills covered in this course
Reviews
-
DDimitri Rearden
Clear, easy to follow, excellent supplemental notes, thank you for great course!
-
CConrado Reyes
I highly recommend the course. Instructor was very clear and thorough in explanation on every clause, statement , function, etc. Looking forward to using new SQL skills
-
SSuresh Pal
You are really grate and explained well, Till now i have enjoyed a lot
-
AAnonymized User
Great training skills and well explained in plain language to help the learner grasp the content. The practice data was super helpful as well
