CACAP .pdf

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