Basic Computer Course

Basic Concept of Computer
English Typing
MS Word
- Font & Paragraph Formatting
- Editing, Saving & Printing Text Documents
- Inserting Table
- Header & Footer
- Smart Art
- Page Breaks
- Using List & Styles, Spelling & Grammar Check
- Understanding Document Properties & Tabs
- Mail Merge
- Document Views & Macros
- Saving & Protecting Sheets Documents
- Project Work
MS Excel
- Introduction (Ms. Excel Window/Interface Parts, File Extension, How to Open/Exit.)
- All Definitions ( Excel, Workbook, Worksheet, Cell, Row ,Column)
- Entering and Editing Data.
- Inserting and Deleting Row or Column.
- Formatting Data
- Auto fill Lists ( Default lists & Creating new lists)
- Simple formulas (SUM, AVERAGE, PRODUCT, COUNT, QUOTIENT, MAX, MIN, ABS, ROUND, PERCENTAGE etc.)
- Sort, Filter, Adv. Filter, Subtotal, Macros, Protect Sheet, Protect Cell, Text to Columns, Name Manager, What if Analysis
- Charts (Working With Charts)
- Logical Functions (IF, AND, OR, NOT, IFERROR)
- Financial Functions (PMT, PV, RATE, FV, DB)
- Lookup Functions (CHOOSE, HLOOKUP, VLOOKUP, INDEX, MATCH, TRANSPOSE, HYPERLINK, ROW)
- Math & Trig Functions (SUM, SUMIF, SUMIFS, RANDBETWEEN,ROMAN)
- Text Functions (CHAR, CODE, CONCATENATE, UPPER, LOWER, PROPPER, LEN, MID, SEARCH, TRIM)
- MIS Report (PIVOT TABLE, PIVOT CHART, V LOOKUP, HLOOKUP, ADV. FILTER, SLICER, SPARKLINES, CONSOLIDATE, CONVERT, ABS, SUMPRODUCT, FIND DUPLICATE, TEXT)
- Project Work
MS PowerPoint
- Creating & Printing Slides
- Adding Custom Animation
- Using Slide Transitions
- Using Charts, Graphs & Photo Album
- Creating Professional Presentation
- Project Work
Internet
- Introduction to Internet
- Browser Basics
- Downloading, Searching, Surfing and Storing Data
- Online Forms Submission
- Online Bill Payment
- Online Ticket Booking
- and many more..

Requirements

We expect some basic understanding of English.
No age restriction.
No academic requirement.

What is the target audience?

This course is intended for anyone interested in learning computer.
This course is aimed at beginners, so no previous experience with computer skills is necessary.
The candidate planning for Government Job must have complete CCC course to prove he is computer literate.

About Us

Welcome to Vcare Technical Institute, Delhi’s premier destination for aspiring coders. Renowned as the best institute for learning programming languages in the capital, we take pride in being the go-to choice for tech enthusiasts seeking excellence in coding. Read More

Basic Computer Course

Requirements

What is the target audience?

About Us

Laxmi Nagar Branch

Nirman Vihar Branch

Important Links

VTI Short-Term Courses

VTI Job Oriented Courses

VTI Long-Term Courses

VTI Advance Courses