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

CERTIFICATE IN ADVANCED COMPUTER APPLICATIONS
CERTIFICATE IN ADVANCED
COMPUTER APPLICATIONS
(CACAP)
(CACAP)
Course on Computer Concepts (CCC) Certification










Introduction To Computer
Introduction To GUI Based Operating
Windows 7, Windows 8
Elements Of Word Processing
Spreadsheets
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 &
Shapes
MS Outlook
 Introduction of MS Outlook
 Configuring & Settings of Email
accounts
 Sending & Receiving Emails
 Managing Address Books
 Data File Management
 Mail Merge

 Working with videos and audios in
slides
 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
Emailing
Notepad & WordPad
Photoshop
MS Paint
M S Office Picture Manager
Snipping Tool & Light Shot
PDF Reader
Teamviewer
Web Panel for SMS & Email











Typing ( English & Hindi)
Remote Desktop Connection
Control Panel
Sticky Notes
Skype
Browsers
Downloaders
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

ADVANCE EXCEL TRAINING
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
spreadsheets
 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


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


Related keywords