True-commerce
The Institute of Professional Accountants

Address:- 4Th Floor, Malhar Mega Mall, Near C-21 Mall, A. B. Road, Indore (M.P.)-452010 India
Tel. +919300930066
Website: www.truecommerce.in
Email: info@truecommerce.in

Basic Computer Course including MS Word, MS Excel, MS Power Point

Duration:- 1Month

Topics:-

  • Computers and its basic operation
  • MS Office MSWord, MS Power Point, MS Excel , Outlook Express
  • Email, Chat and Internet

Key Features & Benefits:-

  • Learner becomes computer literate
  • Structured learning Process
  • Additional Practice sessions
  • Learning day to day operations.
  • Focus on practical operational knowledge of computers.
  • Basic features of MS Windows, Word, Excel, PowerPoint and Outlook.
  • How to using internet, email and chat

Important Features:-

  • Lowest Fee
  • Full Course covering every advanced topics
  • Experienced Corporate Trainer
  • Fully Air-condition class rooms
  • 1:1 computer training
  • Individual attention
  • Standard study material

Who Can Join?

  • 12th Pass student
  • Under Graduate
  • Graduate
  • House wife
  • Kids
  • Working people
  • Elderly people
  • MBA ( HR)
  • Working professionals
  • MIS Executives
  • MIS Personals
  • Freelancers

Course Detail
(MS Word)

Home Menu

  • New , open, save, save as, print settings
  • Cut, copy, & paste
  • Format painter
  • theme fonts
  • bold, italic, underline
  • font size, strikethrough
  • subscript, superscript
  • clear formatting, change-case
  • font color, text color
  • bullets & numbering
  • sort alphabets & numbers
  • bullets & numbering
  • sort alphabets & numbers
  • paragraph alignment
  • line spacing, shading
  • customize border
  • gallery of styles, change styles
  • find, replace & select

Insert Menu

  • Page break, blank page
  • Table, picture, clip art
  • Shapes, insert smart-art graphic
  • Insert chart, hyperlink
  • Bookmark, header, footer
  • Page number, text box
  • Word art, drop cap
  • Date& time, object
  • Symbol, autocorrect

Page layout menu

  • theme fonts, margins
  • page orientation, page size
  • columns
  • breaks, line numbers
  • watermark, page colour, page borders
  • indent settings, paragraph spacing
  • object position, text wrapping
  • endnote, footnote

Mailings

  • mail merge, letters, labels
  • step by step mail merge wizard
  • select & edit recipients lists
  • insert merge field
  • update labels, preview results
  • finish & merge

Review

  • spelling & grammar, research
  • thesaurus, word count
  • new, edit, & delete comment
  • track changes, accept & reject changes
  • protect document, restrict formatting & editing

View

  • print layout, full screen
  • web layout, outline, draft
  • view rulers, gridlines, thumbnails
  • zoom, one page, two pages, page width
  • new window, arrange all, split, view side by side, synchronous scrolling
  • switch windows, run macros

(MS Excel)

  • new, open, save, save as, print settings
  • cut, copy,& paste
  • format painter
  • fill color, change font face
  • bold, italic, underline
  • font size, strikethrough
  • subscript, superscript, font color
  • customize border
  • find, replace & select
  • cell alignment, orientation, wrap text
  • align text, merge & center, indents
  • number format, percent, comma style
  • increase & decrease decimal
  • conditional formatting, format as table
  • cell styles, insert, delete& format cells

Insert Menu

  • Pivot table, pivot chart, table
  • picture, clip art, shapes, smart art
  • column chart, hyperlink, text box
  • header & footer, word art, object, symbol
  • Page layout menu
  • theme fonts, colors, fonts
  • page margins, orientation, page size
  • print area, page break, background
  • page width, height & scale
  • gridlines, headings, object selection
  • bring to front, send to back, rotate

Formulas

  • auto sum, average, max, min, count
  • if, sum if, today, now, upper, lower
  • left, right, trim, true, false
  • ceiling, mround, round down, roundup
  • trace precedents, trace dependents
  • show formula, evaluate formula, watch window

Data

  • sort, filter, text to column
  • remove duplicates, data validation
  • consolidate, what if analysis
  • goal seek, scenario manager
  • subtotal, group, ungroup

Review

  • spelling & grammar, research
  • thesaurus, protect workbook
  • new, edit, & delete comment
  • track changes, accept & reject changes
  • protect sheet, restrict formatting & editing

View

  • page layout, normal, full screen
  • page break preview, custom views
  • view rulers, gridlines, formula bars
  • headings, zoom, new window, arrange all, freeze panes, hide, unhide, split
  • switch windows, macros

(MS Power Point)

