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
Previously you learned about INNER JOIN. Now learn about OUTER JOIN. Enjoy!