Basic Computer Course

1. Basic Concept of Computer

2. English Typing

3. 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 Marge

Document Views & Macros

Saving & Protecting Sheets Documents

Project Work

4. Adv. Excel

Introduction (Ms. Excel Window/Interface Parts, File Extension, Ho

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

and many more…

5. MS PowerPoint

Creating & Printing Slides

Adding Custom Animation

Using Slide Transitions

Using Charts, Graphs & Photo Album

Creating Professional Presentation

Project Work

Internet

ntroduction to Internet

Browser Basics

Downloading, Searching, Surfing and Storing Data

Online Forms Submission

Online Bill Payment

Online Ticket Booking