Track overview: SQL for Excel Users

From spreadsheet to answers. Welcome to the SQL for Excel Users track of Practical SQL for Analysts course. Picture this. It's the first of the month, and your manager wants last month's sales by product, with customer names attached. Right now that means exporting three sheets, gluing them together with VLOOKUP, and building a pivot table by hand. What if one short query could do all of that in a few seconds, every month, with no copy and paste? That's what this track gives you. We'll work with an online shop's orders, customers and products tables, and by the end you'll write that monthly report yourself.

Who this track is for. This track is for business analysts who use Excel every day and have never written a line of SQL. SQL, by the way, is simply the language you use to ask questions of tables stored in a database. If you already know how to filter a column, build a pivot table or use VLOOKUP, you have the right starting point. Every idea here maps to something you already do in a spreadsheet. The only tool you need is SQLite, a small, free database that runs on your own computer as a single file. No server, no IT ticket.

One course, four steps. The track has one course, Practical SQL with SQLite, and it's built as a staircase. First you learn to pull and filter rows from the orders table. Then you summarize those rows, the way a pivot table does. Next you combine tables, the way VLOOKUP does. Finally you put all three skills together in a project: a monthly sales report for the online shop. Each step uses only what came before, so you never face two new ideas at once.

Your first query. The first lesson is your first query on the orders table. SELECT picks which columns you want to see, like hiding the columns you don't need. WHERE keeps only the rows that match a condition, for example orders above one hundred dollars, just like an Excel filter. ORDER BY sorts the result, largest order first or newest date first. After this lesson, you'll be able to answer everyday questions like which orders came in last week, without touching a spreadsheet.

Summarizing like a pivot table. The second lesson is where SQL starts to feel like a pivot table. GROUP BY collapses many rows into one row per group, say one row per product or per month. Then you apply a calculation to each group. COUNT tells you how many orders there were. SUM adds up the revenue. AVG gives the average, which is just the total divided by the number of items. One line of SQL replaces the whole pivot table wizard, and it gives the same answer every time you run it.

Combining tables like VLOOKUP. The third lesson covers JOIN, the SQL version of VLOOKUP. In the online shop, the orders table stores only a customer ID and a product ID. The names, cities and prices live in the customers and products tables. A JOIN matches rows across tables using that shared ID, so each order picks up its customer's name and its product's price. Unlike VLOOKUP, nothing breaks when someone inserts a column or sorts a sheet. After this lesson, you'll connect all three tables in a single query.

Project: monthly sales report. The course ends with a project, a monthly sales report query for the online shop. You'll filter orders to one month, join in customer and product details, and group the results to show totals per product. This is the exact report from the start of this video. Once it's written, next month's report is just a matter of changing the dates and running it again. That's a real, reusable piece of work you can show your team.

Getting the most from it. A few tips to make this stick. Take one lesson at a time, and keep sessions short so each idea settles. Type every query yourself instead of copying it, because your fingers learn the patterns faster than your eyes do. Then play: change a date, swap a column, and see what happens. Mistakes in SQLite cost nothing, since it's a file on your own machine. And please do the project. It's where the separate pieces click into one working skill.

Recap and next steps. Here's what the SQL for Excel Users track of Practical SQL for Analysts course gives you. You'll filter and sort orders with SELECT, WHERE and ORDER BY. You'll summarize them like a pivot table with GROUP BY, COUNT, SUM and AVG. You'll combine orders, customers and products with JOIN, instead of fragile VLOOKUPs. And you'll finish with a monthly sales report you can run again and again. Next up is your very first query on the orders table. Let's get started.