Home Menu

  • new, open, save, save as, print settings
  • 2 cut, copy,& paste, format painter
  • new slide, layout, delete
  • bold, italic, underline
  • font size, strikethrough, text shadow
  • subscript, superscript
  • clear formatting, change-case
  • Character spacing, font color
  • bullets & numbering, text direction
  • paragraph alignment, align text
  • line spacing, columns
  • shapes, arrange, quick styles
  • shape fill, shape outline, shape effects
  • find, replace & select

Insert Menu

  • table, picture, clip art, photo album
  • shapes, smart art, chart, hyperlink
  • action, text box, header & footer
  • word art, date & time, slide number
  • symbol, object, movie, sound

Design

  • page setup, slide orientation
  • slide design, colors, fonts, effects
  • background styles, hide background graphics

Animation

  • preview, animate, custom animation
  • special effect, transition sound, transition speed

Slide Show

  • from beginning, from current slide
  • custom slide show, setup slide show
  • hide slide, rehearse timings, resolution

Review

  • spelling, research, thesaurus, translate
  • new, edit & delete comment
  • protect presentation

View

  • normal, slide sorter, notes page
  • view rulers, gridlines, slide show
  • zoom, fit to window, color ,grayscale
  • new window, arrange all,
  • switch windows, formatting tools

Advance MS Excel

  • Introduction and Basic Overview Working with Workbook and Worksheets Formatting Cells
  • Customized formatting of Cells
  • Cell References (Absolute, Relative & Mixed) Shortcut Keys
  • Other Features (Paste Special and finding and replacing data etc.)
  • Text Formulas (CONCATENATE, UPPER, LOWER,
  • PROPER,
  • DATE, MOD, MODE, TODAY, NOW) Inserting Comments
  • Use of Go to Feature
  • Use of ? to Join data in different cells Logical formula (IF function and its use) Conditional Formatting and its Use in different scenarios
  • Logical Complex Formulas (IF, OR, AND & IFERROR) Use of Nested IF formula with examples
  • Other Text Formulas (TEXT, CLEAN, TRIM, Len, T,
  • COUNT, COUNTA,
  • COUNTBLANK, COUNTIF, SUBTOTAL)
  • Defining Cell Range & Name Manager
  • Applying Auto filter Use of Advanced Filter
  • Displaying Unique Record by using Advanced Filter Freezing and Unfreezing Panes
  • Linking of Worksheets & Workbooks
  • Open websites, existing files etc by Inserting Hyperlink More useful formulas (RIGHT, LEFT, LEN, FIND, SUMIF & SUMPRODUCT) Formatting
  • Financial Formulas (PMT, PV, DISC, DB, IRR, NPV etc.) Text to Column to fetch data
  • Lookup & Reference cell Formulas (CELL, ADDRESS,
  • ROW, COLUMN,
  • LOOKUP, VLOOKUP, HLOOKUP, MATCH, OFFSET,
  • SUMPRODUCT,

MICROSOFT OUTLOOK

  • Touring the Outlook Interface
  • Using E-mail
  • Creating Signatures & New Folders
  • Using a Calendar & Adding Events
  • Working with Multiple Calendars
  • Sharing Calendars
  • Adding & Viewing Contacts
  • Creating, Viewing & Flagging Tasks

TYPING SKILLS

  • Hindi Typing (20-30 Word Per Min)
  • English Typing (20-30 Word Per Min)
  • Typing Practice with Typing Tutor

SOCIAL, PROFESSIONAL & OFFICIAL USE OF INTERNET

  • Email Account and Attach Files, surfing, downloading and Uploading, Online Working Internet
  • Online Banking
  • Online Billing , Mobile, Electric, Travelling, Hotel, Marketing, E-Buying etc
  • Booking, Online Payments, Online Forms Filling, Result valuation, Online
  • Shopping, Surfing & Downloading of System Software &Tools)
  • Voice chatting, video conferencing Face book, Twitter, Linked in, Orkut,
  • Google+, YouTube, Rediff BOL, yahoo Messenger, Google chrome, Google Talk’s installation / Uses
  • Online Reservation, Booking, Online Payments,
  • Surfing & Downloading of System Software & Tools)

CAREER PROSPECTS

  • Computer Operator
  • Front Office Executive
  • Customer Support Executive
  • Back Office Executive
  • Back Office Operator
  • Office Executive
  • Office Assistant
  • Data Entry Operator
  • Data Support Executive
  • Cash Counter Executive
  • Bill Desk Executive
  • Operation Executive
  • Trainee in a Computer Institute
  • Computer Trainer
  • Application Support Executive
  • Computer Typist
  • Documentation Assistant
  • Team Leader
  • Customer Support Officer
Menu