Análise de Dados no Excel | Projeto Completo | Relatório Grande, Tabela Dinamica, Gráficos

🟢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 will learn how to perform a complete data analysis in Excel, from importing a database in a TXT file to creating pivot tables, formulas, charts, and data segmentation. Related topics: Importing a TXT file into Excel, Organizing and preparing a database, Checking date, text, and number formatting, Transforming raw data into a structured table, Creating auxiliary columns in Excel, Calculating order delivery time, Using the IF function in Excel, Identifying delivered and pending orders, Comparing estimated shipping costs with actual shipping costs, Calculating the difference in values ​​in reais and percentage, Calculating the total logistics cost, Analyzing customer satisfaction, Creating a pivot table from scratch, Configuring rows, columns, values, and filters, Changing sum calculations to average, Displaying values ​​in quantity and percentage, Creating calculated fields in the pivot table, Formatting numbers, currencies, averages, and percentages, Creating charts from pivot tables, Adding data segmentation, Connecting segmentations to different analyses, Filtering information by carrier, region, and priority, Creating interactive and professional reports in Excel. Let's use a logistics database to transform thousands of data points into organized reports, indicators, and analyses useful for decision-making. This is a complete training course that can help anyone who wants to learn data analysis in Excel from scratch, develop professional skills, practice pivot tables, and understand how to work with a database similar to those used by companies. During the video, you will learn how to develop five analyses: Average delivery time, Orders delivered and pending, Estimated freight vs. actual freight, Total logistics cost, Customer satisfaction. Even using a logistics database, the knowledge presented can be applied in different areas, such as sales, finance, human resources, inventory, purchasing, transportation, administration, and operations control. #ExcellentJoão #Excel #Dashboard