Your first step into IT or Computer literacy, this course gives you strong foundation on WORD, EXCEL, ACCESS and POWERPOINT
The course will empower you with formatting content, documents, collaborating and customizing Microsoft word. Gives you knowledge of working in excel sheet, sorting, filtering & maintaining database etc.
It gives you enough confident and make you specialist in this application packages to find the Office Administration jobs once you complete your course.
1. Microsoft Office Word 2003 Expert |
2. Formatting Documents |
Formatting Content
• Create custom styles for text, tables, and lists
• Control pagination
• Format, position, and resize graphics using advanced layout features
• Insert and modify objects
• Create and modify diagrams and charts using data from other sources
Organizing Content
• Sort content in lists and tables
• Perform calculations in tables
• Modify table formats
• Summarize document content using automated tools
• Use automated tools for document navigation
• Merge letters with other data sources
• Merge labels with other data sources
• Structure documents using XML |
• Create and modify forms
• Create and modify document background
• Create and modify document indexes and tables
• Insert and modify endnotes, footnotes, captions, and cross-references
• Create and manage master documents and subdocuments
Collaborating
• Modify tracked changes options
• Publish and edit Web documents
• Manage document versions
• Protect and restrict forms and documents
• Attach digital signatures to documents
• Customize document properties
Customizing Microsoft Word
• Create, edit, and run macros
• Customize menus and toolbars
• Modify Word default settings |
| 3. Microsoft Office Excel 2003 Expert |
4. Collaborating |
Organizing and Analyzing Data
• Use subtotals
• Define and apply advanced filters
• Group and outline data
• Use data validation
• Create and modify list ranges
• Add, show, close, edit, merge, and summarize scenarios
• Perform data analysis using automated tools
• Create PivotTable and PivotChart reports
• Use Lookup and Reference functions
• Use Database functions
• Trace formula precedents, dependents, and errors
• Locate invalid data and formulas
• Watch and evaluate formulas
• Define, modify, and use named ranges
• Structure workbooks using XML
Formatting Data and Content
• Create and modify custom data formats
• Use conditional formatting
• Format and resize graphics
• Format charts and diagrams
|
• Protect cells, worksheets, and workbooks
• Apply workbook security settings
• Share workbooks
• Merge workbooks
• Track, accept, and reject changes to workbooks
Managing Data and Workbooks
• Import data to Excel
• Export data from Excel
• Publish and edit Web worksheets and workbooks
• Create and edit templates
• Consolidate data
• Define and modify workbook properties
Customizing Excel
• Customize toolbars and menus
• Create, edit, and run macros
• Modify Excel default settings |
| 5. Microsoft Office PowerPoint 2003 |
6. Collaborating |
Creating Content
• Create new presentations from templates
• Insert and edit text-based content
• Insert tables, charts, and diagrams
• Insert pictures, shapes, and graphics
• Insert objects
Formatting Content
• Format text-based content
• Format pictures, shapes, and graphics
• Format slides
• Apply animation schemes
• Apply slide transitions
• Customize slide templates
• Work with masters
|
• Track, accept, and reject changes in a presentation
• Add, edit, and delete comments in a presentation
• Compare and merge presentations
Managing and Delivering Presentations
• Organize a presentation
• Set up slide shows for delivery
• Rehearse timing
• Deliver presentations
• Prepare presentations for remote delivery
• Save and publish presentations
• Print slides, outlines, handouts, and speaker notes
• Export a presentation to another Microsoft Office program |
| 7. Microsoft Office Access 2003 |
8..Organizing Data |
Structuring Databases
• Create Microsoft Access databases
• Create and modify tables
• Define and modify field types
• Modify field properties
• Create and modify one-to-many relationships
• Enforce referential integrity
• Create and modify queries
• Create forms
• Add and modify form controls and properties
• Create reports
• Add and modify report control properties
• Create a data access page
Entering Data
• Enter, edit, and delete records
• Find and move among records
• Import data to Access
|
• Create and modify calculated fields and aggregate functions
• Modify form layout
• Modify report layout and page setup
• Format datasheets
• Sort records
• Filter records
Managing Databases
• Identify object dependencies
• View objects and object data in other views
• Print database objects and data
• Export data from Access
• Back up a database
• Compact and repair databases
|
| 9. Microsoft Office Outlook 2003 |
10..Organizing |
Messaging
• Originate and respond to e-mail and instant messages
• Attach files to items
• Create and modify a personal signature for messages
• Modify e-mail message settings and delivery options
• Create and edit contacts
• Accept, decline, and delegate tasks
Scheduling
• Create and modify appointments, meetings, and events
• Update, cancel, and respond to meeting requests
• Customize Calendar settings
• Create, modify, and assign tasks
|
• Create and modify distribution lists
• Link contacts to other items
• Create and modify notes
• Organize items
• Organize items using folders
• Search for items
• Save items in different file formats
• Assign items to categories
• Preview and print items |
