MS Office

Certificate Program in Computer Applications- “CPCA”

Duration: – 3-Months                                                                                                            1-Hour Daily

Introduction of Operating Systems 

MS DOS [DISK OPERTING SYSTEM]

  • Internal Commands, External Commands

Introduction to MS-WINDOW

  • Microsoft Windows Applications (Notepad Word pad Paint Brush etc.)
  • Start Menu Quick Launch, Task bar Settings
  • Accessories [paint brush, note pad, word pad]
  • Working with Folders and Files
  • Control Panel
  • Display Properties, Date and Time Setting, Key Board and Mouse Setting, User account

MICROSOFT WORD

  • Introduction
  • Features of Ms Word
  • Layout of Ms Word
  • Main Menu Options
  • Working with Short cut keys Creating Résumé, Saving data wit Date and time Folders, Office Clipboard,
  • paste as Hyperlink and Insert Hyperlink
  • Layout settings, caption cross Reference, Index and table Bookmark using frame, Auto Summarize Protect Document Letter and mailing, Mail Merge Letter Wizard, Macros, Autocorrect Option Customize, Option Settings8. Formatting Tables
    Creating a Cover Page with Themes, Saving a Document, Outputting to PDF
  • Printing a Document, Practices Exercise

MICROSOFT EXCEL 

BASIC EXCEL

  • Introduction of Menu Bar, Tools Bars
  • Cell Colum Rows
  • Characteristics of MS EXCEL
  • Editing Data, Save Workspace
  • Creating Spreadsheet, Across Worksheet
  • Using Formulas, Goal Seek, Define Name
  • Fourth ,working With Series
  • Using the Insert Function Dialog Box
  • Using Format Painter 

Advance Excel WITH FUNCTIONS & FORMULAS

  • Formulas With Function:

   Average, Count, Count if, Count Blank, Date,    Grade,  Vlookup, Hlookup, Lower, Max, Min,   Now,

Pass and fail, Power, Proper, Rept, Roman, Sum, Sumif, Tie, Days360

  • Creating salary sheet, mark Sheet And Hyperlink sheet Data  MS Reporting, Balance Sheet, Text Functions, What-if  Analysis, Pivot Table & Chart
  • WORKING WITH LISTS: Creating a List, Using a Data Form, Deleting Records Using a Data Form, Sorting Records in a List, Using AutoFilter in a List
  • WORKING WITH CHARTS: Creating a Chart with the Chart Wizard, Moving a Chart, Resizing a Chart, Changing a Chart Type, Editing Chart Text

WORKING WITH GRAPHICS: Using the Drawing Toolbar, Formatting Objects, Inserting WordArt

  • IMPORTING & EXPORTING DATA: Importing External Data into Excel, Importing Text Data into Excel, Exporting Data from Excel
  • FORMATTING NUMBERS: Creating Custom Number Format, Using Conditional Formatting, Removing Conditional Formatting
  • WORKING WITH RANGES: Naming a range, Using  a Named Range, Deleting a Named Range, Using the VLOOKUP Function
  • CUSTOMIZING EXCEL: Creating a Macro, Running a Macro, Editing a Macro
  • Practices Exercise

MICROSOFT POWER POINT

  • Introduction, Presentation with Auto shapes, word art, ungroup Objects
  • Magical Slide and data base
  • Presentation Using Option: slide sorts view, master, Grid & Guides, Apply
  • Design Templates m meeting minder
  • Customize, research timing, record narration, Action Buttons, Action
  • Animation, Customizing
  • Working with Different
  • Views ,Outputting a Presentation

SOCIAL, PROFESSIONAL & OFFICIAL USE OF INTERNET

  • Email Account and Attach Files, surfing, downloading and Uploading, Online Working Internet
  • Online Banking
  • Online Billing , Mobile, Electric, Travelling, Hotel, Marketing, E-Buying etc
  • Booking, Online Payments, Online Forms Filling, Result valuation, Online
  • Shopping, Surfing & Downloading of System Software &Tools)
  • Voice chatting, video conferencing Face book, Twitter, Linked in, Orkut,

Google+, YouTube, Rediff BOL, yahoo Messenger, Google chrome, Google Talk’s installation / Uses

  • Online Reservation, Booking, Online Payments,
  • Surfing & Downloading of System Software & Tools)

MICROSOFT OUTLOOK 

  1. Touring the Outlook Interface
  2. Using E-mail
  3. Creating Signatures & New Folders
  4. Using a Calendar & Adding Events
  5. Working with Multiple Calendars
  6. Sharing Calendars
  7. Adding & Viewing Contacts
  8. Creating, Viewing & Flagging Tasks 

TYPING SKILLS 

  1. Hindi Typing (20-30 Word Per Min)
  2. English Typing (20-30 Word Per Min)
  3. Typing Practice with Typing Tutor   

CAREER PROSPECTS 

  • Computer Operator
  • Front Office Executive
  • Customer Support Executive
  • Back Office Executive
  • Back Office Operator
  • Office Executive
  • Office Assistant
  • Data Entry Operator
  • Data Support Executive
  • Cash Counter Executive
  • Bill Desk Executive
  • Operation Executive
  • Trainee in a Computer Institute
  • Computer Trainer
  • Application Support Executive
  • Computer Typist
  • Documentation Assistant
  • Team Leader
  • Customer Support Officer

AND MANY MORE……….