Financial Statistics Dashboards System | Dynamic Excel Map Chart

Financial Statistics Dashboards System | Dynamic Excel Map Chart | Tutorial 2

Рет қаралды 152,016

Күн бұрын

Download our Templates / Get Free Datasets
Visit our online store www.other-levels.com
To watch the full Tutorials? Join our channel Membership
/ @otherlevels
Hire our team to join your company
other-levels.com/products/hir...
Request a Custom Dashboard
other-levels.com/pages/custom...
Contact us for business:
Comment down below
Customer services www.other-levels.com
0:00, Dashboards Overview
0:48, Sales percentage by countries
3:42, Sales grand total amount
4:51, Yearly Slicer
5:33, Sales by countries Bar Chart
9:07, Dynamic Doughnut chart with rounded edges
14:20, Dynamic Map Chart
33:09, Taxes Analisys
Tutorial 1 • Is This Microsoft Exce...
Tutorial 3 • Dynamic MS Excel Sales...
All our videos / otherlevel’s
Subtitles are available in 14 Languages, Spanish, Hindi, Arabic, Japanese, Filipino, Chinese, English, Indonesia, French, Korian, Russian, Urdo, Bengali, and Portuguese.
Playlists
Multiple Dynamic Excel Dashboards
• Multiple Dynamic Excel...
Single Dynamic Excel Dashboard
• Single Dynamic Excel D...
Modern Excel Reports
• Modern Excel Reports
PowerPoint Slides Playlist
• PowerPoint Slide's
Copyright © 2024 Other Level's. All rights reserved.
"Any illegal reproduction of this content in any form will result in immediate action against the person concerned."
#Financial_Statistics_Dashboards_System #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

Пікірлер: 118

@christianlira1259 11 ай бұрын

Complete mind reconneting to a whole new network. I am amazed by the intelligence of the developer person here in producing from a single 'platfform', some of the most advanced visualizations created from zero to great. Thank you for your open knowledge sharing. Much appreciated.

@exceltestnumber1 2 жыл бұрын

I thought you used tons of formulas o create this, but really i surprised of this simplicity...BEST KZfaq CHANNEL EVER

@OtherLevels 2 жыл бұрын

You got our goal Antonio, Much Appreciate bro

@haiodaalbardee5666 2 жыл бұрын

OMG, How you can even think on this way !! ❤️ GOD Bless you all

@tedjlegrand Жыл бұрын

The best looking excels dahsboards I have seen on KZfaq..! ANd you share a complete tutorial, Thanks, I learn a lot with you

@OtherLevels Жыл бұрын

Glad to hear that, Thank you Tadh ❤

@jsaint51 2 жыл бұрын

...continued from part 1... this is really good. I'm hooked on this one. Tons of fun following along in Excel. The Map is brilliant. On to part 3!

@MrSagar93 2 жыл бұрын

Absolutely Beautiful and Mind Blowing skill. Never came across such a person who is great at data also has creative appeal !! Fantastic work keep growing 💓

@Augusto64012 2 жыл бұрын

Start releasing the database as well. That way we can follow you more perfectly. Thank you for providing so much knowledge with your videos! 🇧🇷

@Devi1D0g04 2 жыл бұрын

When I tell you this just made me so happy I been waiting for this video since I saw your 1st. Super excited to finish

@homayoonsarwari5375 2 жыл бұрын

That's really intuitive and I really loved the work. Keep up the great work

@s71.37 2 жыл бұрын

My prof said to me once that Data visualization is an art, I was not convinced until I saw your channel

@OtherLevels 2 жыл бұрын

Thank you very much, we appreciate that

@OoDiyaaoO 2 жыл бұрын

Amazing work!!! Never stop creating these outstanding designs and ideas PLEASE

@OtherLevels 2 жыл бұрын

Thank you very much and glad you liked the content

@NaJMStudio 2 жыл бұрын

You are one of my favorite teacher. Amazing work sir really appreciate your work and waiting for next tutorial.

@OtherLevels 2 жыл бұрын

Thank you very much Najm, our pleasure

@ahmedelboghdadi5328 2 жыл бұрын

This is just amazing! I wonder how many videos are remaining for the whole set to videos to be available including the animations. Keep up the great work! On behalf of the whole world, thank you so much for sharing 💛💛

@OtherLevels 2 жыл бұрын

Thank you very much Ahmed, We appreciate that, video are available kzfaq.info/get/bejne/fNtzY7mQ07G1h2w.html

@zhen1470 Жыл бұрын

@@OtherLevels what version of excel you are using ????can you tell me thanks

@RovyDigitalArt 2 жыл бұрын

Excel MASTERS 👍 i think we dont need any more to go for Power BI or any software

@OtherLevels Жыл бұрын

Thank You Rovan

@roviskyksa5050 2 жыл бұрын

definitely this is an outstanding work with small formula you are doing amazing things, you are a Wonderful ❤

