Professional Presentations with Excel & Powerpoint


Duration: 1 Day

Next Dates:

Contact Velopi for next available course dates

Book Online

More Information

Course Overview

This course will demonstrate how to prepare presentations and reports developed using Excel and PowerPoint.

For whom is this course suitable?

This course is aimed at experienced desktop users who are already familiar with basic functionality of Excel and PowerPoint. It will benefit anyone who:

  • has data in Excel to analyse
  • has to present Excel-based data to an audience
  • needs to develop PowerPoint presentations

Course Content


  • The storyboard for the presentation
  • Target audience: Establishing the Brief
  • Making the presentation relevant – content and structure
  • Using an appropriate structure to meet your objectives


Working with Charts

  • Creating a Chart
  • Formatting a Chart
  • Modifying Charts with the Layout Ribbon
  • Manipulating a Chart
  • Enhancing a Chart with Shapes and Graphics

Working with Charts, Part 2

  • Changing the Type of Chart
  • Changing the Source Data
  • Working with the Chart Axis and Data Series
  • Saving a Chart as a Template

Getting the Most From Your Data

  • Getting The Most From Your Data
  • Using Automatic Outlining
  • Displaying and Collapsing Levels
  • Grouping Data Manually
  • Creating Subtotals


  • What is a PivotTable?
  • Creating a PivotTable
  • Creating a PivotTable Frame
  • Specifying PivotTable Data
  • Rearranging PivotTable Data

More About PivotTables

  • Modifying PivotTable Calculations
  • Formatting a PivotTable
  • Refreshing a PivotTable
  • Charting a PivotTable
  • Creating a PivotTable Based on External Data

Reporting tools in Excel and best practice for them


Creating and Working with Tables:

  • Inserting a Table
  • Drawing a Table
  • Using the Table Tools Ribbon
  • Working with Cells
  • Inserting an Excel Table
  • The Insert Excel Table Ribbons

Formatting a Table:

  • Setting Style Options
  • Setting Table Styles
  • Changing the Shape of a Fill
  • Applying Borders
  • Adding Effects
  • Drawing Borders
  • Adding and Formatting WordArt

Working with Charts and Graphs:

  • Creating and Linking Worksheet Charts and Graphs
  • Chart Tools Ribbon
  • Incorporating Titles and Data
  • Legends and Labels

Working with SmartArt:

  • Creating SmartArt
  • SmartArt Tools
  • Resizing Diagrams
  • Inserting SmartArt From a Slide

Customizing Your Diagrams:

  • Inserting a Symbol or Special Character
  • Adding and Editing Shapes
  • Changing Diagram Types and Design Schemes
  • Incorporating Text

Working with Text Boxes:

  • The Drawing Tools Ribbon
  • ClipArt:
  • Searching for ClipArt
  • Inserting ClipArt
  • Formatting ClipArt

Adding a Sound Clip:

  • Insert Sound Clip from Clip Organizer or File
  • Sound Tools
  • Recording a Sound

What to do next

Contact Us

Enquire Now about the Professional Presentations with Excel & Powerpoint course

Please Fill Out the Form Below
Leave this field empty
© 2020 Velopi : PMBOK, PMI and the R.E.P. logo, PMP, PgMP, CAPM, PMI-SP and PMI-RMP are registered marks of the Project Management Institute, Inc.

Web Development by Granite Digital