• LOGIN
  • No products in the cart.

Sale!

MS Office 2010 Basic to Advance Video Training DVD

999.00 449.00

SKU: VT008 Categories: , , , , ,

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

 

Additional information

Weight 100 kg
Dimensions 12 x 8 x 1 cm

Reviews

There are no reviews yet.

Be the first to review “MS Office 2010 Basic to Advance Video Training DVD”
All right reserved VeerTutorial