• Phone +91 8093056713 / +91 7504424342
  • contact@mainstreaminstitute.in

Computer Course

computer course in bhubaneswar

Join Best Computer Institute for DCA, MS Office &Advanced Excel Training in Bhubaneswar

computer knowledge is essential in today's digital age. You can boost your career prospects by having a solid foundation in , Microsoft Office and Advanced Excel.

We offer a Diploma in Computer Application (DCA), Bhubaneswar which covers Microsoft Office and Advanced Excel, as well as other essential computer skills. Our goal as a leading Computer Institute in Bhubaneswar is to provide students with Industry-relevant Knowledge and Hands-On Training that will enhance their career prospects.

Why choose Mainstream Institute for DCA, MS Office and Advanced Excel training?

  • Industry Experienced Trainers - Learn from experts with real world expertise.
  • Comprehensive Curriculum - Covers DCA and MS Office, from basic to advanced levels.
  • Hands On Learning : Practical exercises, real-life cases, projects and practical learning.
  • Industry Recognized Certification - Improve your resume and career prospects.
  • Job Support – Guidance for interviews and career options.
  • Flexible learning : Both classroom training and online training are available.

Our program is designed for both beginners and professionals.

Overview of the Course - What Will You Learn?

1. Diploma in Computer Application (DCA)

  • Basics for Computers- Basics in Hardware, Software, and Networking.
  • Operating Systems - Windows, file management, system utilities.
  • Internet & E-Mail – Browsing and email communication. Online safety.
  • Basic Concepts of Programming – Introduction to database management and coding.

2. Microsoft Office Training

  • MS Word - Document formatting, templates, mail merge.
  • MS Excel Data entry, formulas and functions, charts and pivot tables.
  • MS PowerPoint Slide creation, animations and business presentations.
  • MS Outlook: Email management, calendar management and task automation.

3. Advanced Excel Training

  • Data Analysis & Visualization - Charts, graphs, pivot tables.
  • Advanced Formulas VLOOKUP (VLOOKUP), HLOOKUP (HLOOKUP), IF, SUMIF and COUNTIF.
  • Macros & VBA Basics - Automating repetitive tasks.
  • Financial & Business Applications – Budgeting, forecasting and reports.

After completing the course, students will possess an in-depth understanding of DCA, MS Office and Advanced Excel. This will prepare them for a variety of job roles in finance, administration, IT and business analytics.

10 Frequently asked questions (FAQs), about our Computer Courses

1. What is a Diploma in Computer Application? (DCA )?

+

DCA is a professional short-term course covering basic and advanced computer skills. It's essential for students, professionals, and job seekers.

2. Who can enroll?

+

This course is ideal for:

  • Students who are looking to improve their technical skills.
  • Job Seekers Preparing for Office-Based Roles
  • Professionals with daily computer tasks.
  • Business Owners Managing documents and data

3.What are the benefits to your career of learning DCA or Advanced Excel?

+

You can become:

  • Data Entry Operator
  • MIS executive
  • Office Manager
  • Business Analysis
  • Accounts Assistant

4. How long is the course?

+

The modules can range from 3 months to 6 month in length, depending on their choice.

5. Do I need prior experience before I join this course?

+

No previous experience is necessary. The course begins with fundamental concepts, and then moves on to advanced topic.

6. Do I get a certificate after the course is completed?

+

Yes!

7. Does this course include practical?

+

Yes! We focus on practical learning with hands-on exercises.

8. Can I take this course online?

+

We offer classroom and online training for flexibility.

9. What industries require Microsoft Office &Advanced Excel?

+

computer literacy is required for industries like marketing, HR and logistics.

10. How do I register for the course?

+

Call us or register online via our website.

If you’re looking for a computer course in Bhubaneswar that enhances your job prospects and productivity , Mainstream Institute is the best place to start your journey.
Improve your computer skills and boost your career by taking professional computer training today at Mainstream Institute!

computer course in bhubaneswar
computer course in bhubaneswar

MS OFFICE - Course Content

MS WINDOWS, COMPUTER BASICS

  • Computer Basic, Creating Folder, Paint
  • Directories, input units, Output unit
  • Central Processing Units,
  • What is hard ware, what is Soft ware
  • Windows short cut keys

MS WORD

Module 1: Text Basics

  • Typing the text, Alignment of text
  • Editing Text: Cut, Copy, Paste, Select All, Clear
  • Find & Replace

Module 2: Text Formatting and saving file

  • New, Open, Close, Save, Save As
  • Formatting Text: Font Size, Font Style
  • Font Color, Use the Bold, Italic, and Underline
  • Change the Text Case
  • Line spacing, Paragraph spacing
  • Shading text and paragraph
  • Working with Tabs and Indents

Module 3: Working with Objects

  • Shapes, Clipart and Picture, Word Art, Smart Art
  • Columns and Orderings - To Add Columns to a Document
  • Change the Order of Objects
  • Page Number, Date & Time
  • Inserting Text boxes
  • Inserting Word art
  • Inserting symbols
  • Inserting Chart

Module 4: Header & Footers

  • Inserting custom Header and Footer
  • Inserting objects in the header and footer
  • Add section break to a document

Module 5: Working with bullets and numbered lists

  • Multilevel numbering and Bulleting
  • Creating List
  • Customizing List style
  • Page bordering
  • Page background

Module 6: Tables

  • Working with Tables, Table Formatting
  • Table Styles
  • Alignment option
  • Merge and split option

Module 7: Styles and Content

  • Using Build- in Styles, Modifying Styles
  • Creating Styles, Creating a list style
  • Table of contents and references
  • Adding internal references
  • Adding a Footnote
  • Adding Endnote

