Excel Pivot tables & SQL Outer Joins

Excel- Pivot tables

Analyzing Data Dynamically using Pivot tables

Pivot table is one of the most powerful tools in Excel. You will end up using this repeatedly in your job. Pivot tables allow you to analyze different pieces of large and detailed datasets using only a few mouse clicks. The 2 videos below provide a simple introduction to pivot tables.

SQL- More About Joins

JOINs Continued

Previously you learned about INNER JOIN. Now learn about OUTER JOIN. Enjoy!

Data in Action

Practice Exercises