Best Computer Institute in Bathinda

Introduction

• Objectives

• What is Computer?

• Basic Applications of Computer

• Components of Computer System

  • Other Input devices

  • Other Output devices

  • Computer Memory

  • Concept of Hardware and Software

    • Hardware

    • Software

      • Application Software

      • Systems software

• Bringing computer to life

  • Connecting keyboard, mouse, monitor and printer to CPU

    • Checking power supply

• The User Interface

  • • Task Bar

    • Icons

    • Menu

    • Running an Application

• Operating System Simple Setting

• Changing System Date And Time

• Changing Display Properties

• To Add Or Remove A Windows Component

  • Changing Mouse Properties

  • Adding and removing Printers

• File and Directory Management

  • Creating and renaming of files and directories

  • English Typing (Notepad)

UNDERSTANDING WORD PROCESSING

• Introduction

• Objectives

• Word Processing Basics

• Opening Word Processing Package

  • Menu Bar

  • Using The Help

  • Using The Icons Below Menu Bar

• Opening and closing Documents

  • Opening Documents

  • Save and Save as

  • Page Setup

  • Print Preview

  • Printing of Documents

• Text Creation and manipulation

  • Document Creation

  • Editing Text

  • Text Selection

  • Cut, Copy and Paste

  • Spell check

  • Thesaurus

• Formatting the Text

  • Font and Size selection

  • Alignment of Text

  • Paragraph Indenting

  • Bullets and Numbering

  • Changing case

• Table Manipulation

  • Draw Table

  • Changing cell width and height

  • Alignment of Text in cell

  • Delete / Insertion of row and column

  • Border and shading

• Summary

• Model Answers

• USING SPREAD SHEET

  • Introduction

  • Objectives

• Elements of Electronic Spread Sheet

  • Opening of Spread Sheet

  • Addressing of Cells

  • Printing of Spread Sheet

  • Saving Workbooks

• Manipulation of Cells

  • Entering Text, Numbers and Dates

  • Creating Text, Number and Date Series

  • Editing Worksheet Data

  • Inserting and Deleting Rows, Column

  • Changing Cell Height and Width

  • Formulas and Function

  • Using Formulas

    • Function 

Module 1 & 2

Module 1

• Fundamentals of computer

  1. Introduction

  2. Basic Applications of Computer

  3. Components of Computer System

  4. Block Diagram

  5. Central Processing Unit

  6. Input Output devices

  7. Keyboard shortcut

  8. Computer Memory

Concept of Hardware and Software

• 9. Hardware

  10. Software

  11. Application Software

  12. Systems software

The User Interface

• 13. Task Bar

  14. Icons

  15. Menu

Basic instruction.

• 16. Changing System Date and Time

  17. Changing Display Properties

  18. Changing Mouse Properties

  19. Adding and removing Printer

  20. File and Directory Management

  21. Creating and renaming files and directories.

Complete Notepad

Complete WordPad

• Microsoft Word

• Introduction

  1. 1 Common Buttons, Tabs and Ribbons

  2. 2 The Flashing Line

• Document Navigation Tips

  1. 1 Using the Slider

  2. 2 Keyboard Navigation Tips

  3. 3 Using Browse Objects Tools

  4. 4 Selecting Text Options

• Manipulating Text

  1. 1 Page Layout

  2. 2 Cut, Copy, Paste, Move

  3. 3 Find and Replace

• Formatting Characters

  1. 1 Changing Fonts

  2. 2 Typical Text Format Options

  3. 3 Bullet and Numbered Lists

  4. 4 Other formatting tools

• Formatting Paragraphs

  1. 1 Line Spacing

  2. 2 Quick Styles

  3. 3 Paragraph Marks

• Themes and Templates

  1. 1 Applying Themes

  2. 2 Opening Existing Templates

  3. 3 Creating Templates

  4. 3 Working with Existing Content

• Quick Parts

  1. 1 Quick Parts

  2. 2 Creating Quick Parts

  3. 3 Quick Parts - Inserting Fields

  4. 4 Quick Parts - Inserting Images

• Preparing Documents for Printing

  1. 1 Spelling and Grammar Check

  2. 2 Saving a Document

  3. 3 Printing and Preview Options

