Microsoft Excel: Data Visualization, Excel Charts & Graphs

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

Master 20+ Excel charts, build advanced Excel visuals & learn data analysis with a best-selling Excel instructor!

01 - Getting Started

001 Course Structure & Outline

002 READ ME Important Notes for New Students.html

003 DOWNLOAD Course Resources.html

003 Data-Viz-Demo-Workbooks.zip

003 Data-Viz-Homework-Workbooks.zip

003 Excel-Data-Visualization.pdf

003 thermometer.zip

003 thumbsup.zip

004 Setting Expectations

02 - Data Visualization Best Practices

001 Key Visualization Principles & The 10-Second Rule

002 Good, Bad & Ugly Data Viz

003 3 Key Questions for Effective Visualization

03 - Excel Chart Formatting & Customization

001 Customizing Chart Elements, Layouts & Styles

002 Configuring Chart Formats

003 Changing Chart Types & Adding a Secondary Axis

004 Creating & Applying Custom Chart Templates

04 - Mastering Basic Excel Charts & Graphs

001 DEMO Excel Bar & Columns Charts

002 HOMEWORK Bar & Column Charts.html

003 DEMO Excel Histograms & Pareto Charts (Office 365Excel 2016+)

004 HOMEWORK Histograms & Pareto Charts.html

005 DEMO Excel Line Charts & Trendlines

006 HOMEWORK Line Charts & Trendlines.html

007 DEMO Excel Area Charts

008 HOMEWORK Area Charts.html

009 DEMO Excel Pie Charts, Donuts & Race Tracks

010 HOMEWORK Pies, Donuts & Race Tracks.html

011 DEMO Excel Scatter Plots

012 DEMO Excel Bubble Charts

013 HOMEWORK Scatter Plots & Bubble Charts.html

014 DEMO Excel Box & Whisker Charts (Office 365Excel 2016+)

015 HOMEWORK Box & Whisker Charts.html

016 DEMO Excel Tree Maps & Sunburst Charts (Office 365Excel 2016+)

017 HOMEWORK Tree Maps & Sunburst Charts.html

018 DEMO Excel Waterfall Charts (Office 365Excel 2016+)

019 DEMO Excel Funnel Charts (Office 365Excel 2016+)

020 HOMEWORK Waterfall & Funnel Charts.html

021 DEMO Excel Radar Charts

022 HOMEWORK Radar Charts.html

023 DEMO Excel Stock Charts

024 HOMEWORK Stock Charts.html

025 DEMO Excel Heat Maps with Conditional Formatting

026 HOMEWORK Heat Maps.html

027 DEMO Excel Surface & 3D Contour Charts

028 HOMEWORK Surface & Contour Charts.html

029 DEMO Geo-Spatial Mapping with Excel Power Map

030 HOMEWORK Power Map.html

031 DEMO Common Excel Combo Charts

032 HOMEWORK Combo Charts.html

033 DEMO Excel Sparklines

034 HOMEWORK Sparklines.html

05 - Next-Level Demos

001 Setting Expectations

002 DEMO Creating Custom Image Overlay Charts

003 DEMO Using Binary Values to Highlight Time Periods

004 DEMO Automating Charts with Named Ranges (OFFSET & COUNTA)

005 DEMO Adding Scroll & Zoom Functionality Using Form Controls

006 DEMO Creating Interactive Area Charts to Show Changes Over Time

007 DEMO Building a Dynamic Excel Dashboard (Part 1)

008 DEMO Building a Dynamic Excel Dashboard (Part 2)

009 DEMO Dynamic Chart Formatting Based on Values

010 DEMO Dynamically Highlighting Segments of Data

011 DEMO Building a Custom Excel Pacing Chart

012 DEMO Designing a Custom Excel Gauge Chart

013 DEMO Visualizing Percentages Using Array Functions

06 - Wrapping Up

001 BONUS LESSON.html

45,900 تومان

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

خرید دانلودی فوری

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

تولید کننده: Udemy