How to build Dynamic & Interactive Dashboard in EXCEL with PivotTable & Charts | Tutorial Episode #2

Full Tutorial with voice over explanation:

Download our Templates / Get Free Datasets

Hire our team to join your company

Request a Custom Dashboard

To watch the full Tutorials? Join our channel Membership

Contact us for business:
Comment down below


Playlists

Copyright © 2024 Other Level's. All rights reserved.

#Excel #Dashboard # excel_dashboard
-------------
#create_dashboard_in_excel #dash_board #dashboard #dashboard_design #dashboard_design_in_excel #dashboard_en_excel #dashboard_excel #dashboard_excel_pivot_table #dashboard_excel_tutorial #dashboard_in_excel #dashboard_powerpoint #dashboards #dashboards_in_excel #dynamic_dashboard #dynamic_dashboard_in_excel #dynamic_excel_dashboard #excel #excel_dashboard #excel_dashboard_design #excel_dashboard_design_ideas #excel_dashboard_for_beginners #excel_dashboard_templates #excel_dashboard_tutorial #excel_dashboards #excel_dashboards_and_reports #excel_design #excel_dynamic_dashboard #excel_interactive_dashboard #excel_report_design #excel_reports_and_dashboards #financial_dashboard_excel #how_to_build_interactive_excel_dashboards #how_to_create_a_dashboard_in_excel #how_to_create_dashboard_in_excel #how_to_make_dashboard_in_excel #hr_dashboard_excel #interactive_dashboard #interactive_dashboard_in_excel #interactive_excel_dashboard #kpi_dashboard_in_excel #organization_chart_powerpoint #other_level #performance_dashboard_in_excel #pivot_table_dashboard #powerpoint_dashboard #project_dashboard_excel #project_management_dashboard #sales_dashboard_in_excel #дашборд_excel #داشبورد #لوحة_على_إكسسيل #لوحة_اكسيل #المبيعات_لوحة_في_إكسسل #المبيعات_لوحة_القيادة #مبيعات_تحليل #مستويات_أخرى #계기반 #뛰어나다 #엑셀_대시_보드 #Excelisfun #excel_on_fire #MyOnlineTrainingHub #The_office_lab #엑셀_대시보드 #vba_excel #sales_dashboard #sales_analytics #performance_dashboard #other_levels #kpi_dashboard #hr_dashboard #financial_dashboard #dashboards_excel #dashbord #dashboard_on_excel #dash_board_in_excel #dash_board_excel #Multiple_Dynamic_Excel_Dashboards #Uploads_from_Other_Levels #TopSaved #Single_Dynamic_Excel_Dashboard #PowerPoint_UIUX_Templates #PowerPoint_Templates #PowerPoint_Slides #PowerPoint_Dashboards #Popular_uploads #Organizational_Structure_Charts #Modern_Excel_Reports #Mix_Presentation #Islamic_PowerPoint_Templates #G_Excel #EXCEL_videos #Data_Analysis_by_PowerPoint #CV_Resume_Templates

[haiodaalbardee]

Awesome, Wonderful. Waiting for these tutorials

[myhoang]

this is amazing! I'm so glad I found your channel and tutorials

[palanik]

Amazing. Eagerly waiting for #3 Tutorial.

[uncleelder]

Great tutorials. Quick question - I missed something between Tutorial #1 and Tutorial#2... How did you create the slicers on the left? They weren't there in Tutorial #1, and you never showed how they were made in #2.

[cassioalexan]

Amazing dashboard. However, I miss some kind of music playing or someone narrating the procedures while they're being shown...

[joemartin]

This episode skips over adding the Slicer and only how to change its' format. I was curious as to how you linked the data so that your Sunburst Chart data was filtered based on what you selected in the Slicer.

[acaciakulitcanary]

Great video! Just to comment on the calc sheet: it would be also dynamic if you can create a table, maybe using the =UNIQUE formula and create a =SUMIFS. Possibly there will be an another update, for example, one closed project for E2E. The source table under E2E is current so if there will be added data for closed or cancelled, it will be missed.

[benoitdelecroix]

Please How to make the inverted triangle move in the P&L ??

[chrisTv-]

Hello please how did you add the slicer to the sunburst chart ? Thanks

[hisyambinzainal]

for the sunburst chart, if the original source data or pivot data changed, then we need to update manually again is it?

[usernameavailable]

The part between 5:14 and 9:20 where you make another (pivot) table and manually get the value for each item with GETPIVOTDATA could've been solved with a few clicks in a pivot table by repeating item labels and showing items with no data in pivot table field settings. But otherwise, great video!

[zl]

Can I build this dashboard on Google Sheet?

[kingsleyokoeguale]

Having audio on this video would make it superb.

[austinpor]

How to make the inverted triangle move in the P&L %?

[sunilbamel]

Hello
Can you please give the resource file
Please

[jackiechen]

hey buddy, can i have the raw data for practice？

[junianbalancio]

Can you share the color combination in our chart?

[chieuta]

How do you display the Project Details in the same worksheet?

[hardikpokiya]

Why there’s no sound? I cannot hear anything on this video

[amittripathi]

How was 00:19 to 00:24 was achieved? if anyone can help?