In this video tutorial you can learn Pivot Table in Microsoft Excel 2013 in Urdu Language and Hindi Language By Sir Muhammad Niaz. Pivot Table Pivot Table When you have a lot of data, it can sometimes be difficult to analyze all of the information in your worksheet. Pivot Tables can help make your worksheets more manageable by summarizing data …
Read More »Microsoft Excel Topic 66 Using Filter to Analyze Lists
In this video Learning tutorial you can learn in Microsoft Excel 2013 How to Use Filter to Analyze Lists in Urdu and Hindi Language by Sir Muhammad Niaz. Using Filter to Analyze Lists AutoFilter Use AutoFilter in Microsoft Excel 2013 to find values, show or hide values, in one or more columns of data. You can filter based on choices you …
Read More »Microsoft Excel Topic 65 Sorting List
In this video learning tutorial you can learn in Microsoft Excel 2013 How to Sorting List Ascending Order Data, Descending Order Data in Urdu Language and Hindi Language By Sir Muhammad Niaz. Sorting List Sort The sort feature in Excel allows you to look at the same data in different ways depending upon what information you are after. Microsoft Excel allows …
Read More »Microsoft Excel Topic 64 Freeze Panes
In this video learning tutorial you can learn How to Freeze Panes Freeze Panes, Freeze Top Row, Freeze Top Column, Unfreeze Panes in Microsoft Excel 2013 in Urdu and Hindi Language By Sir Muhammad Niaz. Freeze Panes Freeze Panes Whenever you’re working with a lot of data, it can be difficult to compare information in your workbook. Fortunately, Excel includes several …
Read More »Microsoft Excel Topic 63 Working with Multiple Worksheets
In this video learning tutorial you can learn how to working with multiple workbooks/Sheets Windows in Microsoft Excel 2013 in Urdu and Hindi Language By Sir Muhammad Niaz. Working with Multiple Worksheets Workbook View Normal – View the document in Normal view. Page Layout – View the document as it will appear on the printed page. Use this view to …
Read More »