Module 8: Merging Documents

  • Typing new address list
  • Importing address list from Excel file
  • Write and insert field
  • Merging with outlook contact
  • Preview Result
  • Merging to envelopes
  • Merging to label
  • Setting rules for merges
  • Finish & Merge options

Module 9: Sharing and Maintaining Document

  • Changing Word Options
  • Changing the Proofing Tools
  • Managing Templates
  • Restricting Document Access
  • Using Protected View
  • Working with Templates
  • Managing Templates
  • Understanding building blocks

Module 10: Proofing the document

  • Check Spelling As You Type.
  • Mark Grammar Errors As You Type.
  • Setting AutoCorrect Options

Module 11: Printing

  • Page Setup, Setting margins
  • Print Preview, Print

MS EXCEL

Module 12: Introduction to Excel

  • Introduction to Excel interface
  • Understanding rows and columns, Naming Cells
  • Working with excel workbook and sheets

Module 13:Formatting excel work book:

  • New, Open, Close, Save, Save As
  • Formatting Text: Font Size, Font Style
  • Font Color, Use the Bold, Italic, and Underline
  • Wrap text, Merge and Centre
  • Currency, Accounting and other formats
  • Modifying Columns, Rows & Cells

Module 14: Perform Calculations with Functions

  • Creating Simple Formulas
  • Setting up your own formula
  • Date and Time Functions, Financial Functions
  • Logical Functions, Lookup and Reference
  • Functions Mathematical Functions
  • Statistical Functions, Text Functions.

Module 15: Sort and Filter Data with Excel

  • Sort and filtering data
  • Using number filter, Text filter
  • Custom filtering
  • Removing filters from columns
  • Conditional formatting

Module 16: Create Effective Charts to Present Data Visually

  • Inserting Column, Pie chart etc.
  • Create an effective chart with Chart Tool
  • Design, Format, and Layout options
  • Adding chart title
  • Changing layouts
  • Chart styles
  • Editing chart data range
  • Editing data series
  • Changing chart

Module 17: Analyze Data Using PivotTables and Pivot Charts

  • Understand PivotTables, Create a PivotTable
  • Framework Using the PivotTable and PivotChart
  • Create Pivot Chart from pivot Table.
  • Inserting slicer
  • Creating Calculated fields

Module 18: Protecting and Sharing the work book

  • Protecting a workbook with a password
  • Allow user to edit ranges
  • Track changes
  • Working with Comments
  • Insert Excel Objects and Charts in Word Document and Power point Presentation.

Module 19: Use Macros to Automate Tasks

  • Creating and Recording Macros
  • Assigning Macros to the work sheets
  • Saving Macro enabled workbook

Module 20: Proofing and Printing

  • Page setup, Setting print area, Print titles
  • Inserting custom Header and Footer
  • Inserting objects in the header and footer
  • Page Setup, Setting margins, Print Preview, Print
  • Enable back ground error checking
  • Setting AutoCorrect Options

MS POWERPOINT

Module 21: Setting Up PowerPoint Environment:

  • New, Open, Close, Save, Save As
  • Typing the text, Alignment of text
  • Formatting Text: Font Size, Font Style
  • Font Color, Use the Bold, Italic, and Underline
  • Cut, Copy, Paste, Select All, Clear text
  • Find & Replace
  • Working with Tabs and Indents

Module 22:Creating slides and applying themes

  • Inserting new slide
  • Changing layout of slides
  • Duplicating slides
  • Copying and pasting slide
  • Applying themes to the slide layout
  • Changing theme color
  • Slide background
  • Formatting slide background
  • Using slide views

Module 23: Working with bullets and numbering

  • Multilevel numbering and Bulleting
  • Creating List
  • Page bordering
  • Page background
  • Aligning text
  • Text directions
  • Columns option

Module 24: Working with Objects

  • Shapes, Clipart and Picture, Word Art, Smart Art
  • Change the Order of Objects
  • Inserting slide header and footer
  • Inserting Text boxes
  • Inserting shapes, using quick styles
  • Inserting Word art
  • Inserting symbols
  • Inserting Chart

Module 25: Hyperlinks and Action Buttons

  • Inserting Hyperlinks and Action Buttons
  • Edit Hyperlinks and Action Button
  • Word Art and Shapes

Module 26: Working With Movies and Sounds

  • Inserting Movie From a Computer File
  • Inserting Audio file
  • Audio Video playback and format options
  • Video options, Adjust options
  • Reshaping and bordering Video

Module 27: Using SmartArt and Tables

  • Working with Tables, Table Formatting
  • Table Styles
  • Alignment option
  • Merge and split option
  • Converting text to smart artModule

28: Animation and Slide Transition

  • Default Animation, Custom Animation
  • Modify a Default or Custom Animation
  • Reorder Animation Using Transitions
  • Apply a Slide Transition, Modifying a
  • Transition, Advancing to the Next Slide

Module 29: Using slide Master

  • Using slide master
  • Inserting layout option
  • Creating custom layout
  • Inserting place holders
  • Formatting place holders

Module 30: Slide show option

  • Start slide show
  • Start show from the current slide

Module 31: Proofing and Printing

  • Check Spelling As You Type
  • Setting AutoCorrect Options
  • Save as video
  • Save as JPEG files
  • Save as PowerPoint Show file
  • Print Preview, Print

Internet & E-Mail

  • What is Internet?, Receiving Incoming Messages
  • Sending Outgoing Messages, Email addressing
  • Email attachments, Browsing, Search engines
  • Text chatting, Job Searching
  • Downloading video and Music
  • Uploading Video or Music, Voice