Udemy
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
Turn what you know into an opportunity and reach millions around the world.
Learn More
Your cart is empty.
Keep shopping
Presenting Financials with Excel and PowerPoint
Rating: 4.3 out of 5(480 ratings)
2,325 students

Presenting Financials with Excel and PowerPoint

Learn special tricks in Excel and PowerPoint designed specifically for presenting to "numbers people".
Created byLearnit Anytime
Last updated 10/2012
English
English [Auto],

Course content

1 section • 11 lectures • 1h 52m total length

  • Course Topics & Exercise Files1:24

    Learn to present financials with Excel and PowerPoint by creating an automatic subtotal, pivot tables, and charts, applying conditional formatting and sparklines, and embedding and animating charts across Office 2010.

  • Automatic Subtotals18:23
    Create quick and easy summaries automatically with Automatic Subtotals. Big time saver! 
  • Pivot Tables33:41
    Learn Excel's most misunderstood feature. Make it easy, and use it for presenting data on the fly. 
  • Pivot Charts6:29
    Quickly make a chart that is tied to a Pivot table. 
  • Proper Chart Selection2:49
    Know which chart type to use and when!
  • Creating Data Charts16:58
    Best practices for creating data charts to display data. 
  • Formatting Charts9:36
    How to make your chart look exactly the way you want!
  • Conditional Formatting8:32
    Make data stand out if it meets certain conditions, or insert special graphics to communicate a message. 
  • Inserting Sparklines4:44
    Sparklines are mini-charts that you can include right in your table. New and useful! 
  • Linking Excel Charts in PowerPoint5:28
    Create charts that change in PowerPoint if they're changed in Excel.
  • Animating Charts4:06
    Make your charts come alive when presenting in PowerPoint! 

Requirements

  • Basic knowledge of PowerPoint and Excel is recommended.

Description

This course is designed for individuals who want to combine the data analysis tools of Microsoft Excel with the presentation capabilities of Microsoft PowerPoint. You will learn how to uncover the key values for your business, turn those values into well designed, user friendly charts, and incorporate those charts into a professional PowerPoint Presentation. Make your next financial presentation easier and clearer. 

Who this course is for:

  • Anyone who presents data.

Report abuse