Try copying a pivot table in SQL. A lot of simple functions in Excel are incredibly complex in SQL. You might technically can pull most off put then you end up

Try copying a pivot table in SQL. A lot of simple functions in Excel are incredibly complex in SQL. You might technically can pull most off put then you end up with a lot of ugly SQL. Also each time you make a change with SQL, you have to query the database again which can be slow and inefficient. I use both tools together, exporting SQL results and opening in Excel for further clean up. That way you can take advantage of the strengths of each one.