• Organizing Content

  1. 1 Creating Lists

  2. 2 Creating and Formatting Tables

  3. 3 Converting Text to Tables

• 4 Table Borders and Shading

  1. Tabs, Columns, and Charts

  2. 1 Creating Columns

  3. 2 Creating Tabular Lists

  4. 3 Creating Charts

     1. 1. 0 Links, Headers, and Footers

        2. 0.1 Creating Web Links

        3. 0.2 Creating Document Location Links

        4. 0.3 Email Links

        5. 0.4 Headers and Footers

• References

  1. Bookmarks

  2. Captions

  3. Footnotes

  4. Citations

  5. Reference Styles for Research

  6. Research Options

  7. Creating Indexes

  8. Bibliographies

• Mail Merge

  1. Mail Merge for Letters

  2. Mail Merge for Envelopes

  3. Mail Merge for Labels

  4. Visual Content

• Character Spacing

• Inserting Shapes

• Inserting Images

• Using Word Art

• Using Text Boxes

• Sorting Text

• Using Smart Art

• Reviewing Documents

  1. Document Views

  2. Split Screen View

  3. Tracking Changes

  4. Collaboration Options

  5. Combining and Approving Changes

  6. Using Comments

• Protecting and Sharing Documents

• Compatibility Checker

• Previous Work Versions Compatibility

• Digital Signatures

• Restricting Permissions

Microsoft Excel

• Introduction

• Complete home tab with

• Entering, Editing and Formatting Data

• Formatting Numbers

• Managing Worksheets

• Modifying Rows and Columns

• Changing Views

• AutoFill and Custom Lists

• Conditional Formatting

• Tables

• Practice with 40 Formulas

Sum, minus, divide, multiply, percentage, upper, lower, proper, counta, count if, count no, count blank, left, right, find, left and find, sum product, average, trim, today, now, =, abs, text, round, round up, round down, rank, frequency, minimum, maximum, if, index, match, some combine formulas etc. 

• Introduction to Charts

• Formatting Charts

• Header footer

• watermark

• Adding Graphics to Spreadsheets

• Outline, Sort, Filter, and Subtotal

• Protecting Data

• Collaboration

• Printing

• Outline, Sort, Filter, and Subtotal

Microsoft PowerPoint

• Introduction

• Applying Themes and Layouts to Slides

• Working with Objects

• Entering, Editing, and Formatting Text

• Outline View and Proofing Presentations

• Adding and Reading Notes

• Inserting Pictures, Graphics, Shapes, and Other Things

• Charts

• Adding Sound and Video

• Adding Transitions and Animation

• Working with Master Slides

• Working with Smart Art

• Printing, Sharing, and Exporting Slides

• Printing & Scanning

• Internet Knowledge

• 100% Course are Practical

Computer Module :- 

• Knowing Computer

• Making Small Presentation

• Computer Concept

• Knowledge for Operating System

• Paint (as per Basic Techniques)

• Notepad

• WordPad

• English Typing

• Advanced: - MS-Office

• MS-Word (Greeting/Poster/Brochures Design etc.)

• MS-Excel

Graphics and Designing :- 

• Corel Draw

• PhotoShop

• Printing & Scanning

• Internet Knowledge

• 100% Course are Practical

Excel Introduction

• An overview of the screen, navigation and basic spreadsheet concepts

• Various selection techniques

• Shortcut Keys

Customizing Excel

• Customizing the Ribbon

• Using and Customizing AutoCorrect

• Changing Excel’s Default Options

• Using Basic Functions

• Using Functions – Sum, Average, Max,Min, Count, Counta

• Absolute, Mixed and Relative Referencing

Formatting and Proofing

• Currency Format

• Format Painter

• Formatting Dates

• Custom and Special Formats

• Formatting Cells with Number formats, Font formats, Alignment, Borders, etc

Basic conditional formatting

• Protecting Excel

• File Level Protection

• Workbook, Worksheet Protection

Text Functions

• Upper, Lower, Proper

• Left, Mid, Right

• Trim, Len, Exact

• Concatenate

• Find, Substitute

Date and Time Functions

• Today, Now

• Day, Month, Year

• Date, Date if, DateAdd

• EO Month, Weekday

New in Excel 2013 / 2016 & 365

• New Charts – Tree map & Waterfall

