Course Duration

8 hours, 1-day training workshop

Delivery

Face to face training or online training

Course Inclusive

Training materials & certificate of completion

Description

After Basic and Intermediate Excel and you want to learn advanced functionalities like PivotTables, PivotCharts, and even introduction to VBA Macro.

Course Content

• MODULE I: Review on Content and Slide Design
  1. Formatting Texts
  2. Formatting Slide Backgrounds
     1. Editing Background Gradient Fill Color
     2. Editing Background Picture/Texture Fill
     3. Applying Artistic Effects
  3. Formatting Images
     1. Adding/Editing Images
     2. Using ScreenShot Option
     3. Creating Photo Album
     4. Using Picture Tools and Shape Effects
     5. Using SmartArt
     6. Using the Group/Ungroup Option
     7. Advanced Picture Formatting
  4. Creating Tables
     1. Making Tables
     2. Inserting MS Excel Spreadsheet
     3. Changes in Making Tables and Charts
  5. Adding Headers/Footers


• MODULE II: Review on PowerPoint Options
  1. The Backstage View
  2. Printing Options
     1. Printing Handouts
     2. Printing as PDF
  3. Editing the Quick Access Toolbar
  4. Exploring Advanced Powerpoint Options
  5. Saving Slides as images
  6. Powerpoint 2009 - 2007 - 2010 Compatibility Outcomes
  7. Protection and Security Options
     1. Marking as Final
     2. Adding Digital Signature


• MODULE III: Merging Presentations
  1. Using the Merge Functionality
  2. Adding Comments


• MODULE IV: Setting Up Slide Shows
  1. Presenter View
  2. Changing Slide Show Settings
  3. Hiding Slides
  4. Using Hyperlinks to Navigate Slides
  5. Recording Slide Shows
     1. Recording Timings, Narration, and Slide Actions
     2. Editing/Playing Recordings
     3. Rehearsing Timings
     4. Troubleshooting Narration/Recording Issues
  6. MS Powerpoint Broadcast Service
     1. Creating Windows Live ID
     2. Broadcasting a Presentation