MS OFFICE

MS OFFICE

COURSE DESCRIPTION

The candidate gets hands on experience on the MS-Office Suite which features an array of applications such as Excel, Word, PowerPoint etc. Knowledge and competence in using MS-Office and its various applications can help a student or a working professional have an extra edge in day to day activities such as school or office projects or assignments.

COURSE PREREQUISITES

Basic knowledge in computer operations is expected.

COURSE OBJECTIVE

To introduce the user to the Microsoft Office Suite including the database concepts, and to attain a good understanding of  the various applications present in the MS-Office. 

COURSE MATERIALS

Course materials will be provided in soft/hard copy format.

COURSE OUTLINE MICROSOFT WINDOWS

  • Computer Fundamentals.
  • Desktop Items, Keyboard Shortcuts.
  • Control Panel, Accessories, WordPad, Notepad.

MICROSOFT WORD

  • Introduction to MS Office , Understanding Menus.
  • Page Setup, typing, selecting and editing text, Tab key
  • Format font dialog box, page formatting, paragraphs & line spacing, Find & Replace, spelling & grammar, thesaurus, auto correct.
  • Bullets & Numbering, modifying, setting indents.
  • Multilevel Numbering and Bullets.
  • Inserting text box, positioning, formatting, header and footers, page number.
  • Footnote, Endnote, header, footer, symbols
  • Columns, changing width of the column, column break, drop cap, Changing the default measurement.
  • Table, table layout, add columns and rows, removing gridlines, borders.
  • Tables, Merge cells, calculation using functions.
  • Inserting shapes, word art, lines, arrows, shadow, shading, flow chart shapes.
  • Working with templates.
  • Recording Macros.
  • Mail merging.

MICROSOFT EXCEL

  • Introduction to Excel, Understanding Menus .
  • Building worksheet, Entering data, Editing, Inserting and deleting rows and columns, Increasing and decreasing row height and column width, Auto fill, Auto sum, Copy and paste, Currency, Naming a sheet.
  • Formulas, Increasing and decreasing decimals.
  • Relative and absolute reference.
  • Function Wizard- Average, Min, Max, Formatting cells.
  • Paste special as- Values, Transpose.
  • IF condition, Count IF, Nested IF condition. 
  • Creating embedded charts using chart wizard, layout.
  • Copying ranges between worksheets, Freeze Panes.
  • Consolidation .
  • PMT, Goal Seek.
  • What If Data Table, One input and two input.

MICROSOFT POWERPOINT

  • Creating Title and bulleted list style.
  • Using Slide view ,Outline view ,Slide Master.
  • Working with objects, changing the layout or template.
  • Working with objects, changing design, Slide sorting.
  • Selecting, aligning, and changing the appearance of text.
  • Inserting graph, table and Smart art graphics.
  • Transition effects.
  • Custom animation, Pointer options, PowerPoint show.

MICROSOFT ACCESS

  • Creating Database, Designing a table, Editing and adding field names.
  • Creating forms, layout view and print preview.
  • Creating Reports, Report Wizard, Form Wizard, Sorting fields, Hide and unhide field names.
  • Creating Query, Using different criteria’s.
  • Relationship, Form with Sub forms, Combined Query.
  • Updating Query.

MICROSOFT OUTLOOK

  • Configuring an Outlook account, Creating E-Mail-CC and BCC, Draft.
  • Creating an appointment, forwarding, follow-up, To do list, Scheduling

.

INTERNET & E-MAIL

  • Internet and E-Mail - Browsers, Search engines, URL.
  • Web mail, Creating E- mail account, IMs, Social Networking, Voice and Video chat.