Microsoft Access 2013 Getting Started & Creating Table in Urdu Lecture No. 1

Urdu I.T Point is proudly present Microsoft Access 2013 Getting Started & Creating Table in Urdu Lecture No. 1, in this lecture we are taking start for building database, we build desktop database for an organization. we start step by step so be patience until we finish MS Access 2013 training.

now watch our first lecture.

Microsoft Outlook 2013 Working with Calendar, Task & Notes in Urdu Lecture No 5 Last Lecture

Urdu IT Point is proudly introduce Microsoft Outlook 2013 Working with Calendar, Task & Notes in Urdu Lecture No  5 Last Lecture.

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

Microsoft Outlook 2013 Creating And Working With Contacts in Urdu Lecture No 4

Urdu IT Point proudly present Microsoft Outlook 2013 Creating And Working With Contacts in Urdu Lecture No  4. in this lecture you will learn that how to work with contact / edit, add to favourite, create group, send email to all at one, send email to specific peoples at once and many other feature of contact.

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

Microsoft Outlook 2013 Creating & Sending E-Mail in Urdu Lecture No. 3

Urdu IT Point is proudly present Microsoft Outlook 2013 Creating & Sending E-Mail in Urdu Lecture No. 3. you will learn the following thing from this tutorial.

Create Message
Reply & Forward
Formatting Message
Create Voting Button
Add Signature
Auto Reply When Out of Office
Exploring Delivery Option
Create Personal Stationery
Mail Option

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

Microsoft Outlook 2013 Reading & Organizing Email in Urdu Lecture No. 2

Urdu IT Point is proudly launch
Microsoft Outlook 2013 Reading & Organizing Email in Urdu Lecture No. 2.

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

Microsoft Outlook 2013 Getting Started with Outook Lecture No 1

Urdu IT Point the proudly introduce Microsoft Outlook 2013 Getting Started with Outook Lecture No  1.

after watching this lecture you will be able to configure email account in outlook, social media account & rss.

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

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"]

Microsoft Excel 2010 Managing List, Table & Groups in Urdu Lecture No. 6

Urdu IT Point in proudly present Microsoft Excel 2010 Managing List, Table & Groups in Urdu Lecture No. 6, in this lecture you will learn about Tables, Managing List & you will also learn about Grouping option, Group opting will allow you to calculate subtotal for each category.

in this lecture you will also learn about sorting data into ascending & descending Order.

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

if you cannot access YouTube the above lecture will not play & you need to use the Given below link for watch & download this lecture.

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

Microsoft Excel 2010 Using Templates, Styles & Auto Formats in Urdu Lecture No. 5

Urdu IT Point is proudly present Microsoft Excel 2010 Using Templates, Styles & Auto Formats in Urdu Lecture No. 5, in this tutorial you will learn that how to download templates, how to make any templates yours, how to make custom template. You will also learn about Styles, how to edit, apply, delete and create styles. You will learn about Auto Format, Subscript & Super Script.

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

if you cannot access YouTube the above lecture will not play & you need to use the Given below link for watch & download this lecture.


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

Microsoft Excel 2010 Advance Formatting in Urdu Lecture 4

Urdu IT Point is proudly introducing Microsoft Excel 2010 Advance Formatting in Urdu Lecture No. 4, in this lecture you will learn about that how to remove duplicates, how to copy unique data, how to apply, manage and find conditional format as well as you will also learn about data validation.

hope you all will enjoy Advance Formatting in Excel.

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

if you cannot access YouTube the above lecture will not play & you need to use the Given below link for watch & download this lecture.

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

Microsoft Excel 2010 Basic Formatting In Urdu Lecture 3

Urdu IT Point is proudly introducing Microsoft Excel 2010 Basic Formatting In Urdu Lecture 3 in this video you will learn that how to increase, decrease rows & columns size, different type of formatting such as number, currency, accounting, date & time etc etc, data alignment & printing lines.

if you cannot access YouTube the above lecture will not play & you need to use the Given below link for watch & download this lecture.

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

Microsoft Excel 2010 Modifying Worksheet in Urdu Lecture 2

Urdu IT Point is proudly introducing Microsoft Excel 2010 Modifying Worksheet in Urdu Lecture 2 in this video you will learn about that how to insert row, column in Microsoft Excel 2010, you will also learn that how to delete rows & columns as well as shift cell right, left and shift cell up. 

if you cannot access YouTube the above lecture will not play & you need to use the Given below link for watch & download this lecture.

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

Microsoft Excel 2010 Getting Started Lecture 1

Urdu IT Point is proudly introducing Microsoft Excel 2010 Getting Started Lecture 1 this is our first lecture of Microsoft Excel 2010, in this video you will learn about that how to create series, numbering, Excel Calculation Sequence & some basic formulas.

if you cannot access YouTube the above lecture will not play & you need to use the Given below link for watch & download this lecture.

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

Microsoft Word 2010 Working With Long Documents Last Lecture

Urdu IT Point is proudly introducing Microsoft Word 2010 Working With Long Documents Last Lecture, this is last tutorial of Microsoft Word 2010, in this lecture you will learn about references, table of content, indexing,  footnote, endnote, bookmarks & hyperlinks.

Microsoft Word 2010 Working With Long Documents Last Lecture

Urdu IT Point is proudly introducing Microsoft Word 2010 Working With Long Documents Last Lecture, this is last tutorial of Microsoft Word 2010, in this lecture you will learn about references, table of content, indexing,  footnote, endnote, bookmarks & hyperlinks.