ADVANCE MS OFFICE
  1. MS WORD
  2. MS EXCEL
  3. MS ACCESS
  4. MS OUTLOOK

Course Structure

  • DIFFERENT VIEWS
  • USING HYPERLINK
  • AUTOTEXT AND AUTOCORRECT
  • SETTING COLUMNS
  • MAIL MERGE
  • TRACK CHANGES
  • ENVELOPES AND LABELS
  • BASIC MACRO FUNCTIONS
  • DOCUMENT PROTECTION
  • FAX AND MAILING

• BASIC FUNTIONS
• SUM IFS AND COUNTIFS
• PIVOT TABLE AND PIVOT CHART
• VLOOK UP & HLOOKUP
• DATA VALIDATION
• GOAL SEEK
• HYPERLINK
• NAME MANAGER
• ADVANCE FILTER
• SCENARIO MANAGER
• QUICK ACCESS TOOL BAR
• FORMULA AUDITTING
• CONDITIONAL FORMATTING
• SUBTOTAL,GROUP,UNGROUP
• DATA TABLE
• REMOVE DUPLICATES
• CONSOLIDATION
• WATCH WINDOW
• TEXT TO COLUMNS
• CUSTOM VIEWS
• COMMENT
• PASTE SPECIAL
• TRACK CHANGES

• INTRODUCTION TO DATABASE
• BULIDING DATABASE
• DATABASE MANAGEMENT
• USING FORMS ,FILTERS , QUERIES AND REPORTS
• LINKING WITH OTHER MICORSOFT APPLICATIONS
• RELATIONSHIP
• MACROS
• DATABASE UTILITES

• SETTING UP AND MANAGING YOUR EMAIL
• PERSONAL FOLDER
• CALENDAR
• CONTACTS
• TASKS
• NOTES
• OUTLOOK CONFIGURATION

Our Upcoming Batches

Course Name Training Type Start Date Location
Upcoming course not found...