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

Excel and PowerPoint: Creating High-Impact Financial Presentations

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

Find out how you can create high-impact, data-rich financial presentations using Excel and PowerPoint. In this course, Microsoft MVP and Financial Modelling Specialist Danielle Stein Fairhurst guides you through creating financial presentations that are compelling, easy to understand, and—best of all—easy to update. Get started with an example spreadsheet featuring typical finance data. Learn how to use conditional formatting to highlight important information, PivotTables to summarize data, and sparklines and charts to create illustrations. Explore several different methods—including copying and pasting, linking, and embedding—to import your work into PowerPoint. Plus, learn how to use PowerPoint animation features to animate Excel charts and tables and focus the viewer's attention.


01 - Introduction
  • 01 - Creating compelling finance presentations
  • 02 - What to know before starting

  • 02 - 1. Presenting Financial Data
  • 01 - How financial and nonfinancial data differs in Excel
  • 02 - Communicating finance concepts to your audience
  • 03 - Tools for preparing and presenting financial data
  • 04 - Choosing between Excel and PowerPoint for presentations
  • 05 - Choosing a chart or a table
  • 06 - Selecting the right chart to communicate your message

  • 03 - 2. Cleaning Up Excel Data for Finance Presentations
  • 01 - Charting with tables
  • 02 - Summarizing data with PivotTables
  • 03 - Charting with Pivots
  • 04 - Cleaning up data with Power Query
  • 05 - Manipulating data with unpivot in Power Query

  • 04 - 3. Dynamic Charting with Formulas and Pivots
  • 01 - Building charts based on formulas vs. PivotCharts
  • 02 - Making charts dynamic with dynamic arrays and named ranges
  • 03 - Slicing and filtering data for presentations
  • 04 - Deciding between formulas and PivotCharts

  • 05 - 4. Building Excel Charts for Presentations
  • 01 - Comparing data with a combo chart on two axes
  • 02 - Show changes over time with a waterfall chart
  • 03 - Tracking progress with a Gantt chart
  • 04 - Showing data distribution with a histogram
  • 05 - Displaying model sensitivities with a tornado chart

  • 06 - 5. Crafting Graphics for Presentations
  • 01 - Illustrating trends with sparklines
  • 02 - Mapping geospatial data
  • 03 - Adding images and icons in Excel
  • 04 - Adding emojis in Excel

  • 07 - 6. Communicate Your Message with Conditional Formatting
  • 01 - Adding meaning to tables with color scales
  • 02 - Finding and drawing attention to anomalies
  • 03 - Giving numbers meaning with data bars
  • 04 - Creating a heatmap with color scales
  • 05 - Creating an actual vs. budget variance report

  • 08 - 7. Getting Excel Content into PowerPoint
  • 01 - Applying Office themes in PowerPoint
  • 02 - Options for copying and pasting from Excel
  • 03 - Linking and embedding visuals from Excel
  • 04 - Creating charts and tables natively in PowerPoint
  • 05 - Adding a Power BI report into PowerPoint

  • 09 - 8. Finalizing Your PowerPoint Presentation
  • 01 - Pasting Excel content into PowerPoint
  • 02 - Using the PowerPoint Designer
  • 03 - Animating a chart
  • 04 - Animating a table
  • 05 - Sharing your finalized presentation

  • 10 - Conclusion
  • 01 - Next steps
  • 139,000 تومان
    بیش از یک محصول به صورت دانلودی میخواهید؟ محصول را به سبد خرید اضافه کنید.
    خرید دانلودی فوری

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

    ایمیل شما:
    تولید کننده:
    شناسه: 39697
    حجم: 320 مگابایت
    مدت زمان: 127 دقیقه
    تاریخ انتشار: 22 مرداد 1403
    دیگر آموزش های این مدرس
    طراحی سایت و خدمات سئو

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