Advanced Office Productivity

Description

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

Course Content

  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 
  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
  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
    • +63 2 8891 0722
    • +63 2 8891 0713
    • +63 2 8751 6482
    • Intramuros
    • +63 2 8524-5572
    • Intramuros
    • 658 Muralla St., Intramuros, Manila 1002, Philippines


    • Makati
    • 333 Sen. Gil Puyat Ave., Makati City 1200, Philippines