MS Office 2010 Basic to Advance Video Training DVD

Description

MICROSOFT WORD 2010

• Introduction & Overview MS Word 2010
  • Introduction & Interface of MS Word 2010
  • Navigate the Document

• Create New Document, Save & Print
  • Create New Document with Template
  • Convert old version document into MS Word 2010
  • Save & Share the Document
  • Send Document as Attachment with MS Outlook
  • Print & Print Setting of Document
• Basic Commands for Formatting
  • Selection of Text
  • Cut, Copy & Paste
  • Clipboard – Advance
  • Undo & Redo
  • Find & Replace – Advance
• Text Formatting & Effects
  • Font Formatting
  • Text Effect
• Alignment Feature in MS Word
  • Alignment of Text
  • Line & Paragraph Adjustment
  • Indent of Paragraph
  • List
  • Keep Lines Together
• Advance Text Formatting
  • Formatting with Style
  • Formatting with Theme
• Tables in MS Word 2010
  • Create Tables to Handle Text
  • Convert Text to Table
  • Format Tables with Styles
  • Sorting Data in Tables
  • Design Form with Tables
  • Covert Table to Text
  • Insert Excel Sheet in Word document
• Insert Picture, Smart Art & Word Art
  • Insert Pictures & Shapes
  • Resize and Arrange Pictures or Graphics
  • Insert Picture and Text in Tables
  • Picture Correction
  • Insert Chart
  • Smart Art
  • Word Art
• Header & Footer, Cover Page & Text Box
  • Header and Footer
  • Custom Header and Footer
  • Cover Page
  • Text Box
• Page Setup & Columns
  • Page Setup
  • Column

MICROSOFT EXCEL 2010

• Introduction & Overview MS Word 2010
  • Introduction of Excel 2010
  • Move Action
  • Data Autofil in Cell
  • Numbers Customs Format
• Text Formula
  • Cell Contain Text
  • Special Symbols
  • String Identical
  • Join Text
  • Format Text Values
  • Remove Space
  • Count Charactors
  • Padding A Number
  • Change Case
  • Extract Charctor
  • Remove Trailing Minus sign
  • Ordinal Numbering
  • First word Extract
  • Extract String Except First Word
• Date Formula
  • Introduction of Dates in Excel
  • Date Autofil Tips and Formulas
  • Convert Non Date String to Date
  • Calculate Number of Days between two dates
  • Calculate Number of Working Days between two dates
  • Date Formulas
  • Date Value Formula
  • Network Days Formula
  • Working Days between Two Dates – Advance Verision
  • Offsetting a Date using only work Days
  • Number of years between two dates
  • Calculate Age of any person
  • Calculate Days Remain in a year
  • Weekday Determination
  • Calculate last Day of the month
• Time Formula
  • Display Time
  • How to Sum of Hours
  • Number of Hours
  • Converting Decimal Hours, Minutes, Seconds into Time
  • Rounding of Time Values
• Count Formula
  • Basic of Count formulas
  • Formula countif
  • Mode
  • Countif Text
  • Examples of Count
• Sumif
  • Formula – Sum
  • Formula – Sumif
  • Formula – Sumifs
• Lookup
  • Vlookup
  • Hlookup
  • Advance – Vlookup
  • Use of Vlookup with If
  • Use of Vlookup with Iferror Function
  • Vlookup Example – 1
  • Vlookup Example – 2
  • Vlookup Example – 3
• Table
  • Introduction – Table
  • Fill in the Gaps
  • Advance Filter
  • Database Function
  • Sub Total
• Logical Formula
  • Logical Formula
• Security in Excel
  • Security : Part-1
  • Security : Part-2
• Pivot Table
  • Pivot Table : Part-1
  • Pivot Table : Part-2
  • Pivot Table : Part-3
  • Pivot Table : Part-4
• Page Setup & Print
  • Page Setup Header Footer
  • Page Setup

MICROSOFT POWER POINT 2010

• Introduction & Overview Power Point
  • Create New Presentation
  • Adding New Slide to Presentation
  • Delete Slide & Change Layout
  • Saving Time with Outline Option
  • Separate the Show by Sections
  • Adding Pictures in Slides
  • Save Your Presentation
  • Apply Theme
• Formatting of Slides
  • Text Formatting
  • Bullet List and Text Alignment
  • Picture Formatting
  • Remove Background from Picture
  • Understanding of Slide Master
  • Insert Picture or Logo in Background
  • Create Own Theme
• Create Table & Chart
  • Create & Formatting of Table
  • Copy & Paste Table from Excel
  • Create Chart
  • Copy & Paste Chart from Excel
• Use of Shapes, Text Boxes, Animation & Transition
  • Inserting Shapes
  • Inserting Text Box
  • Animation in Slides
  • Transition in Slides
• Advance Features in Power Point
  • Smart Art – Organizational Chart
  • How to Print Slides
  • Convert Slides into PDF
  • Convert Slides into Video

MICROSOFT OUTLOOK 2010

1. Introduction & Configuration of Gmail in Outlook
2. How to Send New Email
3. Learn More about Outlook
4. Signature for New Email / Reply / Forward
5. Attach Outlook Item in Email
6. Select Theme
7. Out of Office Reply
8. Create Rules in Outlook – Advance Feature
9. Create Contacts
10. Lean Calendar in Outlook