Advanced Office Productivity

Course Duration

40 hours, 5 -day training workshop

Delivery

Face to face training or online training

Course Inclusive

Training materials & certificate of completion

Description

This course combines Word, Excel and Powerpoint in one training.

Course Content

  • MODULE I: MS Excel Training
    1. Basic Excel Functions
      1. Text Functions: LEFT, RIGHT, UPPER, LOWER, TRIM, SUBSTITUTE, etc
      2. Math Functions: SUMIF, AVERAGEIF, SUMIFS, COUNTIFS, etc
      3. Advanced Logical Functions: IF, IFERROR, AND, OR
      4. Date and Time Functions
      5. Advanced Lookup Functions: VLOOKUP, MATCH, INDEX 
    2. Database Management
      1. Conditional Formatting
      2. Duplicate Tool
      3. Text- to- Columns
      4. Data Validation
      5. Creating Basic Dropdown Lists
      6. Other Data Validation Options
      7. Advanced Data Validation Features
      8. Consolidation Tools
      9. Using Groups and Subtotals
      10. Automated Tables
    3. Charting
      1. Adding and Modifying Chart Elements
      2. Making Combination Charts
      3. Advanced Charting Techniques
      4. Using SmartArt
    4. PivotTables
      1. Creating Basic PivotTables
      2. Modifying Value Field Settings
      3. Grouping Data
      4. Calculated Fields 
    5. Analysis Tools
      1. Goal Seek
      2. Data Tables 
    6. Creating Macros
      1. Exploring Macro Security
      2. Recording and Running a Macro
      3. Assigning a Macro to an Image or Button 

  • MODULE II: MS PowerPoint Training
    1. Essential MS PowerPoint Skills
      1. Formatting Texts
      2. Formatting Slide Backgrounds
      3. Editing Background Gradient Fill Color
      4. Editing Background Picture/Texture Fill
      5. Applying Artistic Effects
      6. Formatting Images
      7. Adding/Editing Images
      8. Using ScreenShot Option
      9. Creating Photo Album
      10. Using Picture Tools and Shape Effects
      11. Using SmartArt
      12. Using the Group/Ungroup Option
      13. Advanced Picture Formatting
      14. Creating Tables
      15. Making Tables
      16. Inserting MS Excel Spreadsheet
      17. Changes in Making Tables and Charts
    2. Animation
      1. Adding Animation to Slide Contents
      2. Adding Entrance, Emphasis, and Exit Actions
      3. Using Animation Pane
      4. Creating Motion Paths
      5. Editing Animations: Timing and Effect Options
    3. Adding Media Contents
      1. Adding Audio and Video in Slides
      2. Playing Media in Slides
      3. Embedding MS Excel Charts into MS PowerPoint
    4. Using Slide Masters
      1. Using the Slide Master
      2. Updating Slide Masters
      3. Using Notes and Handouts Master
    5. Setting up Slide Shows
      1. Presenter View (2007)
      2. Changing Slide Show Settings
      3. Hiding Slides
      4. Using Hyperlinks to Navigate Slides
      5. Recording Slide Shows
      6. Recording Timings, Narration, and Slide Actions
      7. Editing/Playing Recordings
      8. Rehearsing Timings
      9. Troubleshooting Narration/Recording Issues

  • MODULE III: MS Word Training
    1. Review of Basic MS Word Functions
    2. Inserting Textboxes
    3. Page Layout
    4. Page Setup
    5. Page Breaks 
    6. Advanced Document Formats
    7. Creating New Styles
    8. Using Existing Styles
    9. Updating and Deleting Styles
    10. Inserting Headers and Footers 
    11. Mailings
    12. Understanding Mail Merge
    13. Creating a Main Document
    14. Creating a Data Source
    15. Adding Merge Fields and Merging Documents
    16. Sorting/Filtering Data Records
    17. Generating Mailing Labels
    18. Creating Forms
    19. Adding Text, Drop-Down Form Fields
    20. Adding Check Box Form Fields
    21. Modifying and Protecting Form Fields
    22. Testing and Password Protecting a Form Field
    • MAKATI
    • 333 Sen. Gil Puyat Ave., Makati City 1200, Philippines

    • Contact No.
    • +63 2 8891 0713
      +63 2 8751 6482

    • Email Address
    • inquiries@mapua.edu.ph

    • INTRAMUROS
    • 658 Muralla St., Intramuros, Manila 1002, Philippines

    • Contact No.
    • +63 2 8524-5572


    • Email Address
    • ccesc@mapua.edu.ph