File information

Author: The Learning

This PDF 1.5 document has been generated by Microsoft® Office Word 2007, and has been sent on on 01/10/2016 at 16:47, from IP address 45.127.x.x. The current document download page has been viewed 413 times.
File size: 378.19 KB (3 pages).
Privacy: public file

File preview

Computer Training Institute

Course on Computer Concepts (CCC) Certification

Introduction To Computer
Introduction To GUI Based Operating
Windows 7, Windows 8
Elements Of Word Processing
Introduction To Internet, WWW
Communication And Collaboration
Application Of Presentations
Application Of Digital Financial Services

MS Office Applications – 2007, 2010, 2013 (Advanced Level)
MS Word
 Create & Edit Tables
 Find & Replace with more options
 Document Editing Techniques
 Mail Merge for Letter Writing
 Signature and Document Protection
 Shortcut Keys
 Save As in Different Formats

 Working With Pictures, Shapes &
Smart Arts
 Working with Symbols & WordArt
 Header & Footer
 Table of Contents
 Track Changes
 Hyperlink & Bookmark

MS Excel
 Basics of Microsoft Excel
 Most Important Formulas
 Analyzing and Summarization of data
 Advanced Contents
MS PowerPoint
 Creating Presentations using Slides
 Inserting Animation in Slides
 Creating Designs in Slides
 Using Custom Animation
 Working with Texts, Pictures &
MS Outlook
 Introduction of MS Outlook
 Configuring & Settings of Email
 Sending & Receiving Emails
 Managing Address Books
 Data File Management
 Mail Merge

 Working with videos and audios in
 Creating Photo Album
 Setting up Slide Show
 Hyperlink and Action

Adding Contacts
Adding Signatures
Working with Calendar & Tasks
Using Import & Export

Address: C-44 Gyan Mandir Road, Near Soda Shop, Jaitpur Extn. Badarpur, New Delhi – 110044

Contact: 8860599566, Email:

Computer Training Institute
Important Computer Applications & Techniques

Internet Surfing
Notepad & WordPad
MS Paint
M S Office Picture Manager
Snipping Tool & Light Shot
PDF Reader
Web Panel for SMS & Email

Typing ( English & Hindi)
Remote Desktop Connection
Control Panel
Sticky Notes
Anti Virus
Printing & Scanning

Interview & Job Skills Classes

Interview Preparation
Resume Preparation
Personality Development
Effective Interview Skills
On Job Training
Important Office Skills
E-Mail Writing
Communication Skills
Presentation Skills

Duration: 6 Months

Address: C-44 Gyan Mandir Road, Near Soda Shop, Jaitpur Extn. Badarpur, New Delhi – 110044

Contact: 8860599566, Email:

Computer Training Institute

Basics of Microsoft Excel

Introduction of MS Excel
Basic operators - ( + , - , /, *, ^, >, < , =)
Percentage (% ) Computation
Auto fill options
Data formats
Paste Special
Absolute & Relative referencing ($)
Selection- Keyboard shortcuts

 Conditional formatting
 Creating, editing, saving and printing
 Working with functions & formulae
 Formatting worksheets
 Securing & Protecting spreadsheets
 Page Setup & Print formatting

Most Important Formulas
 Lookup & Reference Functions: - VLookup, HLookup, Index, Match, Indirect, Column,
Columns, Row, Rows, Choose, Transpose, Arrays Concept in Lookup Formula’s etc.
 Logical Functions: - And, Or, If, Iferror, Not, Nested If.
 Mathematical Functions: - Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif,
Countifs, Average, Averageif, Averageifs, Rand, Randbetween, Round etc.
 Text Functions:- Char, Clean, Code, Concatenate, Find, Substitute, Replace, Len, Right,
Left, Mid, Lower, Upper, Proper, Text, Trim, Value etc.
 Date & Time Function: - Date, Day, Month, Year, Edate, Eomonth, Networkdays, Minute,
Second, Now, Today, Time etc.
 More Formulas: - Istext, Isnumber, Iserror, Iferror, Isblank etc.

Analyzing and Summarization of data

Experiencing Of Handling Large Data
Creating Dashboards
Data Validation
Conditional Formatting
Sort& Filter, Advance Filter
Name Cells /Ranges /Constants
Importing Data From Other Sources

Consolidation Of Data
Sheet Referencing, Hyperlink
What-if-analysis, Goal Seek
Pivot Tables & Reporting
 Graphically Representing Data :
Charts & Graphs

Advanced Contents

Advanced Data Validation
Advance Conditional formatting
Advanced Data formats
More keyboards shortcuts
Advanced charts and Graphs
Some more Functions
Case Study Questions

 Work on real data
 Techniques of Putting Combinations
of Formulas
 Improving Logical Concepts
 Excel tricks to work fast
 Introduction to VBA

Duration: Three Months

Address: C-44 Gyan Mandir Road, Near Soda Shop, Jaitpur Extn. Badarpur, New Delhi – 110044

Contact: 8860599566, Email:

Download CACAP

CACAP.pdf (PDF, 378.19 KB)

Download PDF

Share this file on social networks


Link to this page

Permanent link

Use the permanent link to the download page to share your document on Facebook, Twitter, LinkedIn, or directly with a contact by e-Mail, Messenger, Whatsapp, Line..

Short link

Use the short link to share your document on Twitter or by text message (SMS)


Copy the following HTML code to share your document on a Website or Blog

QR Code to this page

QR Code link to PDF file CACAP.pdf

This file has been shared publicly by a user of PDF Archive.
Document ID: 0000489933.
Report illicit content