Highlights
Flexible timing
No travel
Record session
Low fee
Live tutor
No hassel
MS Office
MS Office, 2007/2010
Microsoft Office is the most extensively used software suite in business and office environment. It is necessary if you want to accomplish office operations efficiently, keep up to date with the skills demanded by many employers and explore great career prospects .We are now offering Expert Microsoft Office skills course bundle includes mostly used office modules together (ex: Ms. Word/Excel/ Power point/Outlook)
| Total Duration: 25 hours Cost : USD 250 |
| Course Content |
MS-Word |
| Creating a new word document: ● New, open, save, save-as ● Prepare, encrypt documents, restrict permissions etc Clipboard: ● paste ,paste special ,format painter Font: ● Using different fonts ● Subscript, superscript, ● Strikethrough, font colour ● Bold, italic, underline ● Styles of font Paragraph: ● exploring all the options of paragraph ● increase indent, decrease indent ,line spacing, sort Inserting: ● Inserting Clip Art ● Wrapping Text ● Inserting Pictures ● inserting charts ● Inserting smart art ● Inserting Drop Caps ● Inserting Symbols ● Inserting AutoShapes ● Inserting Comments ● Headers and Footers ● Page Numbers Tables: ● Inserting A Table ● Table Properties ● Formatting A Table ● Auto-Formatting a Table ● Text Orientation In Tables ● Table Formulas ● Sorting Columns In Tables ● Borders and Shading |
Links: ● Bookmarks ● Cross-references Page layout: ● working with themes(colour, font ,effects) ● margins, orientations size and columns ● page background ,page colour ,page borders ● paragraph indent and spacing ● Arrange options References: ● Citations and bibliography ● Captions ● Index Mailing: ● Creating envelopes and labels ● Creating recipients list ,select and merge ● Write and insert merge fields ● Rules ,match fields and update labels ● Previewing options Review: ● Proofing spell check and grammar ● Translating tips ● Research, word count etc ● Comment, linking comments ● tracking changes ,balloons ● accept and reject changes ● compare documents , show source documents ● Protect document Views: ● Page layout, web layout, outline, draft, ● show and hide options ● zooming options ● window options ,switch window |
MS-Excel |
|
| Topics covered in Excel 2007: ● Introduction to MS Office & Excel 2007 ● Features & Benefits of Excel application ● Work Environment of Excel 2007 ● Commonly Used Keyboard shortcuts ● Sheet Management ● Performing Calculations in Excel ● Difference between Relative and Absolute references ● Using Mathematical, Logical, Text, Date, statistical functions ● Referencing from cells from different worksheets and Workbooks. ● Assigning a Named Range ● Extracting values only from Formula cells ● Other important functions ● Formatting tables in Excel ● Techniques used to extend/clear formats ● Conditional Formatting ● Creating User Defined formatting styles and re-using them ● Setting the Print options ● Hyperlinks ● OLE (Embedding files as Objects in Excel) ● Creating a Data Series |
● Sorting tables ● Data Retrieval using Auto Filter ● Defining Validation Rules to maintain Data Accuracy ● Creating Pivot Tables / Charts ● Formatting Pivot Tables ● Extracting/Refreshing data in a Pivot Table ● Creating Charts in Excel to represent any data/statistics ● Choosing the chart type ● Formatting charts ● Introduction to VLOOKUP ● Benefits of using V lookup in real time ● How to use V lookup ● Using H LOOKUP ● Protecting Excel files with a password ● Protection Worksheets / workbooks ● Importing/Exporting in Excel ● Introduction to Macros ● Introduction to VBA for MS Excel ● How to record & edit Macros ● Skills required to develop macros in real time |
MS Power Point |
|
| Getting Started: ● Beginning A New Presentation ● Moving Around The Interface ● Saving Your Document ● Saving As A Webpage ● Spelling ● Inserting Slides ● Deleting Slides ● Changing The Background ● Selecting A Design Template Working With Different Views: ● Selecting Different Views ● Create Slides In The Outline View ● The Black And White View ● Creating Notes For Your Slides ● The Notes View ● The Slide Sorter View ● Zooming In and Out |
Working With Images And Objects: |
MS Outlook |
|
| ● Introducing Outlook 2007 ● Working with E-mail ● Managing Your E-mail ● Working with Contacts ● Using RSS Feeds and Instant Messaging ● Staying On Schedule with Calendar ● Getting Organized With Tasks and To-Do Items ● Managing Notes and Shortcuts ● Organizing, Managing, and Printing Information ● Backing up Information and Finding It Again ● Understanding and Working With Outlook Security ● Customizing Outlook |
|