@OtherLevels 2 жыл бұрын

Glad you like it, Enjoy dear

@ayael 2 жыл бұрын

Lv. Other level's - Welcome bois. Lv. Beyond imagination Lv. Next level aliens Lv. Pure Art Lv. Pro Lv. Expert Lv. Intermediate Lv. Basic

@featheredserpentofthewest2049 2 жыл бұрын

Absolutely brilliant! Amazing!

@OtherLevels 2 жыл бұрын

Thank you very much ,Glad you liked it

@paulguitard7363 2 жыл бұрын

Amazing work!

@pralhadshetye8863 2 жыл бұрын

You are a creative genius.

@OtherLevels 2 жыл бұрын

Thanks Pralhad, we appreciate that

@lovnishkumar5803 Жыл бұрын

Mind blowing dashboard great work i really appreciated your hard work and efforts.

@OtherLevels Жыл бұрын

It's my pleasure

@mdhossen7082 Жыл бұрын

wow, boss, This Video is very very helpful, Thanks

@OtherLevels Жыл бұрын

Much welcome dear

@linhnguy3n Жыл бұрын

Such a brilliant creator! I can't believe that one day excel could turn into piece of art. Really appreciate your kindness to share the tutorial for me. Keep move on and make more video for us to learn!

@OtherLevels Жыл бұрын

Thank you very much ,Glad you like our content

@cristianluisteixeirafrc8435 2 жыл бұрын

We really have to be very careful with the current fashion of new technologies, we have to be careful not to keep changing tools all the time. This fantastic video clearly shows how valuable it is to specialize and master a tool. Congratulations

@ricob7023 2 ай бұрын

kudos to "dynamic dots on map"-solution!

@downloadmx5318 2 жыл бұрын

Simply beautiful

@OtherLevels 2 жыл бұрын

Thanks enjoy

@jeffthechristian3010 2 жыл бұрын

This is magical.

@OtherLevels 2 жыл бұрын

Thank you very much

@shajupauljohn3244 2 жыл бұрын

Excellent presentation

@OtherLevels 2 жыл бұрын

Thank you shaju , Glad you liked it

@Amathylar Жыл бұрын

This is awesome!

@OtherLevels Жыл бұрын

You are the best ❤️ thank you Amathylar

@MrHenk588 2 жыл бұрын

Very amazing work! Just triggered me that the UK is right on Latvia haha, haters gonna hate :p

@OtherLevels 2 жыл бұрын

Thank you very much, we appreciate that

@theloniousmonk81 2 жыл бұрын

YOU ARE THE BEST

@OtherLevels 2 жыл бұрын

Thank you very much Juan

@juarezr61274 2 жыл бұрын

Amazing!

@OtherLevels 2 жыл бұрын

Glad you liked it

@twotallsocks 2 жыл бұрын

Great dashboards. Do you have any tips on multiple users using these? Do they work with Excel Online? Can they be used by multiple people on a network shared folder with Excel? That's the kind of limitations I've run into before which make it less useful.

@TottiXful 2 жыл бұрын

Stunning job. Can you please creat a dashboard for actual expenditure vs. Budget. In terms of department division and unit expenditure compared to planned budget 🤗 Also a business plan. Thanks

@OtherLevels 2 жыл бұрын

Thank you very much, it's great idea we will do it soon

@DLMORALES1205 2 жыл бұрын

Tutorial 3,4,5..... please!!!!!

@CherryKolla 2 жыл бұрын

Thanks for your videos. Can you create a dashboard for a delivery company?

@relax_your_mind_Nature_8944 2 жыл бұрын

Amazing

@OtherLevels 2 жыл бұрын

Thank you very much

@lmy1314 2 жыл бұрын

Your videos are very helpful to me. Could you please share that SVG? I made it according to your video, except for the SVG, the other operations are the same; but if I do the dots, I can't do it (after finishing a country, the dots will not automatically change after the year is changed) I don't know if it is SVG problem or pivot table sorting problem.

@adityamathur2724 27 күн бұрын

Hey man great vid but i cant seem to get the dots to change color in the map i followed everything but its not happening

@ycaroovoador7744 2 жыл бұрын

👍👍👍👍👍👍

@Nick_88888 2 жыл бұрын

What function do the SIN & COS functions serve ?

@dhanashreedahiphale266 Жыл бұрын

please make more videos on power bi dashboard

@lachlanyoung6403 2 жыл бұрын

hey, i was looking to make an excel spreadsheet, where it looks fancy. My main goal is to have a spreadsheet where it keeps track of many different types of statistics from all players in a sport team after each game, and even get it to automatically update from an external website if that’s possible? is there any of your videos that could best help me? thank you

@dmitriykutyrev8597 2 жыл бұрын

