DCA(DIPLOMA IN COMPUTER APPLICATION)
भारत सरकार द्वारा मान्यता प्राप्त संस्थान Student Point Computer Training Center ( Recognized by Government of India)
DCA(DIPLOMA IN COMPUTER APPLICATION)
Part Time
Duration : 6 Months
Class : 1 Hrs Daily
Days : Mon-Sat.
Navigate in Microsoft Word
Create and Save Word Documents
Manage Your Workspace
Edit Documents
Preview and Print Documents
Customize the Word Environment
Apply Character Formatting
Control Paragraph Layout
Align Text Using Tabs
Display Text in Bulleted or Numbered Lists
Apply Borders and Shading
Make Repetitive Edits
Apply Repetitive Formatting
Use Styles to Streamline Repetitive Formatting Tasks
Sort a List
Format a List
Insert a Table
Modify a Table
Format a Table
Convert Text to a Table
Insert Symbols and Special Characters
Add Images to a Document
Apply a Page Border and Color
Add Headers and Footers
Control Page Layout
Add a Watermark
Learn to set the page orientation as portrait or landscape.
Learn to set the print size of the paper.
Learn to split your text into multiple columns.
Learn to add page breaks.
Learn to add section breaks.
Beginning a Mail Merge
Using Excel for Mail Merge Data
Previewing Merge Letters
Selective Merge Records
Filtering
IF Then Else Fields
Include Text Fields
Mail Merge to Email
Check Spelling, Grammar, and Readability
Use Research Tools
Check Accessibility
Save a Document to Other Formats
The Macro Recorder
Recording Macros
Testing Macros
Running Macros
Sum
Product
Average
Ceiling
Floor
Round
Round Up
Round Down
Power
Count
Counta
Maximum
Minimum
Mode
Median
Log
Dollar
Average A
Mina
Maxa
Large
Sqrt
Mod
Roman
Rank
Rank Average
Rand
Rand Between
If
Nested if
SumIf
Sumifs
Averageif
Averageifs
Countif
Countifs
Or
Not
And
If error
If Function & Nested If Statements And & Or Functions
Maxifs
Minifs
Upper
Lower
Left
Right
Exact
Len
Mid
Concatenate
Proper
Trim
Substitute
Search
Find
Days360
Date
Network days
Now
Today
Weekday
Effect
Eomonth
Edate
Workdays
Datedif
Index
Match
Lookup
Choose
Offset
Offset with Match
Xlookup
Transpose
Hlookup For Single Worksheet
Vlookup For Single Worksheet
Hlookup & Vlookup For Multiple Sheet
Match and Find Record by Vlookup And Hlookup
Approximate Match with Vlookup
Exact Match with Vlookup
Nesting Lookup Function
Show Formula
Choose Function with Vlookup
Indirect
Pmt
Rate
Ppmt
Ipmt
Fv
Pv
Coupdays
Coupnum
Ispmt
Sln
Cumprinc
Cumipmt
Ddb
Db
Received
Daverage
Dproduct
Dmin
Dmax
Dcount
Dsum
Dget
Creating a Chart with the 2D or 3D
Create Column Chart, Pie Chart
Create Pateros Charts
Create Speed- O-Meter Chart
Moving a Chart One to another Sheet
Resizing a Chart, Changing a Chart Type
Editing Chart Text, Modifying Chart Options
Formatting Category & Value Axis Data
Formatting a Data Series
Changing a Chart’s Source Data
Blank & Sample Templates
Adding Text Boxes
Edit, Copy, Cut & Move Text
Format Text Boxes
Add Slides & Change Layouts
Import or Reuse Slides
Arranging Slides
Themes & Backgrounds
Slide Navigation
Presentation Views
Formatting Text
Formatting Text
Formatting Paragraphs
Bullet & Numbered Lists
Capture Images & Insert Pictures
Photo Album
Drawing Shapes
Advanced Shapes
Merge Shapes
WordArt
SmartArt Graphics
Crop, Resize & Style Objects
Formatting Objects
Grouping Objects
Object Ordering & Layering
Gridlines & Guides
Insert & Formatting Tables
Insert Table from Word
Manipulating PowerPoint Tables
Inserting a Word Table
Inserting an Excel Spreadsheet
Adjusting Rows, Columns, Cells
Table Styles and Borders
Inserting a Chart
Working with Datasheets
Applying a Chart Type, Style and Layout
Displaying Chart Analysis
Picture Charts
Formatting Chart Background
Creating a Custom Layout
Applying a Theme
Applying a Background Style
Saving a Custom Theme
Arranging and Printing Section
Slide Master
Background Graphics
Custom Slide Layouts
Advanced Custom Themes
Add Headers & Footers
Modify Notes Master
Edit Handout Master
Create Custom Template
Slide Master, Title Master
Formatting the Masters
Adding Header and Footer Information
Notes and Handout Masters
Animation Schemes
Animating Text and Objects
Custom Animations and timing
Inserting Sounds and Video
Editing Media Clips
Setting Automatic Slide Timings
Setting Up a Continuous Loop
Hiding a Slide
Rehearsing Slide Transition Timings
Creating a Custom Show
Setting Up a Custom Show as the Default
Creating a Hyperlink
Using a Hyperlink
Using an Action Buttons
Jumping to Another Presentation
Embedding the Fonts in a Presentation
Using the PowerPoint Viewer
Formatting a Presentation for the Web
Inspecting the Document
Annotating a Presentation
Sending in PDF Format
Inserting a SmartArt Object
Formatting a SmartArt Object Color
Resizing/Repositioning a SmartArt Object
Inserting Text into a SmartArt Object
Formatting Text Within a SmartArt Object
Adding Shapes to a SmartArt Object
Grouping SmartArt Objects
Inserting Pictures from a File
Adding Captions
Applying a Theme to your Album
Customizing the Album Layout
Insert, Trim, Fade & Bookmark Audio
Insert, Trim, Fade & Bookmark Videos
Advanced Animation
Motion Paths
Custom Slide Shows
Setup Slide Show & Presenter View
Secure PowerPoint Show
Hyperlinks
Action Buttons & Link Actions
Annotate
Record Narration
Rehearse Timings
Merge & Compare
Insert Comments
Slide Library
OneDrive & Coauthoring
Present Online
Create Video Files
Package Presentation
Publish to PDF or XPS
Document Properties
Document Inspector
Password Protect
Digital Signature
Mark as Final
Screen Recording
Closed Caption
Equations & Ink