You don't have to be an excel guru or a powerpoint power user to take this course. But they are a few prerequisites. In Microsoft excel, you should know how to create and save a workbook. You should know how to format cells, basic text formatting, but also numeric formatting. And cell formatting, with things like borders and shading. You should feel comfortable selecting, copying, and pasting cells and ranges of cells. You should know how to sort and filter data so that you can select a set of data and present it to your audience in an order that they would best understand it in.
And you should know how to create basic charts, whether it's a pie chart, a line or a column chart. Any of those charts, if you're comfortable creating those, and with the other scales you see on the screen here, you're going to be fine in Excel. Now let's take a look at Powerpoint. In Powerpoint, you need to be able to create a basic presentation with text on slides. You then need to be able to apply some kind of a design, what we might have called a theme or a template in some versions of Powerpoint. To the presentation as a whole.
You need to be able to insert objects, you need to know how to put a picture on a slide for example or smart art or a chart. If you know how to insert any of these objects, you're fine. And then you need to know how to animate either text or an object. If you know how to make your words fly onto the screen or you know how to have a picture appear, or disappear, then you're all set. And you should be very comfortable copying and pasting objects and text from one slide to another, the same way that you'd copy and paste text inside of Microsoft Word, for example.
So those are the sets of skills that you'll need to have for Excel and PowerPoint. Because I'll be showing you these things, but we won't be teaching them individually. So what if you need to know more, well if you need to know more about Excel. Go to the lynda.com training library, and you will find there an essential training course for excel 2013, or 2010, 2007, whatever version you're using. And the same for PowerPoint. The Lynda.com training library has what you'll need to know to be able to take this course and feel really successful creating data driven presentations with Excel and PowerPoint.
Author
Released
10/17/2013- Using Excel themes
- Formatting tables
- Highlighting data with conditional formatting
- Creating pie, column, and combination charts
- Creating PivotTables
- Pasting and linking charts and tables
- Creating SmartArt diagrams
- Animating charts, tables, and SmartArt
- Finalizing your presentation
Skill Level Intermediate
Duration
Views
Related Courses
-
PowerPoint 2013 Essential Training
with Jess Stratton3h 18m Intermediate -
Excel 2013 Essential Training
with Dennis Taylor6h 32m Intermediate -
Excel 2013: Charts in Depth
with Dennis Taylor3h 46m Advanced
-
Introduction
-
Welcome1m 2s
-
Using the exercise files2m 16s
-
-
1. Data-Driven Presentations: The Basics
-
2. Formatting Excel Tables for Presentations
-
Setting table options3m 53s
-
Changing a table to a range2m 47s
-
Dividing large numbers3m 12s
-
3. Highlighting Data with Conditional Formatting
-
Using data bars4m 46s
-
Using icon sets4m 50s
-
Editing a conditional format8m 26s
-
4. Using Charts to Illustrate Data
-
Choosing the right chart7m 3s
-
Creating a pie chart2m 52s
-
Creating a column chart4m 34s
-
Creating a 100% chart3m 54s
-
Creating a combination chart2m 27s
-
-
5. Summarizing with PivotTables and PivotCharts
-
Creating a PivotChart4m 59s
-
6. Taking Excel to PowerPoint
-
Linking data and objects8m 42s
-
7. Using SmartArt in Data-Driven Presentations
-
Creating a SmartArt diagram3m 37s
-
-
8. Animating Charts and Data
-
Animating charts8m 11s
-
Removing animation1m 7s
-
Modifying animation order1m 16s
-
Animating SmartArt8m 11s
-
-
9. Finalizing Your Presentation
-
Conclusion
-
Next steps1m 49s
-
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: What you should know before watching this course