Diploma in Computer Applications

Tags: MS-Office, Excel, Web Designing, Graphic Designing, basic, Diploma

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

HTML 5

Introduction to HTML, Document Structure, Meta Tags, Lists in HTML, Images in HTML, Hyperlinks, Tables, Forms in HTML, IFrame in HTML, Basic SVG, Audio & Video Tags, Entities

CSS 3

Where and Why we use CSS, Selectors of CSS, Colors in CSS, Backgrounds in CSS, Borders in CSS, Width and Height in CSS, Margins & Paddings, Fonts & Text Styling, Box Model, Display Property, Flexbox, Floating, Navbar Project, Card Projects, Banner Projects, Advance CSS Selectors, Transformations, Transition Animation, Advance Animation, Display Grid, Media Query

Photoshop

New File in Photoshop, Brush Tool, Layer Settings, Pen Tool, Shapes and Modifications, Tracing Project, Text Tool, Web Design Project, Visiting Card Project, ID Cards & T-Shirt Printing Project