Microsoft Excel 2010 Statistical Functions in Urdu Lecture No 15

Urdu IT Point is proudly present Microsoft Excel 2010 Statistical Functions in Urdu Lecture, in this video you will learn that how to calculate rank in ascending & descending order, how to calculate median, average, maximum value, minimum value, second, third fourth largest value as well as second, third fourth small value.

for further query contact us at; urduitpoint@gmail.com

Microsoft Excel 2010 Power Functions in Urdu Lecture No 14

Urdu IT Point is proudly present Microsoft Excel 2010 Powers Functions, in this lecture you will learn about the given below functions:

1. sumif
2. sumifs
3. countif
4. countifs
5. averageif
6. averageif

above funtion is use for conditional sum, count and average. the function whose end with "s" is use if you have multiple condition.

to learn or further information see the below lecture.

if you have anyquery regarding our lecture feel free to contact us at urduitpoint@gmail.com

Microsoft Excel 2010 Lookup and Reference Function in Urdu Lecture 13

Urdu IT Point proudly launch Microsoft Excel 2010 Lookup and Reference Function in Urdu Lecture 13, in this lecture you will learn about some advance Microsoft Excel 2010 functions, such as vlookup, hlookup, trim, match & index.

you will also learn about that how to use multiple vlookup function to calculate tax.

[youtube http://www.youtube.com/watch?v=392y3EC5ZJM]

for any query you can contact us at:

urduitpoint@gmail.com

Owner & Founder of Urdu IT Point

Excel 2010 Formulas and Functions

One of Excel's most useful features is that it allows users to create custom formulas to perform calculations on their data. Excel also contains built-in formulas called functions that make it easy to perform common calculations on data. Here you will find step by step tutorials, tips and shortcuts on how to use formulas and the common and less common functions available in Excel. 

Formula Basics

Formulas in Microsoft Excel begin with an equal sign. The equal sign tells Excel that the succeeding characters constitute a formula. If you don't enter the equal sign, Excel will treat your entry as text and the calculation will fail. 

To show how formulas work, we'll begin with a simple exercise by selecting blank cell A1. Then type =5+5, and press Enter. Excel performs the calculation and produces a result of 10 in cell A1. 

Notice the formula bar shows the formula you just typed. What appears in the cell is the result; what appears in the formula bar is the underlying value, which is a formula in this case.

Order of Operation 

When performing calculations in a formula, Excel follows certain rules of precedence:  Excel calculates expressions within parentheses first.  Excel calculates multiplication and division before addition and subtraction.  Excel calculates consecutive operators with the same level of precedence from left to right. 

For example, the formula = 10+10*2 gives a result of 30 as Excel multiplies 10 by 2 and then adds 10. However, the formula =(10+10)*2 produces a result of 40. This is because Excel calculates the expression (10+10) within the parentheses first. It then multiplies by 2. 

If you are unsure of the order in which Excel calculates, use parentheses - even if the parentheses aren't necessary. Parentheses also make your formulas easier to read. 

Operations in Formulas 

:	Colon
,	Comma
-	Negation (as in -1)
%	Percent
^	Exponentiation
*	Multiplication
/	Division
+	Addition
-	Subtraction & Connects two strings of text
=	Comparison (Equal to)
<	Less Than
>	Greater Than
>=	Greater Than or Equal to
<=	Less Than or Equal to
<>	Not Equal to

Microsoft Excel 2010 Cell References & If Related Functions in Urdu Lecture 12

Urdu IT Point is proudly launch Microsoft Excel 2010 Cell References & If Related Functions in Urdu Lecture 12, in this lecture you will learn about cell references such as absolute and other references which is given below:

$A$2

A$2

$A2

you will also learn about the IF function, AND function & or function. you will learn that how to use multi IF Conditions, combine IF & or function.

if you want to learn above mentioned things, watch the below video.

for any query contact us at urduitpoint@gmail.com

Microsoft Excel 2010 Formula and Function Tips and Shortcuts in Urdu Lecture No 11

Urdu IT Point is proudly launch Microsoft Excel 2010 Formula and Function Tips and Shortcuts in Urdu Lecture No 11.  in this lecture you will learn that how to copy formula without copy and paste even you have  1000 of rows.

if you have any query regarding above topic you can contact at urduitpoint@gmail.com

Microsoft Excel 2010 Getting Started with Formulas in Urdu Lecture No. 10

Urdu IT Point is proudly started Microsoft Excel 2010 Getting Started with Formulas in Urdu Lecture No. 10, in this lecture you will learn about Microsoft Excel Formulas / Functions, you will also learn about the calculation sequence, Autosum etc etc.