Certificate in Computer Application
Microsoft Word Excel Certification
IT Fundamental and Office Automation
Basic of Computer, Hardware and Software Terminology, Basic Input/ Output, Process, Organization of Computer, Operating System.
MS-Office-
MS-Word, Font Formatting, Paragraph Formatting, Styling, Creating and Managing Tables, Creating Various Type of Chart, Advance Level Header and Footer, Page Numbering, Searching and Replacing, Advance Level Replacing, Inserting, Mail Merge, Page Setup, Tables Formats, Data arrange in table, Basic practice of drawing tools, various assignment relating to Table and Documentation, Efficiency, Word to PDF.
Practical Assignment (Live Project) -
Resume Creation, Application Writing, Letter Drafting, News Paper Classified,
Ms-Excel -
Formatting of spreadsheet, Formula and Function-Sum, Count, Average, Max, Min, Conditional Function IF, Sumif, Countif, Averageif, VLookup, HLookup, Text Function, Date and Time Function, Math Function, Statically Function,Text Wrapping, Conditional Formation, Filter, Advance Filter, Data Validation, Scenario Manager, Goal Seek, Data Table, Worksheet and Workbook Protection, File Protection, Row and Column Freezing, Editing Features, Working with Large Worksheets, Working with Charts, Data Entry,
Practical Assignment (Live Project)-
Interest Calculation, Marks-Sheet Pay-Slip, Commission Calculation, Data Sorting, Advance level Excel, Chart Creation.
Power Point -
Creating Presentation, Themes, Transition, Animation, Slide Show, Animation Design, Slide Show, Working with slide and creating powerful presentation.
Practical Assignment (Live Project) -
School and College Level Presentation, Business Seminar Presentation, Internet - Introduction of Internet, Internet Connectivity, Surfing, Chatting, E-Mail Creation, Formation of E-Mail, Search Engine.
Live Project (Practical Assignment) :-
Marks Sheet, Payroll, Balance Sheet & PLAC, Shop Billing