MS OFFICEÂ | |
MS OFFICEÂ | WORD |
1st lecture | Different Parts of a Computer |
 | What is a computer?. |
 | Difference between software and hardware |
 | Using a keyboard. |
 | Using the Mouse. |
 | Using a “desktop” |
 | What is an operating system? |
 | Using folders & files |
HOME TAB | Â |
2nd lecture | Clip board ,font, |
3rd lecture | Paragraph,syles |
4th lecture | Editing |
INSERT TAB | Â |
5th lecture | Pages and Tables |
6th lecture | Illustration |
7th lecture | Illustration |
8th lecture | links |
9th lecture | Comment, Header and Footer |
10th lecture | Text |
11th lecture | Text |
12th lecture | symbols |
DESIGN TAB | Â |
13th lecture | Document Formatting |
14th lecture | Page Background |
PAGE LAYOUT | Â |
15th lecture | Page Setup |
16th lecture | Page Setup |
17th lecture | Paragraph and Styles |
REFERENCE TAB | Â |
18th lecture | Tables of Content |
19th lecture | Footnote and Citations |
20th lecture | Captions and Index |
21st lecture | Table of Authorities |
MAILING TAB | Â |
22nd lecture | Mailing |
23rd lecture | Mailing |
REVIEW TAB | Â |
24th lecture | Proofing ,Language,Comment |
25th lecture | Tracking |
26th lecture | Tracking |
VIEW TAB | Â |
27th lecture | View,Show,Zoom, Window |
28th lecture | Macros |
 | EXCEL |
HOME TAB | Â |
29th lecture | Introduction to Excel,Clip board ,font, Alignment |
30th lecture | Number |
31st lecture | Styles |
32nd lecture | Styles |
33rd lecture | Styles |
34th lecture | Cell, Editing |
INSERT TAB | Â |
35th lecture | Sparklines,Reports,links,Text,Symbols |
PAGE LAYOUT TAB | Â |
36th lecture | Page Setup |
37th lecture | Scale to fit,Sheet Options |
FORMULAS TAB | Â |
38th lecture | sum,max,min,average,if (Mark sheet) |
39th lecture | nested formula using(sum,max,min,average,and,or) |
40th lecture | Assignment |
41st lecture | count,counta,countblank,countif,countifs,sumif,sumifs,etc |
REVIEW TAB/VIEW | Â |
64th lecture | Track Changes, Page views,Macros |
65th lecture | Practise and Doubts |
 | Power Point Presentation |
66th lecture | Introduction to PPT/how to make slides |
67th lecture | Full Presentation |
68th lecture | Assignment |
 | OutLook |
69th lecture | Introduction to OutLook |
70th lecture | installation and operating |
71st lecture | Mails,Calender,to-do-list,Contacts |
72nd lecture | Practise and Doubts |
73rd lecture | Practise and Doubts |
 | Exam |