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