Ms Excel 06: How to use MODE FORMULA IN EXCEL on onlineitskills
Hi every one!
Welcome to Online I.T Skills.
The First Online Institution Of Azad Kashmir for computer skills which provides free course with free downloadable materials online. Join today to be a skilled I.T Professional.
Courses:
1. Basic Computer Architecture and Networks.
2. Computer Hardware.
3. Computer Graphics Designing.
4. Desktop Applications Programming.
5. Web Development & Designing.
6. Android / IOS Application Development.
7. Game Development.
8. AutoCad / 3Ds Studio Max
This video:
If you like this video, here's my entire playlist of Excel tutorials: https://bit.ly/3iTjLpf
Learn the basics of using Microsoft Excel, including the anatomy of a spreadsheet, how to enter data, how to make your data look good so it's easier to read and use, and more. This tutorial was made using Excel 2016, but is applicable to older versions of Excel and newer versions too.
Finding exact number of notes needed for distribution of salary.
No of notes needed for distribution of salary.
In this video you will learn how to calculate notes for salary distribution.
Formula For Notes:
5000=INT(T5/5000) 1000=INT(MOD(T5,5000)/1000) 500=INT(MOD(T5,1000)/500) 100=INT(MOD(T5,1000)/100) 50=INT(MOD(T5,100)/50) 10=INT(MOD(T5,100)/10) 5=INT(MOD(T5,10)/5) 1=INT(MOD(T5,5)/1)
Download Lessons Exercise File:(ALL LESSONS)
http://bit.ly/2OOT1gw
Download File Auto Grade And GPA Tracker
http://bit.ly/2Zt5SXS
#UsefullFormulas
#dsum #sumif #countif #ifcondition
Microsoft Excel Complete Course, Learn Microsoft Excel Complete in Urdu/Hindi Language.
MS Excel Course In Urdu
Lecture 04 (Very Useful)
#PAYROLL #SALARY #ATTENDANCE #SALARYSLIP#OVERTIME #LEARNINGEXCEL
#LEARNINGEXCEL #LEARNINGMSEXCEL
#microsoftoffice #microsoft #excel #office #microsoftexcel #windows #powerpoint #microsoftword
Thanks for visiting
Online I.T Skills Mirpur Azad Kashmir
FaceBook: / onlineitskillsajk
Twitter: / onlineitskills1
~-~~-~~~-~~-~
Please watch: "How to change eye color with adobephotosho"
• How to change eye color in adobephotosho #...
~-~~-~~~-~~-~