SQL for Excel Users: Beginner-Friendly Guide for Excel Users

Name: SQL for Excel Users: Beginner-Friendly Guide for Excel Users
Rating: 4.7 (593 reviews)

Learn SQL directly in Microsoft Excel using a free add-in—no database setup or coding experience required!

Bestseller

Highest Rated

Created byKyle Pew • 2,000,000+ Students

Last updated 5/2025

English

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

Course content

7 sections • 44 lectures • 2h 4m total length

Why SQL for Microsoft Excel Users?2:08
Installing the SQL Analysis Excel Add-In1:59
Overview of the SQL Excel Panel4:09
Excel SQL Exercise Files2:05

DOWNLOAD 01 - SQL Orders Excel Exercise File1:57
Writing Your First SQL Query in Excel3:53
Selecting Specific Columns4:14
learn to use the select keyword to pull specific columns from an orders worksheet, ensuring correct column spelling and proper from clause to return targeted data.
Using SQL Comments3:42
Learn how to add SQL comments, including single-line comments with two hyphens and multi-line comments using a forward slash and an asterisk, to annotate select statements.
Filtering with the SQL WHERE Clause4:04
Sorting Results with ORDER BY5:12
EXERCISE 01 - Writing SQL in Excel2:12
QUIZ 01 - SQL Basics
Quick Reference Guide 01: SQL Basics for Excel Users0:20

DOWNLOAD 02 - SQL Products Excel Exercise File0:46
Basic WHERE Clause Filtering4:19
Use the where clause on the discontinued column to filter active products, returning product id, product name, unit price, and units in stock from the products table.
Logical Conditions: AND Statement2:31
Learn to filter with sql where clauses using and conditions to identify discontinued items that still have stock, by applying discontinued = true and units in stock > 0.
Logical Conditions: OR Statement3:38
Explore how to use an or statement in a where clause to filter products by multiple categories, such as beverages or condiments, selecting product id, name, category, and unit price.
TIP: Filtering Currency Values in Excel SQL3:08
Filter currency values in Excel SQL by converting the unit price to numeric to remove dollar formatting, then use where unit price is greater than 30 to retrieve results.
Filtering with BETWEEN1:54
Learn how to filter unit price in SQL using greater than 30 and the between keyword to define a range, such as 30 to 100, with practical examples and validation.
Filtering with the IN Operator3:17
Learn how to simplify multi-value filters with the SQL in operator by replacing repeated or conditions with a where category in ('beverages','seafood','condiments'), streamlining queries.
Filtering with the NOT IN Operator1:08
Filtering with LIKE3:55
QUIZ 02 - SQL WHERE Clause Filtering
Quick Reference Guide 02: SQL WHERE Clause for Excel Users0:26

DOWNLOAD 03 - SQL Products Excel Exercise File1:09
Explore translating common Excel functions such as sum, average, and count into SQL select statements, and practice with the SQL products exercise file to follow along.
Introducing SQL Aggregate Functions2:38
Learn how to use SQL aggregate functions like sum, count, and average to summarize data in select statements, group by category, and compare with Excel equivalents.
Calculating Totals with SUM()3:16
Naming Calculated Columns in SQL with the AS Keyword1:36
Apply the as keyword to name calculated columns in a SQL select statement, turning a sum calculation into a labeled total units column for clearer results.
Calculating Totals with COUNT()2:06
Explore using the sql count function in a select statement to count product_id from the products table, aliased as total products, yielding 77 items.
Calculating Average with AVG()1:57
Using GROUP BY for Data Summarization5:05
Filtering Aggregated Data with HAVING5:41
Conditional Output with CASE (Like IF() in Excel)7:42
QUIZ 03 - SQL Functions
Quick Reference Guide 03: SQL Functions for Excel Users0:21

DOWNLOAD 05 - SQL Excel Exercise File0:57
Creating JOIN-Friendly Tables in Excel1:50
Introducing JOINs: The SQL Version of VLOOKUP4:10
INNER JOIN: Return Records that Match from Both Tables7:07
Learn to perform an inner join between customers and orders, building a multi-table select from the customers primary table and the orders table, and resolve ambiguous customer ID references.
LEFT JOIN: Return All Records from One Table4:58
QUIZ 05 - SQL Table Joins
Quick Reference Guide 05: SQL Table Joins for Excel Users0:13

Requirements

A basic working knowledge of Microsoft Excel (navigation, entering data, using simple formulas)
Microsoft Excel 2016 or later (including Microsoft 365) with access to the Get Add-ins feature
No prior experience with SQL or databases is required — this course is beginner-friendly and starts from the basics
A willingness to learn new ways to analyze and work with data more efficiently

Description

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.

Who this course is for:

Excel users who want to take their data analysis skills to the next level using SQL
Beginners who have never written a SQL query but are comfortable working with Excel data
Students or career switchers looking to build practical, job-ready SQL skills within a familiar Excel environment
Excel users who frequently rely on formulas, filters, PivotTables, or VLOOKUP—and want a faster, more powerful way to query their data

SQL for Excel Users: Beginner-Friendly Guide for Excel Users

What you'll learn

Explore related topics

Course content

Excel SQL - Course Introduction and Setup4 lectures • 10min

Your First SQL Queries in Excel8 lectures • 26min

Filtering Excel Data with SQL WHERE Clause10 lectures • 25min

SQL Functions for Everyday Excel Users10 lectures • 32min

Querying Structured Excel Tables5 lectures • 11min

SQL Table Joins - Working Across Multiple Excel Sheets6 lectures • 19min

Congratulations1 lecture • 2min

Requirements

Description

Who this course is for: