How to create a Dashboard in Excel from scratch (HR Dashboard )

Опубликовано: 01 Июль 2026
на канале: Gerson Viergutz

2,094,625

21k

Want to be an Excel expert? Check it out: http://bit.ly/curso_dash_youtube_rh
Free Online Dashboard Workshop in Excel: http://bit.ly/workshop_dash_youtube_rh
How to Create a Dashboard in Excel
Want to learn more? See the schedule of classroom courses: http://bit.ly/minhasagendas
Telegram Dashboard Group: https://t.me/grupodashboard

Receive Spreadsheet: http://www.minhasplanilhas.com.br/ins...

Get Excel: http://bit.ly/office365varios

Sign up: http://bit.ly/youtubemplanilhas

0:00 - Welcome
05:55 - What is Dashboard
07:55 - Dashboard Planning
11:00 - Start of Class - Database
12:00 - Creating the PivotTable
31:48 - Object Property Tips for not moving and scaling with cells
33:10 - Dimension Cell Width and Height (Tip)
37:00 - Start of Dashboard Creation
42:30 - Insert Icons in Excel 2016
50:35 - Sort Pivot Table
51:00 - Create PivotChart
54:25 - Save Chart as Template
55:30 - Apply Chart Template
01:05:23 - Group PivotTable
01:34:44 - Standard PivotTable Configuration
01:25:25 - Data Segmentation
01:29:25 - Report Connections - Update the entire Dashboard
02:01:19 - Credits to all supporters

Full Version Link: http://bit.ly/dashboardrhcompleto

In this Webinar you will learn how to create an HR dashboard in Excel from scratch

See the Playlists:

Charts in Excel: http://bit.ly/graficosexcel
Power BI: http://bit.ly/listpowerbi
Maps in Excel: http://bit.ly/mapasexcel
Power Query: http://bit.ly/powerqueryexcel
Free Excel Course: http://bit.ly/cursoexcelfree

See also:
Website: http://www.minhasplanilhas.com.br
Virtual Store: https: //lojavirtual.minhasplanilhas.c ...
Course Portal: http://cursos.minhasplanilhas.com.br
Facebook:   / minhasplanilhasbr
Instagram:   / mplanilhas
Linkedin:   / gersonggv
E-mail: [email protected]

Book Tips:

Information Dashboard Design - Stephen Few
Link: http://bit.ly/dashboardstephenfew

Data at Work - Jorge Camoes
Link: http: //bit.ly/jorgecamoesdataatwork

Excel from A to XFD - Karine Lago
Link: http://bit.ly/exceldeaatexfd

Storytelling with data - Cole Nussbaumer Knaflic Link: http://bit.ly/storytellingcomdados

Power BI Book - Laennder Alves and Karine Lago
Link: https://livropowerbi.com.br/

#cursodeexceloficial
#cursodeexcel
#dashboard
#excel
#microsoftexcel
#auladeexcel
#dashboardnoexcel
#cursodeexcelonline