We will dispatch the device containing course content within 72 Hrs of purchase. This DVD may be used to get started and continue with the course.
|
System (Hardware/Software) Requirements
|
|
|
Operating Software
|
Windows XP with EI9, Windows 7 & above
|
|
Processor
|
Pentium IV
|
|
RAM
|
512 MB
|
|
Browser
|
IE9 & Above
|
Detailed Product Description
Learn Complete MS office
A. MICROSOFT WORD 2010
1. Introduction & Overview MS Word 2010
-
Introduction & Interface of MS Word 2010
1.2 Navigate the Document
2 Create New Document, Save & Print
2.1 Create New Document with Template
2.2 Convert old version document into MS Word 2010
2.3 Save & Share the Document
2.4 Send Document as Attachment with MS Outlook
2.5 Print & Print Setting of Document
3 Basic Commands for Formatting
3.1 Selection of Text
3.2 Cut, Copy & Paste
3.3 Clipboard – Advance
3.4 Undo & Redo
3.5 Find & Replace - Advance
4 Text Formatting & Effects
4.1 Font Formatting
4.2 Text Effect
5 Alignment Feature in MS Word
5.1 Alignment of Text
5.2 Line & Paragraph Adjustment
5.3 Indent of Paragraph
5.4 List
5.5 Keep Lines Together
6 Advance Text Formatting
6.1 Formatting with Style
6.2 Formatting with Theme
7 Tables in MS Word 2010
7.1 Create Tables to Handle Text
7.2 Convert Text to Table
7.3 Format Tables with Styles
7.4 Sorting Data in Tables
7.5 Design Form with Tables
7.6 Covert Table to Text
7.7 Insert Excel Sheet in Word document
8 Insert Picture, Smart Art & Word Art
8.1 Insert Pictures & Shapes
8.2 Resize and Arrange Pictures or Graphics
8.3 Insert Picture and Text in Tables
8.4 Picture Correction
8.5 Insert Chart
8.6 Smart Art
8.7 Word Art
9 Header & Footer, Cover Page & Text Box
9.1 Header and Footer
9.2 Custom Header and Footer
9.3 Cover Page
9.4 Text Box
10 Page Setup & Columns
10.1 Page Setup
10.2 Column
B. MICROSOFT EXCEL 2010
1 Introduction & Overview MS Word 2010
1.1 Introduction of Excel 2010
1.2 Move Action
1.3 Data Autofil in Cell
1.4 Numbers Customs Format
2 Text Formula
2.1 Cell Contain Text
2.2 Special Symbols
2.3 String Identical
2.4 Join Text
2.5 Format Text Values
2.6 Remove Space
2.7 Count Charactors
2.8 Padding A Number
2.9 Change Case
2.10 Extract Charctor
2.11 Remove Trailing Minus sign
2.12 Ordinal Numbering
2.13 First word Extract
2.14 Extract String Except First Word
3 Date Formula
3.1 Introduction of Dates in Excel
3.2 Date Autofil Tips and Formulas
3.3 Convert Non Date String to Date
3.4 Calculate Number of Days between two dates
3.5 Calculate Number of Working Days between two dates
3.6 Date Formulas
3.7 Date Value Formula
3.8 Network Days Formula
3.9 Working Days between Two Dates - Advance Verision
3.10 Offsetting a Date using only work Days
3.11 Number of years between two dates
3.12 Calculate Age of any person
3.13 Calculate Days Remain in a year
3.14 Weekday Determination
3.15 Calculate last Day of the month
4 Time Formula
4.1 Display Time
4.2 How to Sum of Hours
4.3 Number of Hours
4.4 Converting Decimal Hours, Minutes, Seconds into Time
4.5 Rounding of Time Values
5 Count Formula
5.1 Basic of Count formulas
5.2 Formula countif
5.3 Mode
5.4 Countif Text
5.5 Examples of Count
6 Sumif
6.1 Formula – Sum
6.2 Formula – Sumif
6.3 Formula – Sumifs
7 Lookup
7.1 Vlookup
7.2 Hlookup
7.3 Advance – Vlookup
7.4 Use of Vlookup with If
7.5 Use of Vlookup with Iferror Function
7.6 Vlookup Example – 1
7.7 Vlookup Example – 2
7.8 Vlookup Example – 3
8 Table
8.1 Introduction – Table
8.2 Fill in the Gaps
8.3 Advance Filter
8.4 Database Function
8.5 Sub Total
9 Logical Formula
9.1 Logical Formula
10 Security in Excel
10.1 Security : Part-1
10.2 Security : Part-2
11 Pivot Table
11.1 Pivot Table : Part-1
11.2 Pivot Table : Part-2
11.3 Pivot Table : Part-3
11.4 Pivot Table : Part-4
12 Page Setup & Print
12.1 Page Setup Header Footer
12.2 Page Setup
C. MICROSOFT POWER POINT 2010
1 Introduction & Overview Power Point
1.1 Create New Presentation
1.2 Adding New Slide to Presentation
1.3 Delete Slide & Change Layout
1.4 Saving Time with Outline Option
1.5 Separate the Show by Sections
1.6 Adding Pictures in Slides
1.7 Save Your Presentation
1.8 Apply Theme
2 Formatting of Slides
2.1 Text Formatting
2.2 Bullet List and Text Alignment
2.3 Picture Formatting
2.4 Remove Background from Picture
2.5 Understanding of Slide Master
2.6 Insert Picture or Logo in Background
2.7 Create Own Theme
3 Create Table & Chart
3.1 Create & Formatting of Table
3.2 Copy & Paste Table from Excel
3.3 Create Chart
3.4 Copy & Paste Chart from Excel
4 Use of Shapes, Text Boxes, Animation & Transition
4.1 Inserting Shapes
4.2 Inserting Text Box
4.3 Animation in Slides
4.4 Transition in Slides
5 Advance Features in Power Point
5.1 Smart Art - Organizational Chart
5.2 How to Print Slides
5.3 Convert Slides into PDF
5.4 Convert Slides into Video
D. MICROSOFT OUTLOOK 2010
-
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
Learn Everything, Anywhere, Anytime
India's Largest Online Education Marketplace
