116,658 views
Excel's Relationship tool allows you to create a relationship between tables, making it easier to search for information between them. Excel has an internal Data Model, making VLOOKUP obsolete when searching for information in tables. You can create a relationship between two or more data tables, based on corresponding data from each table. You can then create Pivot Tables and other reports with fields from each table, even when the tables come from different sources. This makes it easier to cross-reference data and create your dynamic reports and Dashboards. Link to download the sample file: https://drive.google.com/file/d/1PpqX... Link to lesson 2 about Relationships between Tables: • Creating Relationships between Tables... #excel #relationships #dataanalysis #dataanalysis #database #pivottable #relashionship #advanceexcel #leveragedexcel #toptip #excelclass #tipoftheday #amazingtips #exceltips #pivottable #dashboard #fantasticinfotrainings #exceltips For information about our trainings, visit: http://www.fantasticinfo.com.br