دورة من ONLEARN
Excel for Storytellers: Visualizing Your Data Narrative
Transform raw numbers into impactful stories. Learn advanced charting, infographic techniques, and dashboard design to communicate insights with clarity and persuasion.
متوسطEnglish3 أقسام4.5 ساعة485 متعلّماً
ما ستتمكّن من فعله
- Design and implement advanced chart types beyond standard bar and pie charts.
- Utilize conditional formatting effectively to highlight key data points and trends.
- Construct interactive dashboards using slicers, timelines, and form controls.
- Apply data storytelling principles to create clear, impactful data visualizations.
- Clean and prepare data for effective visualization and analysis.
- Optimize chart design for clarity, conciseness, and audience engagement.
داخل هذه الدورة
3 أقسام · 15 نشاطاً · 4.5 ساعة إجمالاً
01Module 1: Foundations of Data Storytelling & Advanced Charting
- Introduction to Data Storytelling with Excel10:00
- Data Preparation for Visualization15:00
- Mastering Combination Charts20:00
- Sparklines and Data Bars: In-Cell Visuals15:00
- Hands-on: Creating Advanced Chart Combinations30:00
02Module 2: Dynamic Visualizations & Interactive Dashboards
- Unlocking Conditional Formatting's Potential20:00
- Introduction to Dashboard Design Principles15:00
- Building Interactive Controls: Slicers and Timelines25:00
- Leveraging Form Controls for User Interaction20:00
- Hands-on: Constructing an Interactive Dashboard40:00
03Module 3: Telling Your Story & Sharing Insights
- Crafting a Clear Data Narrative15:00
- Effective Chart Annotation and Labeling10:00
- Exporting and Sharing Your Visualizations10:00
- Course Wrap-up and Next Steps5:00
- Quiz: Data Storytelling and Visualization Principles10:00
عن هذه الدورة
Transform raw Excel data into compelling visual narratives. This course empowers you to move beyond basic charts, crafting impactful stories that resonate with your audience.
لمن هذه الدورة
- Analysts, managers, and professionals who need to present data clearly and persuasively.
- Anyone looking to move beyond basic Excel charts and create impactful visualizations.
- Students and researchers who want to improve their data communication skills.
- Individuals who regularly create reports and presentations involving data.
- Excel users seeking to build interactive dashboards.
قبل أن تبدأ
- Microsoft Excel 2016, 2019, or Microsoft 365 (desktop version) installed.
- Basic familiarity with Excel functions and navigation.
- A computer with internet access.
- Desire to transform data into compelling stories.
تجارب التعلّم
317 تقييماًتقييمات المتعلّمين
4.3 / 5 · متوسط تقييم المتعلّمين
تفاصيل مفيدة
كيف سأتعلّم؟
تابع أقسام الدورة وأنشطتها في مشغّل الدورات على Onlearn بالوتيرة التي تناسبك. يُحفظ تقدّمك في حسابك.
هل هذا اشتراك؟
لا. تُشترى كل دورة بشكل منفرد بدفعة واحدة.