وب سایت تخصصی شرکت فرین
دسته بندی دوره ها

Excel: Charts and Graphs In Depth

سرفصل های دوره

Excel charts allow you to communicate information with much more impact than raw numbers and are surprisingly easy to generate. In this course, Microsoft MVP Jordan Goldmeier shows you how to create different kinds of Excel charts, from familiar column, bar, line, and pie charts to more recently introduced types like Treemap, Funnel, and Pareto. He explains what types of data work best with each, so you can decide which type to choose for your specific information. Plus, Jordan goes over how to fine-tune your chart's color and style; add titles, labels, and legends; insert shapes, pictures, and text boxes; and pull data from multiple sources.


01 - Introduction
  • 01 - Getting more from your data with charts

  • 02 - 1. Chart Basics What You Need to Know
  • 01 - An overview of chart types
  • 02 - Getting started Laying out the data
  • 03 - Creating and editing your chart
  • 04 - The elements of an Excel chart
  • 05 - Quirks of Excel charts
  • 06 - Essential chart hacks to make your life easier

  • 03 - 2. Zen and the Art of Chart Maintenance
  • 01 - Why chart maintenance is important
  • 02 - Effective chart titles and legends
  • 03 - Managing your source data
  • 04 - Template options and color choices

  • 04 - 3. Modify Chart Elements and Details
  • 01 - Set chart axes++
  • 02 - Chart and axes titles
  • 03 - Add and edit data labels
  • 04 - Add basic interactivity
  • 05 - Adjusting gridlines
  • 06 - Trendlines

  • 05 - 4. The Excel Chart Library
  • 01 - Column and bar charts
  • 02 - Pie charts and doughnut charts
  • 03 - Line and area charts
  • 04 - Scatter plots
  • 05 - Bubble charts
  • 06 - Radar charts
  • 07 - Stock charts
  • 08 - Sunburst charts and treemap charts
  • 09 - Histogram chart
  • 10 - Box and whisker chart
  • 11 - Pareto chart
  • 12 - Waterfall and funnel charts
  • 13 - Map charts based on geographic data

  • 06 - 5. Advanced Chart Techniques
  • 01 - Pivot charts
  • 02 - Slicers and Timelines
  • 03 - Cross filtering with the Excel Data Model
  • 04 - Conditional formatting in charts
  • 05 - Using linked pictures
  • 06 - Aligning chart elements
  • 07 - Sparklines and heat maps
  • 08 - Font charts

  • 07 - 6. Data Visualization Rules
  • 01 - Do more with less
  • 02 - Format for clarity
  • 03 - Using color to make a point
  • 04 - Use data visualization principles
  • 05 - Consider the audience

  • 08 - Conclusion
  • 01 - Where to learn more about Excel charts and graphs
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

    در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

    ایمیل شما:
    تولید کننده:
    مدرس:
    شناسه: 34481
    حجم: 298 مگابایت
    مدت زمان: 132 دقیقه
    تاریخ انتشار: 10 مرداد 1403
    دسته بندی محصول
    طراحی سایت و خدمات سئو

    139,000 تومان
    افزودن به سبد خرید