Join Gini von Courter for an in-depth discussion in this video Using the exercise files, part of Data-Driven Presentations with Excel and PowerPoint.
- View Offline
If you're a premium member of the lynda.com training library, you have access to all of the Exercise files used in this course. They're in one folder named Exercise files. And I've placed a copy of it here on my Desktop. You can do that as well if you wish. The exercise files folder includes a folder for each chapter, chapter one, chapter two and so on. Followed by folders for data, graphics, and schematics. When we're working in a particular movie, you'll double-click to open the folder for that chapter, for example, chapter three, and then you'll double-click to open a specific file.
And you'll know which file to open, because a banner will appear on the screen telling you what file I'm opening. Some files are used, or useful in more then one chapter. For example the data folder includes some Excel workbooks that we use in more than one place. The Schematics folder includes one large schematic for a windmill farm that Connetico is building and the graphics folder includes several different types of graphics. The four by six graphics are the right size to serve as a background for slides in many PowerPoint presentations, but they are not limited to that use alone.
You can also use them for the back wall or the plot area of a chart, and they look really, really good. We have a set of employee photos that we'll use for a hierarchy chart that includes photos. And we have some icons in both the JPEG and PNG formats so that you can have transparent icons if you wish and in two different resolutions, 72 and 300 dpi. And each of the folders contains similar icons so you can decide which ones you want to use and you can try different icons to see which resolution. And which file type you prefer.
If you don't have access to the Exercise file folder, don't worry. You can use your own Excel workbooks that contain data. You can use built-in PowerPoint designs. And you can either use your own images or you can download free graphics of many different types. From the Microsoft Office site, www.microsoft.com/office. Now that we know about the files we'll be using, let's get started.
- 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