free download“>



نمودارهای شگفت انگیز اکسل را در چند ثانیه با الگوهای نمودار از پیش تعیین شده یکپارچه ما ایجاد کنید. نمودارهای 180+ ، 6 سبک مختلف ، 15+ نمودار پویاتر با کتاب کارشناسی ارشد نمودارهای پیشرفته ما.

اکنون بارگیری کن:

بیاموزید که چگونه یک داشبورد مدرن و پویا را در ابتدا از Excel ایجاد کنید ، بدون هیچ VBA / Macros یا Add In-s.

با ساختن این داشبورد هزینه سفر ، ما نشان خواهیم داد که هنگام ایجاد یک داشبورد در اکسل ، چه اصول اصلی و بهترین کارها وجود دارد.

از ابزارهای تجسم زیر استفاده می شود:

➤ نمودارهای واقعی در مقابل بودجه
Ch نمودار پیشرفت
➤ نمودارهای پیراشکی
➤ لیست کنترل جعبه فرم
➤ نمودار محوری

همه با قالب بندی شرطی پویا.

➤ اگر این فیلم را مفید یافتید ، لطفاً ، اشتراک گذاری و اشتراک را دوست داشته ، اشتراک گذاری کنید!

به داشبورد و نمودارهای شگفت انگیز اکسل نیاز دارید؟ ما شما را تحت پوشش قرار داده ایم!
ما می توانیم از طریق به روزرسانی تجسمات صفحه گسترده خود یا ایجاد جدید ، براساس داده های شما از ابتدا ، از شما پشتیبانی کنیم! برای اطلاعات بیشتر ، به صفحه خدمات ما مراجعه کنید:

مطمئن شوید که از الگوهای برتر Excel ما دیدن کرده اید:

این داشبورد را به صورت رایگان در وب سایت ما بارگیری کنید:

ما را دنبال در:
➤ فیس بوک:
➤ لینکدین:

مدرن و حرفه ای. بدون ماکرو. کاملاً باز شده است.

لینک دانلود

45 پاسخ به “نحوه ایجاد داشبورد مدرن و پویا در اکسل | دانلود رایگان”

  1. Simply Awesome. I am preparing dashboards on excel but very hard always. Today I got really very easy way. God always bless you with great health and wealth to share your knowledge free. Amazing

  2. I really enjoyed this video. You must be an avid Excel user in order to follow along, but that is why I enjoyed it so much. You did a lot of work creating this dashboard, but because you were very focused and striaght forward you were able to demonstrate a fair amount of advanced technics in only 30 minutes. Thanks!

  3. How to make a dynamic chart a Project,
    For a details like below mentioned,
    Frenchaise group – A and B
    Resource Name – A B C D E F
    Role – Designer and Analyst
    Date – 15-Dec-2019
    Week # 50
    Technical Files – M, N, P, Q, R, S or Apple or Samsung or Google or Microsoft
    Task – select drop down menu items
    Components of Task – select drop down menu
    Task in details – Details of task more words so that easy to understand work.
    PerDay hours available – 8.50 hours (standard time)
    PerDay spent hours – 7.5hours
    (Same day different task can be performed to show for different task, so add new row with same date, but Actual task hours can be variable)
    —————————————————-
    This chart aim is to understand the Time spent of each Technical Files and % of Utilisation with Standard time.
    Individuals Time spent for each group.
    Pls let me know how to create Dashboard for it. Thanks.

  4. Amazing, and thank you very much for making this available for a free download. Two very minor points: Accommodation is missing its second "m" and you have incorrectly spelled Premium

  5. one single suggestion: use conditional formatting for those donut charts. using conditional formatting makes the charts dynamic without the need to format 50 different charts.
    other than that, nice video, good ideas and inspiration.
    keep up the good work.

  6. Nice Video, Thanks for sharing, I have one question in bar chart for actual and budget if achievement is more than 100% how it show (I am talking about Chart starting after 16 min Video

  7. Hello Pinexl, i tried until sumif on Total budget and actual amount when the total amount is okay but when change to monthly, it turn "false" Can you please give me the solution?

  8. Superb, Actually I am also trying with same kind but in case of Month putting @Month in Cell reference Eg. SUMIF(Table2[Month],[@Month],Table2[Amount]) getting errors for @Month. Could you please help me?

  9. Superb Sir,
    Even I also prepare dashboards but never thought in this way.
    Truly marvellous not words to say
    Once again Thank you for sharing a wonderful idea & knowledge.

  10. Fantastic work. Really helpful and spot on. All for free. You, sir, are awesome. Subscribed and will share with my network. People like you need more recognition! 🙂

  11. this is a great way to learn, i wish to congratulate you for really showing your talent and teaching various people the really way on working on analyses, but a small request ..please go a bit slow as the formulas are very important to be known i hope am personally going to spending some time on your teachings as this is a very important part of my analyses job… thank you mate …

  12. This is really worth for those who work in Excel, Data analysis. I had worked with BI applications and developed a plethora of dashboards however never thought about Excel. Your video inspires me a lot and will definitely jump into Excel dashboarding. I'm expecting useful videos from you in future. As a request, do some predictive analysis, forecasting, planning and budgeting.

    Thanks

نظرات بسته شده اند.