• Sunburst, Box and whisker Charts

• Combo Charts – Secondary Axis

• Adding Slicers Tool in Pivot & Tables

• Using Power Map and Power View

• Forecast Sheet

• Sparklines -Line, Column & Win/ Loss

• Using 3-D Map

• New Controls in Pivot Table – Field, Items and Sets

• Various Time Lines in Pivot Table

• Auto complete a data range and list

Quick Analysis Tool

• Smart Lookup and manage Store

• Sorting and Filtering

• Filtering on Text, Numbers & Colors

• Sorting Options

• Advanced Filters on 15-20 different criteria(s)

Printing Workbooks

• Setting Up Print Area

• Customizing Headers & Footers

• Designing the structure of a template

• Print Titles –Repeat Rows / Columns

Advance Excel with MIS REPORT

• What If Analysis

• Goal Seek

• Scenario Analysis

• Data Tables (PMT Function)

• Solver Tool

• Logical Functions

• If Function

• How to Fix Errors – if error

• Nested If

• Complex if and or functions

Data Validation

• Number, Date & Time Validation

• Text and List Validation

• Custom validations based on formula for a cell

• Dynamic Dropdown List Creation using Data Validation – Dependency List

Mathematical Functions

• SumIf, SumIfs CountIf, CountIfs AverageIf, AverageIfs, Nested IF, IFERROR Statement, AND, OR, NOT

• Lookup Functions

• Vlookup / HLookup

• Index and Match

• Creating Smooth User Interface Using Lookup

• Nested VLookup

• Reverse Lookup using Choose Function

• Worksheet linking using Indirect

• Vlookup with Helper Column

Advanced Paste Special Techniques

• Paste Formulas, Paste Formats

• Paste Validations

• Transpose Tables

• Pivot Tables

• Creating Simple Pivot Tables

• Basic and Advanced Value Field Setting

• Classic Pivot table

• Choosing Field

• Filtering PivotTables

• Modifying PivotTable Data

• Grouping based on numbers and Dates

• Calculated Field & Calculated Items

Arrays Functions

• What are the Array Formulas, Use of the Array Formulas?

• Basic Examples of Arrays (Using ctrl+shift+enter).

• Array with if, len and mid functions formulas.

• Array with Lookup functions.

• Advanced Use of formulas with Array.

Charts and slicers

• Various Charts i.e. Bar Charts / Pie Charts / Line Charts

• Using SLICERS, Filter data with Slicers

• Manage Primary and Secondary Axis

Excel Dashboard

• Planning a Dashboard

• Adding Tables and Charts to Dashboard

• Adding Dynamic Contents to Dashboard

VBA Macro

• Introduction to VBA

• What Is VBA?

• What Can You Do with VBA?

• Recording a Macro

• Procedure and functions in VBA

Variables in VBA

• What is Variables?

• Using Non-Declared Variables

• Variable Data Types

• Using Const variables

Message Box and Input box Functions

• Customizing Msgboxes and Inputbox

• Reading Cell Values into Messages

• Various Button Groups in VBA

If and select statements

• Simple If Statements

• The Elseif Statements

• Defining select case statements

Looping in VBA

• Introduction to Loops and its Types

• The Basic Do and For Loop

• Exiting from a Loop

• Advanced Loop Examples

Mail Functions – VBA

• Using Outlook Namespace

• Send automated mail

• Outlook Configurations, MAPI

• Worksheet / Workbook Operations

• Merge Worksheets using Macro

• Merge multiple excel files into one sheet

• Split worksheets using VBA filters

• Worksheet copiers

• Desktop Skills

• Basic Skill For Operating System

• Advanced Level "MS office"

  • MS-Word

  • MS-Excel

  • MS-Powerpoint

  • MS-Access

  • MS-Outlook

  • Some Other For your Surprise.

• Printing & Scanning 

• 100% Course are Practical

• Introduction to English Typing 

• Keyboard Awareness Practice of Typing 

• Words, Sentence

• Passage for 30 w.p.m

• Typing Software For Improve Accuracy and Speed

• Statement

•   -Easy to doing work with help of internet

•  - Communication Skills

•  - Helpful To Government Exam

• 100% Course are Practical

• Introduction to Punjabi Typing 

