PDF Archive

Easily share your PDF documents with your contacts, on the Web and Social Networks.

Share a file Manage my documents Convert Recover PDF Search Help Contact

CACAP .pdf

Original filename: CACAP.pdf
Author: The Learning

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

Download original PDF file

Document 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: thelearning007@gmail.com

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: thelearning007@gmail.com

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: thelearning007@gmail.com

CACAP.pdf - page 1/3
CACAP.pdf - page 2/3
CACAP.pdf - page 3/3

Related documents

ichne 16 months
advanced level course in excel
computer application in business
advanced excel training courses
bo online training

Related keywords