@Other Level’s Hello. Thank you for your videos on the channel. I want to ask you a question, I hope you can help! 1. Do you use other data visualization tools? 2. Where do you get inspiration from to create such wonderful works? 3. Can you recommend websites / books / articles where you can get acquainted? Thank you for your reply, work and your channel.

@gilbert2186 2 жыл бұрын

Do we need to purchase a template in order to fully follow along step by step with this video?

@ashleeherrington2643 2 жыл бұрын

is there a recommendation how to do the map chart if you cannot convert the shape in powerpoint? thank you!

@umarilyas8583 2 жыл бұрын

Just create dot map manually with circle shapes, it becomes more flexible. Just use another map as an outline and just go around it. Worked for me that way, didnt have the convert to shape feature button un-greying.

@sonamchopel3087 2 жыл бұрын

Please, can this dashboard be made online for multiple user and real-time viewing?

@havesomemana1442 2 жыл бұрын

I cant say except (wow)

@OtherLevels 2 жыл бұрын

Thank you very much dear

@pierrezanetti3283 Жыл бұрын

Hi, do you know where we can found the data tables used to make the dashboard ? Thanks for your help !

@OtherLevels Жыл бұрын

you are welcome Kindly visit our website to get the datasets for training and practicing www.other-levels.com/blogs/datasets

@pierrezanetti3283 Жыл бұрын

@@OtherLevels Thank you !

@hiagosilvaribeiro3096 2 жыл бұрын

Pls, do something about saty of work (segurança do trabalho). There's nothing on the internet. One that we can (acompanhar os exames periódicos), admissionais e demissionais . Acidentes acontecidos no trabalho, e o gráfico mostrar um corpo, e os números na parte do corpo afetada. Algo desse tipo

@yuvrajdhiman2770 2 жыл бұрын

Please share your data set as well while uploading these videos... we can use the same data set while practicing through your video

@OtherLevels 2 жыл бұрын

Please visit our website www.other-levels.com you will find the dataset

@afonsoribeiro3564 Жыл бұрын

Hey man great content but pls allow Visa card on your website and not just paypal

@OtherLevels Жыл бұрын

Please chat with us on our website to get credit card payment method www.other-levels.com

@SudaisKhadim Ай бұрын

can you give download to that world picture?

@Beatboxil968 2 жыл бұрын

Hi, how to create shape from picture in powerpoint?

@DhikrullahiOlamilekan 24 күн бұрын

Please I can't find the dataset for the part two

@pedrocoelho9999 Жыл бұрын

Olá! Primeiramente tens um excelente trabalho! Na hora de copiar as bolinhas, quando altero as datas algumas nao puxam a cor correta😢

@OtherLevels Жыл бұрын

Quer dizer que a cor não aparece ou os pontos mudam de cor diferente da que você escolheu?

@amirhamzakhan4977 Жыл бұрын

can you share your data set you had used in this vedio.

@OtherLevels Жыл бұрын

Kindly visit our website to get the datasets for training and practicing,It will be available ASAP for this template: www.other-levels.com/blogs/datasets

@jamespyle6398 Жыл бұрын

hen I change the color of the map in PP it doesn't change, and there is no convert to shapes button. Does this only work in later versions? I am on 2016.

@OtherLevels Жыл бұрын

It's supposed to work in all PP versions

@ManishKumar-ht6gm 2 жыл бұрын

Why are u creating a new table with vlookup when you can just refer to the pivot table cell?

@gamercod3520 2 жыл бұрын

How many parts will this tutorial be?

@EvgenNik 4 ай бұрын

Ссылки по плейлистам больше не доступны!

@vishyr9578 Жыл бұрын

What if the pivot tables has more than 6 rows. ?

@OtherLevels Жыл бұрын

For questions about this dashboard? Join our channel Membership kzfaq.info/love/uDF09RGFE3V3lY77Z_cA9gjoin

@adarshkaushal3867 Жыл бұрын

At 14:52 unable to change mao color and convert into shapes? Any idea what to do?

@RishabGarg-ii5mf 5 ай бұрын

Same problem

@AskApt05 4 ай бұрын

You can get a .jpg, convert to .svg ( online tolls are available), paste this svg file to power point & convert to shape. Worked for me.

@hiranwasalaarachchi6320 2 жыл бұрын

what is the version of excel that you are using?

@OtherLevels 2 жыл бұрын

Microsoft Office 365 , Enjoy

@AhmedMohammed-oq6tw 2 жыл бұрын

I want to Kiss your HEAD, you are a Genius 🤩

@vrushikasinghania6385 2 жыл бұрын

Hi, Could you share where can I get the raw excel data set used for this project?

@OtherLevels 2 жыл бұрын

Please visit our website www.other-levels.com

@vrushikasinghania6385 2 жыл бұрын

@@OtherLevels hi, thanks for replying, the excel on the website is processed data right, I wanted raw, unprocessed data. If possible please share where can I access it from. TIA.