Ravindra BagaleCourses & study guides Track your progress

SQL for Excel Users (Term Map + Side-by-Side)

By Last updated:

Lessons in this chapter:

  1. 29.1 WHERE = Filter / SUMIFS Conditions
  2. 29.2 GROUP BY = PivotTable / GROUPBY
  3. 29.3 JOIN = XLOOKUP / Power Query Merge
  4. 29.4 CASE WHEN = IF / IFS
  5. 29.5 Practice: Same Questions in Excel and SQLite
  6. 29.6 Full Term Map: Excel vs SQL Guide on This Site

Quiz for this chapter is available on the Learn tracker after deploy.

Ravindra Bagale's Tip

Finish every lesson example in DB Browser before the quiz.

Ravi Sir's Cards for this chapter

SQL for Excel users. Your Excel skills carry over to SQL. You only need to learn the SQL names for ideas you already know.Revision cardHow is GROUP BY related to Excel? GROUP BY is the SQL version of a PivotTable or of the GROUPBY function in Excel.Interview cardExcel vs SQL: when to use which. Excel is flexible for small files on your computer. SQL is built for large tables in a shared database.Comparison card

All cards for this chapter