Run SQL queries in EXCEL (just like a normal Excel formula 🤯)
Did you know that you can use an SQL formula in Excel? Learn in this video how to run SQL queries in Excel. You don’t have to be a programmer to be able to get the most out of SQL. In this video, you’ll learn how to add the SQL formula to your Excel application. In particular, we will use the Python package xlwings and the xlwings Excel add-in. After setting everything up, I will walk you through some practical examples and share my tips and tricks for using SQL in Excel.
🌎 𝗥𝗘𝗦𝗢𝗨𝗥𝗖𝗘𝗦:
Download the xlsx workbook:
Xlwings documentation:
⭐ 𝗧𝗜𝗠𝗘𝗦𝗧𝗔𝗠𝗣𝗦:
00:00 – Intro
00:31 – Installing the dependencies
00:57 – First SQL Example
03:07 – More SQL sample queries
06:47 – Outro
◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️◼️
𝗖𝗢𝗡𝗡𝗘𝗖𝗧 𝗪𝗜𝗧𝗛 𝗠𝗘:
🌎 Website:
📝 GitHub:
⭐ Discord:
▶️ Subscribe:
🎉 𝗙𝗥𝗘𝗘 𝗘𝘅𝗰𝗲𝗹 𝗔𝗱𝗱-𝗶𝗻 𝘁𝗼 𝗯𝗼𝗼𝘀𝘁 𝘆𝗼𝘂𝗿 𝗽𝗿𝗼𝗱𝘂𝗰𝘁𝗶𝘃𝗶𝘁𝘆
Get it here:
📚 𝗥𝗲𝘀𝗼𝘂𝗿𝗰𝗲𝘀 𝗳𝗼𝗿 𝗹𝗲𝗮𝗿𝗻𝗶𝗻𝗴 𝗩𝗕𝗔 & 𝗣𝘆𝘁𝗵𝗼𝗻
Check out my recommendations:
☕ 𝗕𝘂𝘆 𝗺𝗲 𝗮 𝗰𝗼𝗳𝗳𝗲𝗲❓
If you want to support this channel, you can buy me a coffee here:
34 views
1359
295
2 months ago 09:13:09 1
Тестировщик (QA) с нуля - полный курс для начинающих
2 months ago 03:41:20 9
Databases In-Depth – Complete Course
4 months ago 00:33:11 1
Обзор головного устройства Alpine CDE-193BT
4 months ago 00:17:29 10
Урок по SQL #1 Select
5 months ago 00:08:10 4
Сцена или тоналка? Что важнее в повседневной SQ-системе
5 months ago 04:03:27 1
SQL Server Performance Essentials – Full Course
5 months ago 01:06:45 1
Make Your Own SQL Server Queries Go Faster by John Sterrett
6 months ago 00:31:19 13
Так со скольки герц играют концертные сабы? Показываю на примерах!
6 months ago 00:24:21 1
How to Install Oracle 19c and SQL Developer on windows 10/11 [ 2023 Update ] Complete guide
8 months ago 01:20:31 1
Create A REST API with FastAPI, SQLAlchemy and PostgreSQL.
8 months ago 00:54:43 11
HackTheBox - Clicker
8 months ago 00:57:55 1
Data Analyst Portfolio Project (Exploratory Data Analysis With Python Pandas)
9 months ago 00:27:23 3
FastAPI - Базы данных и миграции Alembic #4
9 months ago 00:39:00 1
Обзор аудиопроцессора MadBit DSP8
10 months ago 00:08:45 8
How to run PostgreSQL inside a Docker container
10 months ago 00:14:41 1
Ловушки SQ-шника
11 months ago 00:16:21 18
HackTheBox - Sau
11 months ago 00:13:12 1
Lake Valley Labs (LVL) One last Grand Tour showing ALL Retro Systems!
11 months ago 00:03:58 1
M2 G87 SQ Kits Sea Port Display & City Road Run丨4K - SOOQOO
12 months ago 00:24:47 1
SQL для анализа данных за 30 минут. Разбор на реальной базе данных.
12 months ago 00:06:25 1
Как закрыть технологические окна при аудиоподготовке дверей?
1 year ago 00:17:38 1
PostgreSQL Tutorial - 16 - How to setup streaming replication in PostgreSQL step by step on Ubuntu