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
- Introduction & Configuration of Gmail in Outlook
- How to Send New Email
- Learn More about Outlook
- Signature for New Email / Reply / Forward
- Attach Outlook Item in Email
- Select Theme
- Out of Office Reply
- Create Rules in Outlook – Advance Feature
- Create Contacts
- Lean Calendar in Outlook
Reviews
There are no reviews yet.