BASE CERTIFICATE IN WORD XP
(Duration - 8 hrs)

• Explore the Word window
• Create and save documents
• Print documents
• Use help and the Office Assistant
• Edit documents
• Move and copy text
• Format characters and paragraphs
• Create and manage tables
• Define page layouts for documents
• Use proofing tools such as spelling and grammar, and thesaurus
• Open and save a document as a Web page
• Add hyperlinks in a document
• Send Word documents via email

BASE CERTIFICATE IN EXCEL XP
(Duration - 8 hrs)

• Explore the Excel window
• Use help and the Office Assistant
• Open, close, and navigate workbooks
• Create workbooks
• Enter and edit data
• Enter and edit formulas
• Use functions like SUM, AVERAGE, MIN, MAX, and COUNT
• Format worksheets
• Print a worksheet
• Specify page setup options
• Create, modify, and print charts
• Save worksheets as Web pages
• Insert and edit hyperlinks in worksheets
• Send workbooks via email

BASE CERTIFICATE IN POWERPOINT XP
(Duration - 8 hrs)

• Explore the PowerPoint environment
• Use help and the Office Assistant
• Create and save presentations
• Work in the Outline tab
• Rearrange and delete slides
• Use slides from other presentations
• Format presentations
• Use proofing tools such as spelling checker, autocorrect, and style checker
• Use drawing tools to draw objects
• Work with WordArt and clip art
• Create tables and charts
• Enhance presentations using templates
• Add transition effects, timings, and speaker notes to
presentations
• Save presentations for Web delivery
• Add hyperlinks to presentations
• Send presentations via email

BASE CERTIFICATE IN ACCESS XP
(Duration - 8 hrs)

• Identify database concepts and terminology
• Explore the Access environment
• Design databases
• Use help and the Office Assistant
• Explore tables, forms, queries, and reports
• Create databases using the table wizard and the design view
• Change the design of a table
• Add, delete, find, and edit records
• Sort and filter records
• Create and use queries
• Create and use forms
• Create and use reports
• Import, export, and link objects

ADVANCED CERTIFICATE IN WORD XP
(Duration - 16 hrs)

• Create form letters and addressing envelopes
• Create and modify forms
• Explore form field data types
• Protect forms
• Create master documents and table of contents
• Use endnotes and footnotes
• Create indexes
• Work with bookmarks and cross-references
• Track changes in a document
• Add comments and highlighting
• Automate actions with macros
• Examine the VBE window
• Work with properties and modules
• Work with the Code window
• Program in VBA
• Program with objects
• Work with table and document objects
• Use control structures
• Work with custom dialog boxes
• Debug and handle errors

Elderly students taking Swift course at NIIT

ADVANCED CERTIFICATE IN EXCEL XP
(Duration - 16 hrs)

• Work with advanced formulas
• Work with lookup functions
• Create data tables
• Validate cell entries
• Work with data forms
• Work with PivotTables
• Export and import data
• Query external databases
• Work with Goal Seek and Solver
• Work with scenarios
• Work with views
• Work with macros
• Create interactive Web spreadsheets
• Use Visual Basic Editor
• Write basic programs in VBA
• Work with custom dialog boxes
• Use debugging and error-handling techniques

ADVANCED CERTIFICATE IN POWERPOINT XP
(Duration - 16 hrs)

• Build custom templates
• Use advanced clip art and drawing techniques
• Add movies and sound from the Clip Organizer
• Use animations and scanned images
• Integrate Word and Excel with PowerPoint
• Work with organizational charts and tables
• Add special effects
• Work with Slide Show options
• Set up review cycles
• Broadcast presentations
• Work with the Pack and Go wizard
• Use advanced delivery techniques such as Show Popup menu and Pen
• Customize the PowerPoint environment by using toolbars and
creating macros

ADVANCED CERTIFICATE IN ACCESS XP
(Duration - 16 hrs)

• Create and modify PivotTables
• Create a PivotChart
• Create Advanced forms
• Create and run macros
• Attach macros to events of database objects
• Create advanced macros
• Explore Access SQL
• Work with Hyperlink fields
• Work with data access pages
• Manage databases
• Protect databases and provide user-level security
• Design an application
• Automate forms
• Work with Switchboard and Splash Screen forms
• Create custom toolbars and menu bars
• Work with modules
• Create procedures
• Use control structures
• Handle events
• Resolve errors
• Display a Web site on a form
• Work with MDE files

ADVANCED CERTIFICATE IN OFFICE XP
(Duration - 52 hrs)

• AWX - Advanced Certificate in Word XP
• AEX - Advanced Certificate in Excel XP
• APX - Advanced Certificate in PowerPoint XP
• AAX - Advanced Certificate in Access XP

BASE CERTIFICATE IN OFFICE XP
(Duration - 32 hrs)

• BWX - Base Certificate in Word XP
• BEX - Base Certificate in Excel XP
• BPX - Base Certificate in PowerPoint XP
• BAX - Base Certificate in Access XP