Microsoft Excel 2013 Manipulating Pivot Tables Using Macros & Printing Pivot Tables Lecture No 25 Last Lecture

Urdu IT Point proudly present Microsoft Excel 2013 Manipulating Pivot Tables Using Macros & Printing Pivot Tables Lecture No  25 Last Lecture.


for further query feel free to contact us at: urduitpoint@gmail.com

Microsoft Excel 2013 Creating and Manipulating Pivot Charts Lecture No 24

Urdu IT Point in proudly introduce Microsoft Excel 2013 Creating and Manipulating Pivot Charts Lecture No  24. in this lecture you will learn about that how to create pivot chart and pivot chart features.

for further query feel free to contact at : urduitpoint@gmail.com

Microsoft Excel 2013 Sorting, Filtering & Formatting PivotTable Data Lecture No 23

Urdu IT Point is proudly present Microsoft Excel 2013 Sorting, Filtering & Formatting PivotTable Data Lecture No  23.

for any query feel free to contact at urduitpoint@gmail.com

Microsoft Excel 2013 Summarizing Pivot Table Data Lecture No 22

Urdu IT Point proudly present Microsoft Excel 2013 Summarizing Pivot Table Data Lecture No  22.

for any query feel free to contact at: urduitpoint@gmail.com

Microsoft Excel 2013 Pivot Table in Depth Lecture No 21

Urdu IT Point is proudly launch Microsoft Excel 2013 Pivot Table in Depth.

for any query feel free to contact us at: urduitpoint@gmail.com

Microsoft Excel 2010 Analysis Data with Pivot Tables in Urdu Lecture No 20

Urdu IT Point proudly introduce Microsoft Excel 2010 Analysis Data with Pivot Tables in Urdu Lecture No  20 in this video you will learn about that how to analysis data with pivot table, this is very short introduction of pivot table in our next lecture we will start pivot table at advance level.

for further query feel free to contact at: urduitpoint@gmail.com

Microsoft Excel 2010 Working With Chart in Urdu Lecture No. 19

Urdu IT Point proudly launched Microsoft Excel 2010 Working With Chart in Urdu Lecture No. 19 in this lesson we will work with chart.

for any query feel free to contact at urduitpoint@gmail.com

you can also chat on Skype by adding above email address.

Microsoft Excel 2010 Information Functions in Urdu Lecture No. 18

Microsoft Excel 2010 Array & Text Function in Urdu Lecture No 17

Urdu IT Point proudly present Microsoft Excel 2010 array & text function in Urdu lecture no. 17, hope you will enjoy.

for any query feel free to contact us at : urduitpoint@gmail.com

Microsoft Excel 2010 Date & Time functions in Urdu Lecture No 16

Urdu IT Point proudly present Microsoft Excel 2010 Date & Time functions in Urdu Lecture No 16, in this lecture you will learn about the date & times function available in excel.

this lecture also helpful for companies administration department and project time keeper.

for any query feel free to contact us at:
urduitpoint@gmail.com

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.

Microsoft Excel 2010 Enhancing Workbook in Urdu Lecture No. 9

in this video tutorial you will learn about some feature to enhancing your worksheet.

if you cannot access YouTube the above link will  not work, so you have to use below link:
[office src="https://skydrive.live.com/embed?cid=3005ED9FFD07CD55&resid=3005ED9FFD07CD55%21140&authkey=AFRLSWgbJ4bVWWM" width="320" height="180"]

if you have any query you can contact the following email address:

urduitpoint@gmail.com

Microsoft Excel 2010 Printing Workbook in Urdu Lecture 8

in this video lecture you will learn that how to print workbook, worksheet, print specific area, adjust data into 1 page and much more hope you will enjoy.

for any query you can contact us at urduitpoint@gmail.com

if you cannot acees YouTube the above link will not work and you have to use the below link.


[office src="https://skydrive.live.com/embed?cid=3005ED9FFD07CD55&resid=3005ED9FFD07CD55%21139&authkey=ALV84xQoufPzdak" width="320" height="180"]

Microsoft Excel 2010 Proofing Document & Sharing Working in Urdu Lecture 7

in this lecture you will learn that how to proof read excel sheets and how to share workbook on network for multi user work at same file

if you have any query contact us at: urduitpoint@gmail.com

if you cannot access YouTube the above link will not work so you have to use the below link:



[office src="https://skydrive.live.com/embed?cid=3005ED9FFD07CD55&resid=3005ED9FFD07CD55%21138&authkey=AKa9C9dT9nDrY3U" width="320" height="180"]