CyberTech.pk have designed a complete professional course of Ms Excel in Urdu . We Claim that there is no course of ms Excel in Urdu like our course. In this course we have started from very basic of Ms Excel Urdu , and ended at complete professional level. In this Ms Excel Urdu Tutorials Course we have worked on Ms Excel in detail. We have teached doing all official work in Ms Excel how to print your work , how to customize your work and much more. We have teached different kind of formulas and teached that how to make your own formulas. We do hope that you will learn a lot from this course and will like this course and will give us a feedback. We pray for you success. May ALLAH bless you. |
|
Created By:
|
Cyber Tech Pakistan
|
|
Lessons:
|
62
|
|
Duration:
|
5 Hours
|
|
DVDs:
|
1 |
|
Format:
|
.MP4 (HD)
|
|
Language:
|
Urdu
|
|
Skills Required:
|
Basic Computer Knowledge.
|
|
Home-Delivery-Free:
|
in Pakistan Only
|
|
Available:
|
Yes
|
|
|
|||||||||
| Course Outlines | |||||||||
|
MS.Excel 2007 – Duration : 5 Hours
|
|||||||||
|
Chapter 1 – Introduction
|
|||||||||
|
1.
|
Welcome
|
2 | How to use exercise files | ||||||
|
Chapter 2. Formulas and functions tips-Shortcuts
|
|||||||||
|
3.
|
using entire row or column as reference
|
4.
|
Copying formulas instantly
|
5.
|
Converting formulas to values
|
||||
|
6.
|
Multiple sheets management
|
7.
|
Updating values without formula
|
8.
|
Showing formulas
|
||||
|
9.
|
Highlighting formulas
|
10.
|
Debugging formulas
|
11.
|
Naming cells and rangs
|
||||
|
Chapter 3. Excel Functions
|
|||||||||
|
12.
|
Data Understanding formula and functions
|
13.
|
Sum, Average, Max and min functions
|
14.
|
Extending autosum
|
||||
|
Chapter 4. If and related functions
|
|||||||||
|
15.
|
Simple If
|
16
|
Nested If
|
17.
|
Compound If
|
||||
|
Chapter 5. Lookup and Reference functions
|
|||||||||
|
18.
|
Looking up information
|
19
|
Using Vlookup for approximate values
|
20.
|
Exact match and trim
|
||||
|
21
|
Nested Vlookup
|
22
|
Choose function
|
23
|
Using match function for looking data
|
||||
|
24
|
Using index function to find a value
|
25
|
Match and index together
|
||||||
|
Chapter 6. Power Functions
|
|||||||||
|
26
|
Count If on single criteria
|
27
|
Sumif and average if on single criteria
|
28
|
on multiple criteria
|
||||
|
Chapter 7. Statistical Functions
|
|||||||||
|
29
|
Median function
|
30
|
Rank and count functions
|
31
|
Large and small function
|
||||
|
32
|
Count blank and count A functions
|
||||||||
|
Chapter 8. Date Functions
|
|||||||||
|
33
|
Understanding date and time
|
34
|
Weekday function
|
35
|
Network days functions
|
||||
|
36
|
Finding Completion date with workday function
|
37
|
Dated if
|
||||||
|
Chapter 9. Math Functions
|
|||||||||
|
38
|
Rounding in Maths |
39
|
Mod Function |
40
|
Rand and Rand between | ||||
|
41
|
Convert Function | ||||||||
|
Chapter 10. Array Formulas and Functions
|
|||||||||
|
42
|
Using Arrays for extending its capabilities |
43
|
Finding unique itmes with array formulas |
44
|
Using frequency distribution function | ||||
|
45
|
Transpose function | 46 | Growth and Trend Functions | 47 | Using array formula with Index and match functions | ||||
|
Chapter 11. Text Functions
|
|||||||||
|
48
|
Find and Mid |
49
|
Left and Right Function |
50
|
Trim Function | ||||
|
51
|
Using Concatenate with other functions |
52
|
Using Proper, Upper and Lower functions |
53
|
replace and substitute function | ||||
|
54
|
More Text functions | ||||||||
|
Chapter 12. Financial Functions
|
|||||||||
|
55
|
Using PMT for calculating monthly payments | 56 | Using Future values | 57 | Using PV function | ||||
|
Chapter 13. Information functions
|
|||||||||
|
58
|
Isblank Istext Isnumber and Isnontext functions |
59
|
Iferror and Iserror | 60 | Using offset function | ||||
|
61
|
Indirect function | ||||||||
|
Exercise Files
|
|||||||||
|
1.
|
Tips |
2.
|
Functions |
3.
|
IF | ||||
|
4.
|
Lookup |
5.
|
Power |
6.
|
Stat | ||||
|
7.
|
Date |
8.
|
Math |
9.
|
Array | ||||
|
10.
|
Text |
11.
|
Financial |
12.
|
Information | ||||