Lec. No. 3 MS Excel in Urdu | Microsoft Excel | Excel Tutorial in Urdu | مائیکروسافٹ ایکسل سیکھیں

This Video Lecture is about Microsft Excel. I have taught #MSExcelinUrdu for beginners and students. In this video I have taught following concepts.
1. IF statement.
2. Nested IF statemen
3. Graphs
4. Filters
5. Macros
6. Different Features.
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect.
So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False.
For example, =IF(C2=”Yes”,1,2) says IF(C2 = Yes, then return a 1, otherwise return a 2).
Using a function as one of the arguments in a formula that uses a function is called nesting, and we’ll refer to that function as a nested function. For example, by nesting the AVERAGE and SUM function in the arguments of the IF function, the following formula sums a set of numbers (G2:G5) only if the average of another set of numbers (F2:F5) is greater than 50. Otherwise, it returns 0.
Nested functions
The AVERAGE and SUM functions are nested within the IF function.
You can nest up to 64 levels of functions in a formula.
Why Should I Learn Microsoft Excel?
We all deal with numbers in one way or the other. We all have daily expenses which we pay for from the monthly income that we earn. For one to spend wisely, they will need to know their income vs. expenditure. Microsoft Excel comes in handy when we want to record, analyze and store such numeric data.
Understanding the worksheet (Rows and Columns, Sheets, Workbooks)
A worksheet is a collection of rows and columns. When a row and a column meet, they form a cell. Cells are used to record data. Each cell is uniquely identified using a cell address. Columns are usually labelled with letters while rows are usually numbers.
A workbook is a collection of worksheets. By default, a workbook has three cells in Excel. You can delete or add more sheets to suit your requirements. By default, the sheets are named Sheet1, Sheet2 and so on and so forth. You can rename the sheet names to more meaningful names i.e. Daily Expenses, Monthly Budget, etc.
I am Muhammad Umer Abdullah, I am Trainer, Education Officer and Consultant. You can find more details on www. SirUmerAbdullah
Kindly Subscribe to my Channel also: / muhammadumerabdullah
Following are my interesting videos regarding Motivation and Personal Development:
10 Lessons Les Brown (Famous Motivational Speaker) learned in 40 Years in Urdu/Hindi • 10 Lessons Les Brown l...
Winner Vs Loser (Difference between Winner & Looser) in Urdu. • Winner Vs Loser (Diffe...
Never Ignore Small Happiness. These are the Life. Always be grateful to God. • Never Ignore Small Hap...
3 Rules of Successful Life, Urdu, Punjabi, Never Get Bored, Never Hesitate, Never Get Tired. • 3 Rules to make Life S...
How to Teach Your kids (in Urdu/Hindi) in Lockdown or at Home
• How to Teach Your kid...
How to Help in Lockdown? New Idea! Appreciation to all who helped in Corona Pendamic in Pakistan
• How to Help in Lockdow...
Lock Down Strategy & Learning
• Lock Down Strategy & L...
Tips for a Productive Day / How to get more stuff done during your day
• Tips for a Productive ...
Positive Thing about Pakistan / Ramadan Message
• Positive Thing about P...
Quit these 7 Habits Today یہ سات عادات آج ہی چھوڑ دیں
• Quit these 7 Habits To...
How to get Promotion in Job or Move to Next Level of Business. 10x Formula
• How to get Promotion i...
Sweden Study Visa Details in Urdu/Hindi from Pakistan
• Sweden Study Visa Deta...
We Cannot Buy Everything with Money | ہرچیزپیسے سے نہیں خریدی جاسکتی | in Urdu/Hindi
• We Cannot Buy Everythi...
Story No. 2 | One Story, Many Moral Lessons | سبق آموزکہانی عُمر کی زبانی
• Story No. 2 | One Stor...
Core Skills | 21st Century Skills | Skills necessary for Future | Core Skills British Council (Urdu)
• Core Skills | 21st Cen...
How to Plan Your Day | Structure Your Day | Working from Home | اپنے دن کو کیسے پلان کیا جائے • How to Plan Your Day |...
How To Make TH-cam Thumbnail in Urdu | Urdu Start Screen of TH-cam Video • How To Make TH-cam Th...
Lec. No. 1 MS Word in Urdu | Microsoft Word | Word Tutorial in Urdu / Hindi | مائیکروسافٹ ورڈ سیکھیں
• Lec. No. 1 MS Word in ...
Lec. No. 2 MS Word in Urdu | Microsoft Word | Word Tutorial in Urdu / Hindi | مائیکروسافٹ ورڈ سیکھیں
• Lec. No. 2 MS Word in ...
Lec. No. 3 MS Word in Urdu | Microsoft Word | Word Tutorial in Urdu / Hindi | مائیکروسافٹ ورڈ سیکھیں
• Lec. No. 3 MS Word in ...
How to Write Urdu in MS Word or any other Program | Urdu in MS Office | تمام پروگرامز میں اردو لکھیں
• How to Write Urdu in M...
How to make a Logo in 5 Minutes | Logo Making Online in Urdu/Hindi | Professional Logo Making
• How to make a Logo in ...
How to Speed Up Computer or Laptop | Speed Up Your PC | اپنے کمپیوٹر کی سپیڈ تیز کریں بغیر ونڈو کیے
• How to Speed Up Comput...
Visit: www. UmerAbdullahgorsi

[@seharnaeem9117]

Great videos for begginers

[@sadia973]

Explained well 👍

[@niazali4944]

Welcome sir

[@muhammadsafdar6165]

excellent completion of this important application

[@MuhammadUmerAbdullah]

شکریہ صفدر صاحب

[@kanwalshahzad100]

another great video sir. thankyu for letting us to do best in our quarantine.

[@MuhammadUmerAbdullah]

Welcome