• Keyboard Awareness Practice of Typing 

• Words, Sentence

• Passage for 30 w.p.m

• Typing Software For Improve Accuracy and Speed

• Statement

•   -Easy to doing work with help of internet

•  - Communication Skills

•  - Helpful To Government Exam

• 100% Course are Practical

• Introduction to Hindi Typing 

• Keyboard Awareness Practice of Typing 

• Words, Sentence

• Passage for 30 w.p.m

• Typing Software For Improve Accuracy and Speed

• Statement

•   -Easy to doing work with help of internet

•  - Communication Skills

•  - Helpful To Government Exam

• 100% Course are Practical

• Fundamental of Computer 

• Computer Software installation

• Computer hardware basic

• How to operate a Personal computer

• Concept of date entry 

• Typing with high accuracy speed

• Basic internet Concept 

• Networking Concept

• Graphics designing 

• Employability Skills

• Database management System 

• Advance 

  • Ms Word

  • PowerPoint 

  • Ms Excel 

• Web Page Designing.

• Knowledge About Internet Suffering

• About Google Chrome,Opera Mini Etc.

• Whatsapp, Facebook, Instagram, Gmail, Yahoo,Outlook etc.

• Create a Resume/ CV

• How to Prepare Project File With help Internet Searching 

• Convert PDF,WORD,JPG,PNG,etc.

• PDF Compressed

• How to Send Mail Data More than 25 + GB

• Create a Passport Size Photo( 4x6, A4 etc)

• Scanning Document Create JPG and PDF

• Download adhar Card

• How apply Pan Card

• How to get Mobile Number Linked With aadhar card

• Software updating and Installing

  • Ms-Office, Vlc Media, Acrobate Pdf Reader, Win Rar, Chrome, Etc

• How to Fill a Form for Private and Govt. Job Apply

• Download Admit Card, Syllabus and Result

• How to fill Form 5th,8th,10th and 12th Re-appear Form and alse check Result. 

• SEO (Search Engine Optimisation)

• Facebook Marketing

• Instagram Marketing

• Whatsapp Marketing

• Twitter Marketing

• Quora Marketing

• How to Create Post with Designing.

• Coral Draw

• Desktop & Computer Fundamentals

• Basic Skill For Operating System

• KNOWING COMPUTER

  • Introduction

  • Objectives

  • What is Computer?

  • Basic Applications of Computer

  • Components of Computer System

  • Central Processing Unit

  • Keyboard, mouse

  • Other Input devices

  • Other Output devices

  • Concept of Hardware and Software

  • Hardware

  • Software

  • Connecting keyboard, mouse, monitor

• UNDERSTANDING WORD PROCESSING

  • Introduction

  • Word Processing Basics

  • Opening Word Processing

  • Menu Bar

  • Using The Icons Below Menu Bar

  • Opening and closing Documents

  • Opening Documents

  • Save and Save as

  • Page Setup

  • Print Preview

  • Printing of Documents

  • Text Creation and manipulation

  • Document Creation

  • Editing Text

  • Text Selection

  • Cut, Copy and Paste

  • Spell check

  • 3.4.6 Thesaurus

  • Formatting the Text

  • Font and Size selection

  • Alignment of Text

  • 3.5.3 Paragraph Indenting

  • Bullets and Numbering

  • Changing case

  • Table Manipulation

  • Draw Table

  • Changing cell width and height

  • Alignment of Text in cell

  • Delete / Insertion of row and column

  • Border and shading

  • Page setup

  • Watermark

  • Page color

  • Alignment and indent

• USING SPREAD SHEET

  • Introduction

  • Objectives

  • Elements of Electronic Spread Sheet

  • Opening of Spread Sheet

  • Addressing of Cells

  • Printing of Spread Sheet

  • Saving Workbooks

  • Manipulation of Cells

  • Entering Text, Numbers and Dates

  • Creating Text, Number and Date Series

  • Editing Worksheet Data

  • Inserting and Deleting Rows, Column

  • Changing Cell Height and Width

  • 12 important formula

  • Using Formulas

• COMMUNICATIONS AND COLLABORATION

  • Introduction

  • Basics of E-mail

  • What is an Electronic Mail

  • Email Addressing

  • Using E-mails

  • Opening Email account

  • Mailbox: Inbox and Outbox

  • Creating and Sending a new E-mail

  • Replying to an E-mail message

  • Forwarding an E-mail message

  • Sorting and Searching emails

