Ms Excel 2007 and Ms Word 2003 both courses are now combined in 1 DVD , available at Rs 1150
MS Excel Course outline:
00-Course Intro 1:30
01-Interface 9:36
02- Interface-2 10:57
03- Quick Excess toolbar & Ribbon 6:37
04- Rename Sheets 3:15
05- Adding/Delegating Sheets 1:29
06- Adding/Delegating Cells, Rows, Columns 5:40
07- Review of Adding/Delegating Sheets, Cells, Rows, Column, 2:51
08- Resizing Cells/Columns/Rows 4:25
09- Review Resizing 2:47
10- Multiple Lines in one cell 2:58
11- Merge & Center 3:27
12- Merge Across 1:33
13- Merge Cells / Unmerge cells 1:05
14- Resizing Excel window 1:38
15- Text Orientation Options 3:19
16- Working with Fonts 7:07
17- Selecting Cells 3:24
18- Undo / Redo (Ctrl + Z) (Ctrl + Y) 3:56
19- Copy/Past, Cut/Past (Ctrl + C) (Ctrl + X) (Ctrl + V) 3:19
20- Copy & Past by Left Mouse Button + Ctrl 2:44
21- Paste as Picture 5:03
22- Picture Styles on Text 3:04
23- Auto Fill 3:06
24- Auto Fill Text 3:04
25- Auto Fill Numbers 2:32
26- Auto Fill Number sequence 2:56
27- Auto Fill Custom List 5:20
28- Insert Column & Row -1 3:12
29- Insert Column & Row -2 4:11
30- Strength of Excel 2:27
31- Formulas 4:34
32- Cell Address 3:14
33- Applying Formula-1 8:05
34- Applying Formula-2 4:23
35- Applying Formula-3 6:35
36- Applying Formula-4 3:56
37- Looking at formulas in work sheet 1:54
38- Function 5:53
39- Auto Sum 4:50
40- Auto Sum Keyboard Shortcut 3:06
41- More Functions 4:03
42- Adding Date 3:01
43- Cell Range 3:49
44- Filter 1:49
45- Formatting Date 2:53
46- Conditional Formatting-1g 5:27
47- Clearing Conditional Formatting 0:34
48- Conditional Formatting-2 3:43
49- Duplicate Values 1:46
50- Intro to “IF” Function 4:19
51- If Function-1 4:58
52- If Function-2 3:43
53- Percentage 3:23
54- Percentage 3:49
55- Complete Active work sheet 7:25
56- Printing 6:23
56.1- PDF file format 2:29
57- End 1:09
