MICROSOFT

ADVANCE OFFICE PRODUCTIVITY 2013

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

Module 1 : MS EXCEL TRAINING

I. Basic Excel Functions

  • Text Functions: LEFT, RIGHT, UPPER, LOWER, TRIM, SUBSTITUTE, etc
  • Math Functions: SUMIF, AVERAGEIF, SUMIFS, COUNTIFS, etc
  • Advanced Logical Functions: IF, IFERROR, AND, OR
  • Date and Time Functions
  • Advanced Lookup Functions: VLOOKUP, MATCH, INDEX

 

II. Database Management

  • Conditional Formatting
  • Duplicate Tool
  • Text- to- Columns
  • Data Validation
  • Creating Basic Dropdown Lists
  • Other Data Validation Options
  • Advanced Data Validation Features
  • Consolidation Tools
  • Using Groups and Subtotals
  • Automated Tables

                         

III.  Charting

  • Adding  and Modifying Chart Elements
  • Making Combination Charts
  • Advanced Charting Techniques
  • Using SmartArt

 

IV. PivotTables

  • Creating Basic PivotTables
  • Modifying Value Field Settings
  • Grouping Data
  • Calculated Fields

 

V. Analysis Tools

  • Goal Seek
  • Data Tables

 

VI. Creating Macros

  • Exploring Macro Security
  • Recording and Running a Macro
  • Assigning a Macro to an Image or Button

 

Module 2 :  MS POWERPOINT TRAINING


VII.  Essential MS PowerPoint Skills

  • Formatting Texts
  • Formatting Slide Backgrounds
  • Editing Background Gradient Fill Color
  • Editing Background Picture/Texture Fill
  • Applying Artistic Effects
  • Formatting Images
  • Adding/Editing Images
  • Using ScreenShot Option
  • Creating Photo Album
  • Using Picture Tools and Shape Effects
  • Using SmartArt
  • Using the Group/Ungroup Option
  • Advanced Picture Formatting
  • Creating Tables
  • Making Tables
  • Inserting MS Excel Spreadsheet
  • Changes in Making Tables and Charts

 

VIII.  Animation

  • Adding Animation to Slide Contents
  • Adding Entrance, Emphasis, and Exit Actions
  • Using Animation Pane
  • Creating Motion Paths
  • Editing Animations: Timing and Effect Options

 

IX. Adding Media Contents

  • Adding Audio and Video in Slides
  • Playing Media in Slides
  • Embedding MS Excel Charts into MS PowerPoint

 

X. Using Slide Masters

  • Using the Slide Master
  • Updating Slide Masters
  • Using Notes and Handouts Master

 

XII. Setting Up Slide Shows

  • Presenter View (2007)
  • Changing Slide Show Settings
  • Hiding Slides
  • Using Hyperlinks to Navigate Slides
  • Recording Slide Shows
  • Recording Timings, Narration, and Slide Actions
  • Editing/Playing Recordings
  • Rehearsing Timings
  • Troubleshooting Narration/Recording Issues    

  

Module 3 :  MS WORD TRAINING

  • Review of Basic MS Word Functions
  • Inserting Textboxes
  • Page Layout
  • Page Setup
  • Page Breaks 
  • Advanced Document Formats
  • Creating New Styles
  • Using Existing Styles
  • Updating and Deleting Styles
  • Inserting Headers and Footers 
  • Mailings
  • Understanding Mail Merge
  • Creating a Main Document
  • Creating a Data Source
  • Adding Merge Fields and Merging Documents
  • Sorting/Filtering Data Records
  • Generating Mailing Labels
  • Creating Forms
  • Adding Text, Drop-Down Form Fields
  • Adding Check Box Form Fields
  • Modifying and Protecting Form Fields
  • Testing and Password Protecting a Form Field