• MAKING SMALL PRESENTATIONS

  • Introduction

  • Basics

  • Using PowerPoint

  • Opening A PowerPoint Presentation

  • Saving A Presentation

  • Creation of Presentation

  • Creating a Presentation Using a Template

  • Creating a Blank Presentation

  • Entering and Editing Text

  • Inserting And Deleting Slides in a Presentation

  • Preparation of Slides

  • Inserting Word Table or An Excel Worksheet

  • Adding Clip Art Pictures

  • Inserting Other Objects

  • Resizing and Scaling an Object

  • Presentation of Slides

  • Viewing A Presentation

  • Choosing a Set Up for Presentation

  • Printing Slides And Handouts

  • Slide Show

  • Running a Slide Show

  • Transition and Slide Timings

• Printing & Scanning 

• 100% Course are Practical

• Create YouTube channel

• Create logo

• Create channel banner

• Create Video Thumbnail

• Record computer screen with free software

• Mobile and camera stand for video shooting

• Mic for recording Audio and Lighting tips

• Video Editing Tips

• Audio Editing Tips

• Video uploading on you tube

• You tube channel on mobile

• You tube Policies and Settings

• YouTube Community Guidelines

Introduction to Presentation Skills

• Fundamentals of Presenting

• Become an Effective Speaker

• Your Field of Communication

• Most Common Mistakes

• How to Present with Confidence?

• Planning and Structuring a Presentation

• Transitions

Using Presentation Methods

• Presentation Styles

• Preparing for the Data

• Preparing for Your Management

• Using What, Why and How to Write Your Presentation with Powerpoint

Create and Manage Presentations

• 1.1. Create a Presentation

• 1.2. Insert and Format Slides

• 1.3. Modify Slides, Handouts, and Notes

• 1.4. Change Presentation Options and Views

• 1.5. Configure a Presentation for Print

• 1.6. Configure and Present a Slide Show

Insert and Format Text, Shapes, and Images

• 2.1. Insert and Format Text

• 2.2. Insert and Format Shapes and Text Boxes

• 2.3. Insert and Format Images

• 2.4. Order and Group Objects

Insert Tables, Charts, SmartArt, and Media

• 3.1 Insert and Format Tables

• 3.2 Insert and Format Charts

• 3.3 Insert and Format SmartArt graphics

• 3.4 Insert and Manage Media

0Apply Transitions and Animations

• 4.1.Apply Slide Transitions

• 4.2.Animate Slide Content

• 4.3.Set Timing for Transitions and Animations

• MS Word Page setup Knowledge.

• Computer home tab

• Basic knowledge to apply shape, picture,Visiting card and Greeting card etc

• How can create chart

• Create a resume

• Create bank statement

• Knowledge about Page layout

• Some most useful shortcut keys in word.

• Alse Review and View tab 

Getting Started with Access

Topic A: Orientation to Microsoft Access

Topic B: Create a Simple Access Database

Topic C: Get Help and Configure Options in Microsoft Access

Working with Table Data

Topic A: Modify Table Data

Topic B: Sort and Filter Records

Querying a Database

Topic A: Create Basic Queries

Topic B: Sort and Filter Data in a Query

Topic C: Perform Calculations in a Query

Using Forms

Topic A: Create Basic Access Forms

Topic B: Work with Data on Access Forms

Generating Reports

Topic A: Create a Report

Topic B: Add Controls to a Report

Topic C: Enhance the Appearance of a Report

Topic D: Prepare a Report for Print

Topic E: Organize Report Information

Topic F: Format Reports

Designing a Relational Database

Topic A: Relational Database Design

Topic B: Create a Table

Topic C: Create Table Relationships

Sharing Data Across Applications

Topic A: Import Data into Access

Topic B: Export Data to Text File Formats

Topic C: Export Access Data to Excel

Topic D: Create a Mail Merge

Create and Manage Presentations

1.1. Create a Presentation

1.2. Insert and Format Slides

1.3. Modify Slides, Handouts, and Notes

1.4. Change Presentation Options and Views

1.5. Configure a Presentation for Print

