Master the Ins and Outs of Microsoft Office and Boost Your Productivity. Having Internet connection is must. The training is absolutely free. The course content is:
MS Word:
1 Ms Word Introduction
2 Ms Word Font Formatting
3 Paragraph Options
4 Bullets And Numbering
5 Sorting Option
6 Styles In Word - Heading Pattern
7 Page , Cover Page, Page Break
8 Creating Table In Word
9 Pictures In Ms Word
10 Shapes In Ms Word
11 Smartart In Ms Word
12 Chart And Screenshot
13 Bookmark And Cross Reference
14 Hyperlink In Word
15 Header And Footer And Page No
16 Text Box, Wordart, Drop Cap And Symbols
17 Quick Parts In Ms Word
18 Print Related Option
19 Watermark In Ms Word
20 Page Color And Page Border
21 Table Of Content
22 Biblography And Citation
23 Caption In Ms Word
24 Footnate And Endnote
25 Mark Entry In Ms Word
26 Mail Merge
27 Language And Proof
28 Track Changes In Word
MS Excel:
1 Excel Structure
2 Cell Properties
3 Autofill Val And Text
4 Autofill Date
5 Autofill Adv Tools
6 Cell Reference
7 Operators Based Equation
8 Math Function
9 Advance Math Function
10 Advance Math Function 2
11 Using Of Wild Card In Math Function
12 Text To Column
13 Workbook Protect
14 Protect Sheet
15 Hide Formulas And Unlocked Cell
16 Protect File With Password
17 Share Book
18 Print Option In Excel - Part 1
19 Print Option In Excel - Part 2
20 Pivot Table - Intro
21 Pivot Table - Manage Field Area
22 Pivot Table - Value Field, Report And More
23 Pivot Table - Slicer And Dublicate Pivot
24 Pivot Table - Group To Mange Date And Values
25 Pivot Table - Insert Calculated Field
26 Chart Preperation
27 Chart Preperation - Advance
28 Chart Preperation - Customize
29 If Function - Logical Test
30 If Function - With Equation And Task
31 If Function - Nested If
32 If Function - Advance
33 If Function - Adv 2
34 And , Or Function
35 And, Or, If Nested
36 And, Or Advance
37 Vlookup Function
38 Vlookup With Iferror
39 Vlookup Nesting With If
40 Hlookup
41 Match
42 Index And Match Nested
43 Vlookup Array
44 Vlookup Col Trick
45 Vlookup True
46 Advance Vlookup
47 Conditional Formatting
48 Conditional Formatting - Types Of Rules
49 Conditional Formatting - Mange Rules
50 Conditional Formatting - New Rules 1
51 Conditional Formatting - New Rules 2
52 Data Validation
53 Data Validation - Input Message And Error Alert
Powerpoint:
1 Intro - Layout And Section
2 Formatting And Manage Video
3 Text Box, Header And Footer
4 Slide Show Options
5 Design In Powerpoint
6 Transition Effect In Powerpoint
7 Animation In Powerpoint
Access:
1 Access Intro
2 Create Table In Ms Access
3 How To Import And Export In Access
4 Create Form From Table
5 Create Blank Form In Access
6 Creating Report In Access
7 Query In Access
9Apps 4.9
