Microsoft Excel Exercise 2 COUNTIF

In this video Learning tutorial you can learn how to Create attendance sheet in Microsoft Excel 2013 in Urdu and Hindi Language and you can also learn How to Calculate Total Attendance using COUNTIF Function, How to Calculate Percentage and Calculate Eligible and Not Eligible using IF Function. COUNTIF 5 DAYS ATTENDENCE PAGE Roll No. Name 1 2 3 4 5 Total Attendance % age …

Read More »

Microsoft Excel Exercise 1 Function

In this video Learning Tutorial you can Learn how to use Function (SUM, Average, Minimum, Maximum) in Microsoft Excel 2013 in Urdu and Hindi Language By Sir Muhammad Niaz.  Function Pakistan Printing Press (Expenditures 2013)             Department 1st Qtr. 2nd Qtr. 3rd Qtr. 4th Qtr. Total Engineering 25676 45451 54533 65651 191,311.00 Marketing 67567 43434 66554 54545 232,100.00 Computer …

Read More »

Microsoft Excel Topic 70 Password

In this video learning tutorial you can learn in Microsoft Excel 2013 How to Protect (Password) Workbook, Protect Worksheet, Protect Cells, Protect Rows, Protect Columns, Read Only Sheet, Modify Sheets, Encrypt Document, Encrypt Password, Encrypt Workbook, Encrypt Worksheet in Urdu Language and Hindi Language By Sir Muhammad Niaz. Password Password In Microsoft Excel 2013 you can use passwords to help prevent …

Read More »

Microsoft Excel Topic 69 Data Validation

In this Video Learning tutorial you can Learn in Microsoft Excel 2013 Data Validation, Input Message, Error Alert, Stop, Warning, Information, Error message, Validation Criteria, Any Value, Whole number, Decimal, List, Date, Time, Text, Length in Urdu Language and Hindi Language By Sir Muhammad Niaz. Data Validation Data Validation Data Validation is the best method to carry out your command. …

Read More »

Microsoft Excel Topic 68 Text to Columns

In this video Learning Tutorial you can Learn in Microsoft Excel 2013 how to Convert Text to Columns, , Flash Fill, Remove Duplicates, Delimited, Fixed width, in Urdu Language and Hindi Language by Sir Muhammad Niaz. Text to Columns Text to Columns If you need to separate content of one Excel Cell into columns, especially when all copied content are filled …

Read More »

Microsoft Excel Topic 67 Pivot Table

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 »

Microsoft Excel Topic 62 Paste Special

In this video Learning tutorial you can learn in Microsoft Excel 2013 How to use Paste Special in Urdu and Hindi Language by Sir Muhammad Niaz. Paste Special You can use paste options to control the type of content and formatting that’s included in the pasted cell range. Paste (P): Microsoft Excel 2013 pastes all the stuff in the cell selection (formulas, …

Read More »

Nero 2021 Latest & Old all Version Free Download

Nero Burning Software Cover

Nero is the Only Award Winning Burning Software. Nero Burning ROM offers you the most advanced disc burning solution. Nero Burning ROM – Leading CD, DVD and Blu-ray Disc burning and copying technology. When it comes to burning, accept nothing less than the industry’s best. Award-winning Nero Burning ROM is known for reliable, high-quality CD, DVD and Blu-ray Disc burning and copying. Loaded with …

Read More »

AVG Internet Security Free Download x86 and x64

AVG Internet Security: AVG best virus protection now includes new privacy features to protect your private data.  Protection  Detects and stops viruses, threats and malware Great easy to use protection everyone needs Our job is to stop viruses before they even get to your PC. We check your files before you open them, your Facebook links before you click, your email …

Read More »

Malwarebytes Premium Anti-Malware PRO Free Download

Malwarebytes Anti-Malware is an anti-malware application that can thoroughly remove even the most advanced malware. Malwarebytes products have a proven record of protecting computers by completely removing all forms of malware, including viruses, Trojans, spyware, adware and rootkits. When it comes to the safety of your computer, Malwarebytes provides the ultimate in protection from the cutting edge of technology! Malwarebytes …

Read More »

Microsoft Excel Topic 55 to 61

In this video Learning tutorial you can learn in Microsoft Excel 2010 Finding Data, Replacing Data, Spelling Check, Controlling the Appearance of Pages, Printing Sheets, Creating a New Chart, Formatting and Editing Charts in Urdu Language and Hindi Language By Sir Muhammad Niaz. YouTube Vimeo Microsoft Excel Topic Homepage

Read More »