Excel para RH: Dashboard Completo Passo a Passo, Fácil e Profissional

Learn how to create a complete HR Dashboard in Excel, from scratch! 🚀 In this step-by-step guide, I'll show you how to transform disorganized spreadsheets into a professional, automated, and visually stunning dashboard to facilitate decision-making in people management. If you want to go beyond the basics and deliver reports that truly impress, this tutorial is for you. I'll teach you everything from database management to final design, using essential formulas like VLOOKUP, IF, and pivot tables. In this video you will learn: 📊 In this video you will learn: How to automatically calculate turnover. How to process hiring and termination data. How to create interactive charts with data segmentation. Design tips for professional dashboards in Excel. This type of dashboard can be used in areas such as: HR Finance Sales Operations If you work with Excel, data analysis, or dashboards, this content will be very helpful. 👍 If this video helped you, don't forget to like and subscribe to the channel for more content about Excel and data analysis. 👍 If this video helped you, don't forget to like and subscribe to the channel for more content about Excel and data analysis. ____________________________________________________________________________________________ Video Topics: 00:00 - From Simple Report to Professional Dashboard 00:41 - HR Database Management 01:10 - Creating Columns for Year of Admission and Termination 02:15 - How to Use the IF Formula for Employee Status 03:13 - Calculating Company Tenure (Years and Days) 05:12 - Creating Tenure Ranges with VLOOKUP 07:22 - Starting Pivot Tables for Indicators 08:33 - Calculating Active and Terminated Employees 09:40 - How to Calculate Turnover Percentage 10:50 - Number of Employees per Department 12:30 - Analysis by Tenure Range and Contract Type 13:30 - Graph of Hires vs. Number of Employees Fired by Year 19:00 - Dashboard Design: Organizing the Panel 20:25 - Inserting Data Segmentation (Interactive Filters) 23:10 - Creating Key Indicator Cards 27:00 - Final Styling and Polishing of Charts 31:10 - Final Result and Conclusion ____________________________________________________________________________________________ 🧾 Download the spreadsheet used in this video: https://preview.mailerlite.io/forms/2... ____________________________________________________________________________________________ My Contacts: ▶ Email: [email protected] ▶ YouTube: /    / @dicasexcelandrea   ▶ Instagram: /   / excel.andrea   ▶ TikTok TikTok: /   / dicas.de.excel.andrea   #Excel #Dashboards #HR #HumanResources #HRIndicators #HRSpreadsheet #PeopleManagement #ProfessionalExcel #ExcelTutorial