No video :(

Build an interactive Human Resources Dashboard in Microsoft Excel - HR Dashboard

Подписаться 2,8 тыс.

Просмотров 135 тыс.

50% 1

Download Practice files used in this video
bit.ly/3N3CVLZ
bit.ly/3GYKaRq
In this video, you will learn how to build an interactive Human Resources dashboard in Microsoft Excel
--------------------------------------------------------------------------------------------------------------------
Excel Data Analysis Masterclass with Excel Dashboards - Learn Data Analysis and Data Visualization with Excel Dashboard.
In this course we will cover topics like Excel Data Analysis and Data Visualization with Excel Pivot Tables, Excel Pivot Charts and 5 Interactive and Excel Dashboard.
Excel Charts and Excel Graphs are one of most powerful features of Microsoft Excel which allows the users to represent numerical data in Graphical Data Visualization format so that end user gets a better view of the Information discussed.
In this course
- You will learn the Excel Pivot Table and Excel Pivot Chart Function in detail and you will learn how to create Dynamic Excel Charts and Excel Graphs.
- You will Learn to create 6 Dynamic Sales Dashboards and Report template in Excel
- You will learn how to design, style and format aspects of Excel 2019 are applied on Excel charts
- You will use the dynamic graphical representation to display your complex data in an impressive way.
- Impress management with reports and dashboards that make the decision-making process faster
- Actionable Excel Tips which you can use now to Create Eye-Catching Microsoft Excel Dashboard
- Learn the Secrets to Building Excel Dashboards
- Use of Excel core functionality for responsive spreadsheets
- Create impressive, non-standard Excel charts using smart techniques
- Build Pivot Table-based interactive dashboards for dynamic usage
- This Course is structured in 30 Plus chapters and you will learn all the aspects of Excel Dashboard in depth .
- We will go through, steps in detail to create 6 Dynamic Excel Dashboard using Charts, Design and Style Elements. You can use either Microsoft Excel 2010, Excel 2013, Excel 2016 or Excel 2019 for this learning.
Topics Covered
- Build an interactive Sales Dashboard in Microsoft Excel
- Build an interactive Human Resources Dashboard in Microsoft Excel
- Build an interactive Website Analytics Dashboard in Microsoft Excel

Опубликовано:

20 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 60

@sunlitegodis Год назад

This is the first video I came across when trying to build out an HR Dashboard, and it is the video I come back to time and again. The pace, the positive vibes and the clear instructions has me feeling confident that I can take the information, steps, examples, etc. and create what I need as I review data and build out. Thank you so very much for this demo and making it easy to follow along!

@silvestrecamposano6317 Год назад

Thank you very much... I have been assigned by my Boss to create a similar project. I hope I can also do my own based on your samples. More power to you, Sir....

@iqradalvi5540 Год назад

Plz send dataset

@tboykelvin1865 Год назад

Pls help with dataset

@meghagupta4235 10 месяцев назад

Plz send dataset

@tseongjay7574 11 месяцев назад

Clear and concise tutorial. Thank you!

@agrawalmitesh4395 Месяц назад

Gem , it was mind blowing.

@Shubhangink28 2 месяца назад

Thankyou so much

@nigilv.d4237 2 года назад

Very nice hats off

@skillsondemand2978 2 года назад

Thank You Nigil.

@liantalukder722 Год назад

Just Awesome. Thank You So Much.

@jamiereife5581 12 дней назад

If you copied the shapes or format painted the shapes and then changed the color would that be quicker?

@skillsondemand2978 12 дней назад

@@jamiereife5581 format painter option is easier

@ahmedjumaa865 Год назад

This is great efforts, could you please share the practice file. The above link couldn't take you there.

@lilyfullery4779 Год назад

hi thanks for such fantastic video , kindly provide the practise file.

@fabiolacruz5854 Год назад

So we need to buy the course in order to get data file?

@ayushmadeep9027 3 месяца назад

Where i can download the data sheet

@phirojshaikh5720 6 месяцев назад

nice'

@cybertecy6263 10 месяцев назад

please provide data set the link is directing towards udemy

@anime-dam1707 11 месяцев назад

from where i can downloads find this data sheet

@jamelwomack26 10 месяцев назад

What if real time data is needed, which is updated frequently, sometimes daily or weekly?

@skillsondemand2978 10 месяцев назад

Excel has the option to import data (Under data tab) you can add an additional sheet, connect the data source and then customize the dashboard data with relevant columns. it should work

@abayomiadio640 9 месяцев назад

i couldn't find the workbook for practice+

@maverick19_ Год назад

how does the tree map update if you change info on the data sheet as it is no longer linked to a pivot

@shalaka18pinge 7 месяцев назад

My data does not sync…. Towards the end when I choose data from slicers the data on the dynamic shapes give an error, please help

@adelokunstephen1504 Год назад

We haven’t been able to download the data set. Please help us out for practice

@brucewang2035 Год назад

May I know where is the practice files, the link only lead to the website without the files, thanks!

@aishwaryapattnaik3082 Год назад

What's the use of so many tutorials where you don't share datasets? Just links to your paid Udemy courses which costs around 2800/- very expensive for people who are trying to get jobs ..😕

@christiankouam1741 Год назад

Salut s'il vous plaît besoin du fichier de la base de donnée Merci

@skillsondemand2978 Год назад

Hi, Please download the practice files from the description

@countkhumalo1852 Год назад

Hi, is there a reason we are not getting answered on the practice files? Great presentation though

@skillsondemand2978 Год назад

Hi, Please download the practice files from the description

@aryanbhagat542 Год назад

@@skillsondemand2978 Should we buy the Udemy course to get data file?

@PriyaRajvanshHR Год назад

In my excel there is no chart with option treemap

@staticplayz7377 11 месяцев назад

Why I cant put in numbers into the square shape? I followed all instructions but stuck at 11:55

@davidyeboahappah7497 2 месяца назад

hello can you please share dataset with me?

@sayedamehar4562 Год назад

Where is the workbook file attached??

@atreyeepal3643 9 месяцев назад

I can't find the data set

@satishmane2950 Год назад

It is helpful tobis if the practice file share here

@skillsondemand2978 Год назад

Hi, Please download the practice files from the description

@masifarain2203 Год назад

@@skillsondemand2978 files are not downloadable from description, link goes to Udemy. Please attach files again here downloadable.

@dareentantawy3202 Год назад

Hello All, I think the sheet is unavailable so if anyone did it already please send if accessible

@wijesundarananhamige244 Год назад

Where is the data file i not found?

@PriyaRajvanshHR Год назад

Where is the excel workbook

@REALUPDATESS 2 года назад

CAN YOU PLEASE TELL ME BEST COURSE IN HR ANALYTICS

@skillsondemand2978 2 года назад

Hi Nikita, What exactly are you looking for? Are you looking to learn how to create HR dashboards or Data Analysis of HR related data.

@REALUPDATESS 2 года назад

@@skillsondemand2978 I have been hearing that HR ANALYTICS is one of the emerging courses in HR FIELDS I had attended few classes on power BI. But need guidance how can I start and what would be good course to learn from A to Z

@skillsondemand2978 2 года назад

@@REALUPDATESS Hi Nikita, HR Analytics is just a term, it's all part of data analytics. Once you learn Data Analysis or let's say Data Analytics, it doesn't really matter if it's HR or Sales or Marketing or anything else. It's all about playing with the Data to get meaningful insights. Again, it all depends on what tools you want to use for analysis. Doing analysis in Excel is simple. Now the trending tool is Microsoft Power Bi. We have a 43 hours and 73 hours Power Bi master class course in Udemy (with 30 days money back guarantee). If u are interested do check it once by clicking on the link in our video description. (Link will lead to Udemy) We also have 2 Free Power Bi dashboard courses in Udemy which will give you a hands on experience of how Data Analysis and dashboard works in Power Bi. Let me know if u have further queries. Happy to Help!