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 »