Certificate in Computer Software

Duration: 4 Months

MS-Word

• Introduction to MS-Word
• Basic File Options
• Random Text & Keyboard Shortcuts
• Selection and Edit Selection
• Font Settings
• Advance Lists
• Paragraph Settings
• Find and Replace
• Tables & It's Usages
• Pictures, Shapes, SmartArt and Charts
• Quick Parts
• Drop Cap & Objects
• Symbols
• Page Backgrounds
• Page Setup
• A Complete Book Project
• Mail Merge
• Proofing & Languages
• Comments, Track Changes, Compare & Protection
• Views & Zooming
• Windows
• Macros

MS-Excel

• Introduction to Excel
• Basic Calculations
• Basic Functions
• Text Functions
• Date and Time Functions
• IF Condition
• Lookup Functions
• Mathematical Functions
• PMT Functions
• Conditional Formatting
• Cell & Table Formats
• Insertion and Deletion
• Sorting and Filtering
• Pivot Table and Pivot Chart
• Slicer & Timeline
• Cell Name Management
• Formula Auditing
• Calculations
• Import & Export Data
• Data Tools - Text To Column, Flash Fill, Remove Duplicates, Data Validation & Consolidate
• What If Analysis - Scenario Manager, Goal Seek & Data Table
• Group, Ungroup & Subtotal
• Sheet & File Protection
• Freeze Panes
• Macros

MS-PowerPoint