Скачать с ютуб Step 1: Building the HR Salary Dashboard Calculations Tab Using Pivot Tables в хорошем качестве

Step 1: Building the HR Salary Dashboard Calculations Tab Using Pivot Tables

Building an HR Salary Dashboard Using Pivot Tables in Excel Buy the dashboard for $5: https://gumroad.com/l/hr-salary-dashb... You can also visit my website at http://bradedgar.com for more Excel goodies. There are multiple different ways that you build an Excel dashboard or an HR Salary Dashboard in Excel. The final dashboard needs to include the top 3 and bottom 3 compensation salaries and it needs to include the total employee count, the cumulative salary value, and the average salary. The pivot tables allow us to have a dynamic result data set that will change as records are added to our employee table. In this video I walk you through some of the following different Excel techniques: (1) How to setup a pivot table in Excel using tables (Employee table in this case). (2) How to setup and change the name of your pivot table. (3) How to change your pivot table from a compact form to a tabular form pivot table. (4) I offer a quick explanation of the 4 pivot table areas (filter, columns, row labels and values). I explain that we only need to make use of the row labels area and the values area in this tutorial. (5) Once dragging the correct fields into our pivot table row label section and value section, I update the pivot tables from the design tab to be in tabular format, to have repeat items, to remove subtotals and to remove grand totals off of rows and columns. (6) I then review how you can use the sorting option on the highest level of your pivot table to sort in ascending or descending order. For top 3 highest compensation or salary, we use the descending order. For bottom 3 compensation or salary, we use the ascending. We then look at how to apply the top 10 value filter and bottom 10 value filter. (7) I also dive into how easy it is to simply copy a pivot table and paste the same pivot table elsewhere and change your field settings to suite your needs. We look at formula pasting, and formatting pasting as well. (8) The concatenate formula is also used to merge the names of the top 3 and bottom 3 compensated employees based on salary. This provides us with the employees full name for the final dashboard. (9) We then setup the employee count, cumulative salary and average salary pivot tables. I show you how you can change the custom number format to also be in thousands. http://bradedgar.com/10-ways-pivot-ta... http://fiveminutelessons.com/learn-mi... http://pakaccountants.com/excel-sales... http://chandoo.org/wp/excel-pivot-tab... http://bradedgar.com/excel-kpi-dashbo... http://www.skilledup.com/articles/10-... http://www.businessinsider.com/excel-... http://www.myonlinetraininghub.com/ex... ~-~~-~~~-~~-~ Checkout my newest video: "How to Use the Vlookup Formula in you Excel Dashboard"    • How to Use the Vlookup Formula in you...   ~-~~-~~~-~~-~