Adeus PROCV e PROCX 😢 Tabela Dinamica agora busca dados de outras tabelas

🟢LEARN EXCEL WITH ME IN THE COMPLETE EXCEL COURSE WITH CERTIFICATE: https://excelentejoao.com.br/sejaexce... 🔵SPREADSHEET: https://excelentejoao.com.br/wp-conte... In this free Excel video lesson, we'll learn how to use Pivot Tables to cross-reference data between tables, analyze information, and create reports much faster and more professionally. Many people use VLOOKUP or XLOOKUP to retrieve information from one table and bring it to another. But, when the goal is to perform data analysis, reports, or dashboards, Pivot Tables can often solve the problem in a more organized way. In this example, we have a customer table with Customer Segment and a freight table with Freight ID, Customer, Number of Packages, Merchandise Value, and Freight Cost. Starting from these two bases, we will create a relationship between tables and use PivotTables to analyze the data without needing to create several auxiliary formulas. We will see how PivotTables can replace some analyses done with VLOOKUP, XLOOKUP, SUMIFS, COUNTIFS, and other Excel formulas, especially when we are talking about summarizing, grouping, cross-referencing, and analyzing data. PivotTable in Excel, Relationship between tables, Excel Data Model, How to cross-reference tables without VLOOKUP, How to cross-reference tables without XLOOKUP, How to analyze freight by customer segment, How to sum the number of volumes by segment, How to create analyses for dashboards in Excel, How to work with related databases. If you work with Excel daily and want to create more professional reports, more organized dashboards, and faster analyses, this lesson can help you. Note: the idea is not to say that VLOOKUP and XLOOKUP are no longer useful. These formulas remain very useful. But for many types of analysis, Pivot Tables can be a faster, cleaner, and more professional solution. #ExcellentJoão #Excel #Dashboard