Photo by Olenka Sergienko from Pexels

You know Excel. Time to learn SQL.

9 core excel functionalities translated into SQL

Skyler Dale
Towards Data Science
7 min readOct 20, 2020

--

As the world becomes increasingly data-driven, a growing number of professionals are working more closely with data.

In many cases, the first introduction to this domain comes in the timeless form of Microsoft Excel. Vlookups, pivot tables, sumifs; maybe a little VBA for the adventurous.

--

--

Data Scientist. I make complex concepts easy to understand. Sign up to read my posts & I receive part of your fee: https://bit.ly/subscribe-medium