Skip to main content

Posts

Showing posts from August, 2021

How to Calculate Your Age in Excel with Video Tutorial by Sama Soyab

  Open Microsoft Excel -> Three Steps to Open MS Excel 1. Double Click on Ms Excel Icon 2. Start-> All Programs-> Microsoft Office -> Ms Excel 3. Start->Run-> Excel-> Ok  => Give The Column Name in First ROW Enter Detail Column A2,B2,C2 ->  Find Year : =DATEDIF(D5,TODAY(),"Y") DATEDIF formula use for find the difference between two dates. in the Age Calculation we use this function from Brithdate to Current Date. - D5 -> Is Cell Address where We entered Birth Date.  - TODAY() -> This Excel Formula which shows current date. - "Y" -> This is used for shows answer in Year Find Month : =DATEDIF(D5,TODAY(),"Y") DATEDIF formula use for find the difference between two dates. in the Age Calculation we use this function from Brithdate to Current Date. - D5 -> Is Cell Address where We entered Birth Date.  - TODAY() -> This Excel Formula which shows current date. - "YM" -> This is used for shows answer in Year

Learn Microsoft Outlook with Video Tutorial

  Search Topic : outlook starting in safe mode every time, outlook is starting but not opening, outlook starting problem, outlook is not starting on windows 10, when outlook is not opening, why microsoft outlook is not opening ,why ms outlook is used ,is ms outlook free, is ms outlook down, is ms outlook free to use, is outlook ms office, can ms outlook be used with gmail, can't open ms outlook, can't start ms outlook, can i buy ms outlook alone, can i download ms outlook for free, can i get ms outlook for free, can you buy ms outlook, can i reinstall ms outlook, when did ms outlook start, what do ms outlook icons mean, ms to do in outlook, do i need ms outlook, do not disturb ms outlook, what does ms outlook do, ms outlook do not forward, to do list ms outlook, ms outlook do not deliver before, does ms outlook work on mac, does ms outlook come with windows 10, does ms outlook have a dark mode, does ms outlook have instant messaging, why does ms outlook keep asking for password

Ms office Material for Competetive Exam and CCC & CCC Inservice & CCC Pluse Exam by Sama Soyab

  Download Full Pdf : Click Here

How to Create Marksheet in Excel and Excel Basic Formula with Video Tutorial

Open Microsoft Excel -> Three Steps to Open MS Excel 1. Double Click on Ms Excel Icon 2. Start-> All Programs-> Microsoft Office -> Ms Excel 3. Start->Run-> Excel-> Ok  => Fill the detail as above Image Enter Detail Column A to I ->  Total : =SUM(C4:I4) SUM formula use for Calculate Sum of Total Subject Mark - J4 -> Enter above Formula  =SUM(C4:I4)   Min : =MIN(C4:I4) Min formula use for Calculate Minimum Value of Subject Mark - K4 -> Enter above Formula  = MIN(C4:I4) Max : =MAX(C4:I4) Max formula use for Calculate Maximum Value of Subject Mark - L4 -> Enter above Formula  = MAX(C4:I4)   Average : =if(N4="Fail","***",AVERAGE(C4:I4)) Average formula use for Calculate Average Value of Subject Mark - M4 -> Enter above Formula  = =if(N4="Fail","***",AVERAGE(C4:I4))   Result : =If(K4>=35,"PASS","FAIL") IF formula use is Conditional Formula We are check If Minimum Marks is Greater Then