Address
051-6122937, 0311-5193625, 0092-335-4176949, Office # 27, Second Floor, Maryam Shadi Hall Plaza (Airies Plaza), Shamsabad, Murree Road, Rawalpindi, Pakistan 46000 View mapBasic Computer Course:
The computer is one of the major subjects you can consider pursuing to start your career. Computer courses are in high demand these days. It is one of the most far-reaching courses that can provide rewarding job opportunities. This could be a good opportunity for you, and that is why you should consider taking a computer course. Computer courses are designed to teach students the fundamentals of computers. it is divided into undergrad and postgrad computer degrees, online computer courses, and computer diplomas.
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, 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
- 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
-
6. Internet
-
-
- Introduction to Internet
- Browser Basics
- Downloading, Searching, Surfing and Storing Data
- Online Forms Submission
- Online Bill Payment
- Online Ticket Booking
-
