Data Analysis with Excel 📈📉📊✅ - Make Pivot Tables from more than one source data table with this simple trick

4.0 (1)

11 learners

What you'll learn

This course includes

14.3 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

chandoo chandoo.org Excel spreadsheets pivot table from multiple datasets pivot from more than one table how to use excel data model how to set up relationships in excel advanced pivot table tricks

Full Transcript

#datamodel #Excelrelationships #twotablesonepivot We can all create pivot reports from single tables or ranges of data. What if you need to create a pivot from data that is in two or more tables? You can use "Data Model" feature of Excel to connect multiple tables and create pivots from them. This technique opens up doors for advanced data analysis with ease. For example workbook and resources visit: https://chandoo.org/wp/advanced-pivot-tables/

Continue this lesson in the app

Install CourseHive on Android or iOS to keep learning while you move.

Welcome