+91 8053074185     admin@veertutorial.com
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 × 8 × 1 cm

Reviews

There are no reviews yet.

Be the first to review “MS Office 2010 Basic to Advance Video Training DVD”

This site uses Akismet to reduce spam. Learn how your comment data is processed.

All right reserved VeerTutorial