Sql For Excel Users: Beginner-Friendly Guide For Excel Users

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

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

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.

Overview

Section 1: Excel SQL - Course Introduction and Setup

Lecture 1 Why SQL for Microsoft Excel Users?

Lecture 2 Installing the SQL Analysis Excel Add-In

Lecture 3 Overview of the SQL Excel Panel

Lecture 4 Excel SQL Exercise Files

Section 2: Your First SQL Queries in Excel

Lecture 5 DOWNLOAD 01 - SQL Orders Excel Exercise File

Lecture 6 Writing Your First SQL Query in Excel

Lecture 7 Selecting Specific Columns

Lecture 8 Using SQL Comments

Lecture 9 Filtering with the SQL WHERE Clause

Lecture 10 Sorting Results with ORDER BY

Lecture 11 EXERCISE 01 - Writing SQL in Excel

Lecture 12 Quick Reference Guide 01: SQL Basics for Excel Users

Section 3: Filtering Excel Data with SQL WHERE Clause

Lecture 13 DOWNLOAD 02 - SQL Products Excel Exercise File

Lecture 14 Basic WHERE Clause Filtering

Lecture 15 Logical Conditions: AND Statement

Lecture 16 Logical Conditions: OR Statement

Lecture 17 TIP: Filtering Currency Values in Excel SQL

Lecture 18 Filtering with BETWEEN

Lecture 19 Filtering with the IN Operator

Lecture 20 Filtering with the NOT IN Operator

Lecture 21 Filtering with LIKE

Lecture 22 Quick Reference Guide 02: SQL WHERE Clause for Excel Users

Section 4: SQL Functions for Everyday Excel Users

Lecture 23 DOWNLOAD 03 - SQL Products Excel Exercise File

Lecture 24 Introducing SQL Aggregate Functions

Lecture 25 Calculating Totals with SUM()

Lecture 26 Naming Calculated Columns in SQL with the AS Keyword

Lecture 27 Calculating Totals with COUNT()

Lecture 28 Calculating Average with AVG()

Lecture 29 Using GROUP BY for Data Summarization

Lecture 30 Filtering Aggregated Data with HAVING

Lecture 31 Conditional Output with CASE (Like IF() in Excel)

Lecture 32 Quick Reference Guide 03: SQL Functions for Excel Users

Section 5: Querying Structured Excel Tables

Lecture 33 DOWNLOAD 04 - SQL Orders Excel Exercise File

Lecture 34 Creating and Naming Structured Excel Tables

Lecture 35 Writing SQL Queries Using Table Names

Lecture 36 Referencing Columns with Spaces or Special Characters

Lecture 37 Quick Reference Guide 04: Structured Excel Tables for Excel Users

Section 6: SQL Table Joins - Working Across Multiple Excel Sheets

Lecture 38 DOWNLOAD 05 - SQL Excel Exercise File

Lecture 39 Creating JOIN-Friendly Tables in Excel

Lecture 40 Introducing JOINs: The SQL Version of VLOOKUP

Lecture 41 INNER JOIN: Return Records that Match from Both Tables

Lecture 42 LEFT JOIN: Return All Records from One Table

Lecture 43 Quick Reference Guide 05: SQL Table Joins for Excel Users

Section 7: Congratulations

Lecture 44 Congratulations on Completing the SQL for Excel Users Course

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