1.6. Configure and Present a Slide Show

Insert and Format Text, Shapes, and Images

2.1. Insert and Format Text

2.2. Insert and Format Shapes and Text Boxes

2.3. Insert and Format Images

2.4. Order and Group Objects

Insert Tables, Charts, SmartArt, and Media

3.1 Insert and Format Tables

3.2 Insert and Format Charts

3.3 Insert and Format SmartArt graphics

3.4 Insert and Manage Media

Apply Transitions and Animations

4.1.Apply Slide Transitions

4.2.Animate Slide Content

4.3.Set Timing for Transitions and Animations

how to make a video 

Customize Outlook settings

Customize the appearance of the program window

Configure program options

Set defaults for outgoing messages

Create and assign automatic signatures

Configure options for multiple accounts

Practice tasks

Automate Outlook

Automatically reply to messages

Automatically process messages

Create and manage Quick Steps

Practice tasks

Print and save information in Outlook

View and save messages and attachments

Print Outlook items

Practice tasks

Search in Outlook

Search for items

Use Search Folders

Practice tasks

Objective review

Manage messages

Create messages

Course Syllabus | Microsoft Outlook Level I 1

Create and send messages

Configure message options

Respond to messages

Delegate access

Practice tasks

Format messages

Format text

Apply themes and styles

Apply styles

Create hyperlinks

Insert images

Manage schedules

Insert memorised content

Insert signatures

Practice tasks

Organize and manage messages

Categorize messages

Flag messages for follow-up

Manage conversations

Organize messages in folders

Manage junk email

Practice tasks

Objective review

Create and manage calendars

Configure calendar settings

Work with multiple calendars

Share calendar information

Practice tasks

Create appointments, meetings, and events

Create appointments and events

Create meetings

Manage calendar items

Practice tasks

Organize and manage appointments, meetings, and events

Configure settings for calendar items

Manage meeting options

Practice tasks

Create and manage notes, tasks, and journals

Create tasks

Manage tasks

Create and manage notes

Course Syllabus | Microsoft Outlook Level I 2

Create journal entries

Practice tasks

Manage contacts and groups

Create and manage contacts

Create and modify contact records

Store contact records

Share contact records and address books

Practice tasks

Create and manage groups

Practice tasks

• Computer Fundamentals

• Basic Skill For Operating System

• Computer Based

  • MS-Word

  • MS-Excel

  • Internet Knowledge 5-10 Days

  • SpreadSheet

• Tele caller

• Communication Skills

  • Easy to Conversation

  • Management Skills 

• SEO (Search Engine Optimisation)

• Facebook Marketing

• Instagram Marketing

• Whatsapp Marketing

• Twitter Marketing

• Quora Marketing

• How to Create Post with Designing.

• Printing & Scanning 

• 100% Course are Practical

• Computer Home Tab

• Pivot Table Advance Knowledge

• Create Attractive Dashboard

• Knowledge About Slicer

• Knowledge About Timeline

• Knowledge About Chart

• Final Report Create A Project

• Understanding Vba And Macro

• Variables & Data Type In Vba

• Working With If, And Or Nested If

• Loop And Nested Loop In Vba

• Real Job Project For Loops

• Error Handling In Vba

• Message And Input Box In Vba

• Working With Worksheet In Vba

• Understand Object And Class

• Understanding Array In Vba

• Project For VBA.

• Front Desk Receptionist 

• Computer Fundamentals

• Basic Skill For Operating System

• Professional Receptionist Training Course Objectives

• Create a Powerful First Impression

• Hot Telephone Tips

• Get the Facts- Ask the Right Questions

• Discuss Solutions- Learning to Listen

• Dealing With Difficult Customers

• Practice Good Telephone Skills

• Managing Database and Company Files

• Deal Effectively With Security and Safety Issues

• Successful Meetings & Minutes

• Arranging Business Travel and Accommodation

• How to send Email

• How to Use Social Media to Promote Your Company

• How to Write a Formal Letter

• How to Write Business Memo

• Business Writing and Memos

• Microsoft Excel

• MS PowerPoint Tips

• MS Word Tips & Tricks

• Microsoft Outlook

• Organising a Meeting

• Meeting Arrangements

• Booking or Reservation Procedure