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

Download the SQL orders-01 Excel file from the resources, open the orders worksheet, and follow along with headers like order ID, customer, and order date.

Open the SQL analysis tool from the home tab, write a simple select statement to pull all columns from the orders list, then run to produce result one.

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.

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.

Learn to filter Excel data by using the where clause in a select statement, returning only Brazil records from orders with customer, order date, ship via, and ship country.

Sort query results by ship country using order by, with default ascending order, or explicitly specify ascending or descending to control the sort direction.

Practice writing a complete sql select statement in excel using select, from, where, and order by with criteria like country or employee. Post a screenshot in q&a to show progress.

Download and open the SQL hyphen products hyphen zero one excel document to follow along as we explore the SQL where clause, applying filters to select statements in Excel.

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.

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.

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.

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.

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.

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.

Learn how to use the not in operator to exclude beverages, seafood, and condiments from the category column in a where clause, returning every other category.

Learn how to use the like operator with wildcards to filter product names in SQL. Explore starts with and ends with patterns, and case sensitivity.

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.

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.

Sum the units in stock using a SQL select statement to compute the total, and rename the resulting column header for clarity.

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.

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.

Learn to use the avg function in SQL to compute the average unit price from the products table, aliasing it as average price, alongside sum and count.

Explore how to use group by to create subtotals by category, summing unit price per category and generating total prices from the products table, with a comparison to pivot tables.

Group data by category and sum unit price to compute category totals, then filter groups with having the sum under 200, contrasting with where clause filtering at the record level.

Use SQL case statements to categorize units in stock into low, medium, and high inventory, mirroring Excel's if logic within a select query.

Format a list as an Excel table and learn the benefits for writing SQL statements; download and open the SQL orders-02.xlsx exercise file from the resources and follow along.

Format your data as named Excel tables to query with SQL, creating distinct tables like tbl orders and tbl customers to combine two datasets from one worksheet.

Write SQL queries against named tables in Excel, selecting order amount, customer ID, and order date. Use table names like TBL orders and TBL customers, with where filters.

Wrap headers with spaces or special characters in double quotes to reference them in sql within Excel. Without quotes you may get an unrecognized field name error.

Learn how to perform table joins in Excel by combining two separate lists through a related column, following along with the downloadable SQL Excel exercise file.

Learn how to build join-friendly tables in Excel by linking customers and orders with a common customer_id using a SQL select statement to match and combine records.

Learn how to use SQL joins to relate the customers and orders tables, mirroring VLOOKUP in Excel for beginner-friendly SQL use with a parent-child relationship on customer ID.

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.

Explore inner join, left outer join, and right join using the customers and orders tables to see how each returns matches and unmatched rows for comprehensive data retrieval.

Master SQL queries and connect them to Excel data to analyze sales reports, customer data, and project metrics. Use it daily to deepen your skills and tackle advanced SQL topics.