SHIVAM EDUCATION WORLD
SHIVAM EDUCATION WORLD
  • 287
  • 437 606
IF Function + And + Column | IF Function Excel | IF Formula in MS Excel | #iffunction | #ifformula
IF Function + And + Column | IF Function Excel | IF Formula in MS Excel | #iffunction | #ifformula
Download Excel File: docs.google.com/spreadsheets/d/1cIoh2ou-B-P1mwwUtvkJDEwEvlxvqIOc/edit?usp=sharing&ouid=112968167584751337393&rtpof=true&sd=true
Hi I am Shivam Singh. Welcome to our you tube channel Shivam Education World.
SUBSCRIBE TO MY CHANNEL 👉 ua-cam.com/channels/8sTJeRL.html...
.
---------------------------------------------------------------------------------
---------------------------------------------------------
About this channel-
Doston is channel me aapko office me work karne se sambandhit poori jaankari milegi,doston office me kaam karne ke liye ms excel aur ms word bahut jaroori hota hai,students ko bhi ms office ki bahut jaroorat hoti hai,doston is channel me aapko ms excel aur ms word aur computer se judi saari knowledge ke videos free me dekhne ko regular milte rahenge,yadi aap regular saare videos ko dekhenge to aap computer me perfect ho jayenge,doston main aapko ms excel me basic se lekar advance saari jankaari is channel me doonga aur shortcut keys bhi batata chaloonga,doston ye channel aapko office work/data entry me perfect banata hai.Doston MIS REPORT ke liye bhi aapko is channel me saari jankaari mil jayegi.
Doston agar aapko mera channel pasand aata hai to jaroor subscribe kijiyega.
Thank you so much-------
----------------------------------------------------------
#iffunction #ifformula
#exceltutorial #exceltipsandtricks #excel
#shivam_education_world_excel_tutorial
#exceltutoring #excelformulaforjobinterview
shivam education world,
excel tutoring,
if function,
if formula,
excel if function,
excel if formula,
excel if formula with text,
excel if formulas and functions,
excel if formula simple to advanced,
excel if formula hacks,
excel if formula in hindi,
excel if formula true false,
excel if and condition,
excel if or statement,
excel if or functions,
if function excel,
if function between two values,
excel if condition,
if formula tips and tricks,
how to use if function,
excel
if formula,
excel if function,
excel if formula,
excel if formula with text,
excel if formulas and functions,
excel if formula hacks,
excel if formula in hindi,
excel if formula true false,
excel if and condition,
excel if or statement,
excel if or functions,
if function excel,
if function between two values,
excel if condition,
how to use if function,
how to use if function in excel with multiple conditions,
if function with and,
if function with multiple condition,
ms excel
Переглядів: 253

Відео

Sumproduct Magical Tips & Tricks with Conditional Formatting | Sumproduct Function Excel | #excel
Переглядів 29214 днів тому
Sumproduct Magical Tips & Tricks with Conditional Formatting | Sumproduct Function Excel | #excel #sumproduct Download Excel File: docs.google.com/spreadsheets/d/1PlgYxaU28n7iQIK2CCptKgbQY1084WTi/edit?usp=sharing&ouid=112968167584751337393&rtpof=true&sd=true Hi I am Shivam Singh. Welcome to our you tube channel Shivam Education World. SUBSCRIBE TO MY CHANNEL 👉 ua-cam.com/channels/8sTJeRL.html.....
VLOOKUP Amazing Tips & Tricks | VLOOKUP Tips | VLOOKUP Tips & Tricks | Tips VLOOKUP Excel | #vlookup
Переглядів 524Місяць тому
VLOOKUP Amazing Tips & Tricks | VLOOKUP Tips | VLOOKUP Tips & Tricks | Tips VLOOKUP Excel Download Excel File: docs.google.com/spreadsheets/d/1O3meNEbJBGJ3ZmbfUnteKakU9jqNrewM/edit?usp=sharing&ouid=112968167584751337393&rtpof=true&sd=true Hi I am Shivam Singh. Welcome to our you tube channel Shivam Education World. SUBSCRIBE TO MY CHANNEL 👉 ua-cam.com/channels/8sTJeRL.html... . About this chann...
VBA for Next Loop 2 | Excel VBA for Next Loop | VBA for Loop | #vba #excel
Переглядів 122Місяць тому
VBA for Next Loop 2 | | Excel VBA for Next Loop | VBA for Loop | #vba #excel Download Excel File: drive.google.com/file/d/1c62mc-i3TfDpidHe7Z8F9XZlicpGJ3xX/view?usp=sharing Hi I am Shivam Singh. Welcome to our you tube channel Shivam Education World. SUBSCRIBE TO MY CHANNEL 👉 ua-cam.com/channels/8sTJeRL.html... . About this channel- Doston is channel me aapko office me work karne se sambandhit ...
Data Entry Tips & Tricks | Data Entry | Most Important Tips & Tricks for Data Entry | #dataentry
Переглядів 196Місяць тому
Data Entry Tips & Tricks | Data Entry | Most Important Tips & Tricks for Data Entry | #dataentry #dataentrytips | data entry tips for excel Download Excel File: docs.google.com/spreadsheets/d/1hdQOBo9xCncO1APN76pZ3zFzDzctLkHr/edit?usp=sharing&ouid=112968167584751337393&rtpof=true&sd=true Hi I am Shivam Singh. Welcome to our you tube channel Shivam Education World. SUBSCRIBE TO MY CHANNEL 👉 ua-c...
Most Important Tips & Tricks for Data Entry | Data Entry | Data Entry Tips & Tricks | #dataentry
Переглядів 114Місяць тому
Most Important Tips & Tricks for Data Entry | Data Entry | Data Entry Tips & Tricks | #dataentry Download Excel File : docs.google.com/spreadsheets/d/1hdQOBo9xCncO1APN76pZ3zFzDzctLkHr/edit?usp=sharing&ouid=112968167584751337393&rtpof=true&sd=true Hi I am Shivam Singh. Welcome to our you tube channel Shivam Education World. SUBSCRIBE TO MY CHANNEL 👉 ua-cam.com/channels/8sTJeRL.html... . About th...
Excel VLOOKUP + IF + IFERROR | VLOOKUP with if formula in excel | VLOOKUP with IFERROR in excel
Переглядів 2602 місяці тому
Excel VLOOKUP IF IFERROR | VLOOKUP with if formula in excel | VLOOKUP with IFERROR in excel Download Excel Practice File: docs.google.com/spreadsheets/d/15k0GMEExpx-wV3JJbfVJwiri4lAuRQNW/edit?usp=sharing&ouid=112968167584751337393&rtpof=true&sd=true Hi I am Shivam Singh. Welcome to our you tube channel Shivam Education World. SUBSCRIBE TO MY CHANNEL 👉 ua-cam.com/channels/8sTJeRL.html... . About...
Excel VBA (Next Loop) | VBA Loop | For each Loop in VBA | For Next Loop Visual Basic | #vbaexcel
Переглядів 1652 місяці тому
Excel VBA (Next Loop) | VBA Loop | For each Loop in VBA | For Next Loop Visual Basic Download Excel File : drive.google.com/file/d/19EW1l8yzZVy4U8Y5V09VjArXZFHvcW7t/view?usp=sharing Hi I am Shivam Singh. Welcome to our you tube channel Shivam Education World. SUBSCRIBE TO MY CHANNEL 👉 ua-cam.com/channels/8sTJeRL.html... . About this channel- Doston is channel me aapko office me work karne se sa...
Nested VLOOKUP with Conditional Formatting
Переглядів 3382 місяці тому
Nested VLOOKUP with Conditional Formatting Download Practice File: docs.google.com/spreadsheets/d/1BZpvZ3K0qPOPNXHMf4389ae3ny9DTcqN/edit?usp=sharing&ouid=112968167584751337393&rtpof=true&sd=true Hi I am Shivam Singh. Welcome to our you tube channel Shivam Education World. SUBSCRIBE TO MY CHANNEL 👉 ua-cam.com/channels/8sTJeRL.html... . About this channel- Doston is channel me aapko office me wor...
Data Entry Amazing Tips and Tricks | Data Entry | Data Entry in Excel | #dataentry #excel
Переглядів 842 місяці тому
Data Entry Amazing Tips and Tricks | Data Entry | Data Entry in Excel | #dataentry #excel
Excel VBA Variable Types Declaration | Excel VBA | VBA Variable | #vba
Переглядів 712 місяці тому
Excel VBA Variable Types Declaration | Excel VBA | VBA Variable | #vba
Pivot Table Amazing Tricks | Excel Pivot Table | Excel Tips and Tricks | #pivottable | #excel
Переглядів 1,4 тис.2 місяці тому
Pivot Table Amazing Tricks | Excel Pivot Table | Excel Tips and Tricks | #pivottable | #excel
VLOOKUP Interview Series (Row & Rows) | VLOOKUP Interview Question & Answers #excelinterview
Переглядів 2043 місяці тому
VLOOKUP Interview Series (Row & Rows) | VLOOKUP Interview Question & Answers #excelinterview
Excel VBA Variable & Data Types (Part - 2)
Переглядів 1293 місяці тому
Excel VBA Variable & Data Types (Part - 2)
10 Amazing Excel Tricks | Excel Tips & Tricks | Excel Tips | Excel Tricks | #exceltricks #exceltips
Переглядів 6423 місяці тому
10 Amazing Excel Tricks | Excel Tips & Tricks | Excel Tips | Excel Tricks | #exceltricks #exceltips
VLOOKUP Interview Series - 2 | VLOOKUP Interview Question and Answer | VLOOKUP Test for Interview
Переглядів 1933 місяці тому
VLOOKUP Interview Series - 2 | VLOOKUP Interview Question and Answer | VLOOKUP Test for Interview
Excel VBA Variable & Data Types (Part - 1) | Excel VBA Variable & Data Types | #vbaexcel
Переглядів 2253 місяці тому
Excel VBA Variable & Data Types (Part - 1) | Excel VBA Variable & Data Types | #vbaexcel
10 AMAZING OFFICE TRICKS in 10 MINUTES | #exceltips | #exceltricks | #excelhacks | #excel
Переглядів 3433 місяці тому
10 AMAZING OFFICE TRICKS in 10 MINUTES | #exceltips | #exceltricks | #excelhacks | #excel
VLOOKUP Interview Series 1 | VLOOKUP Interview Question and Answer | Excel Interview | #vlookup
Переглядів 4053 місяці тому
VLOOKUP Interview Series 1 | VLOOKUP Interview Question and Answer | Excel Interview | #vlookup
VBA User Form | VBA User form in MS Excel | User form VBA Excel Code | #vbaexcel
Переглядів 1504 місяці тому
VBA User Form | VBA User form in MS Excel | User form VBA Excel Code | #vbaexcel
10 Most Useful Excel Tricks | Excel Tricks and Tips | Excel Tricks | Excel Office Tricks | #excel
Переглядів 6644 місяці тому
10 Most Useful Excel Tricks | Excel Tricks and Tips | Excel Tricks | Excel Office Tricks | #excel
VBA (OFFSET) Lecture - 4 | Offset in Excel VBA | How to Use Offset IN VBA Excel | Excel VBA | #vba
Переглядів 2234 місяці тому
VBA (OFFSET) Lecture - 4 | Offset in Excel VBA | How to Use Offset IN VBA Excel | Excel VBA | #vba
Pivot Table Multiple sheets | Microsoft Power Query | Pivot Table from multiple sheets | #powerpivot
Переглядів 4804 місяці тому
Pivot Table Multiple sheets | Microsoft Power Query | Pivot Table from multiple sheets | #powerpivot
VBA Lecture - 3 CELLS.SELECT | VBA Macro in Excel | VBA Series | VBA Code in Excel | #excelvba
Переглядів 1434 місяці тому
VBA Lecture - 3 CELLS.SELECT | VBA Macro in Excel | VBA Series | VBA Code in Excel | #excelvba
SUMPRODUCT Basic Concept - Coerce | Excel Array & Sumproduct | Sumproduct function excel
Переглядів 2214 місяці тому
SUMPRODUCT Basic Concept - Coerce | Excel Array & Sumproduct | Sumproduct function excel
Pivot Table Relationship Data Model (Part - 2) | Combining Data from Multiple Sheets in Excel
Переглядів 1315 місяців тому
Pivot Table Relationship Data Model (Part - 2) | Combining Data from Multiple Sheets in Excel
VBA Excel Lecture 2 | VBA for Beginners | VBA Code in Excel | VBA Macro in Excel | VBA Tutorial
Переглядів 1395 місяців тому
VBA Excel Lecture 2 | VBA for Beginners | VBA Code in Excel | VBA Macro in Excel | VBA Tutorial
Flash Fill Excel | Flash Fill in Excel | Flash Fill Advance | Excel Flash Fill | #flashfill
Переглядів 2115 місяців тому
Flash Fill Excel | Flash Fill in Excel | Flash Fill Advance | Excel Flash Fill | #flashfill
VBA Excel Lecture 1 | VBA for Beginners | VBA Macro in Excel | VBA Code in Excel | VBA Tutorial
Переглядів 3065 місяців тому
VBA Excel Lecture 1 | VBA for Beginners | VBA Macro in Excel | VBA Code in Excel | VBA Tutorial
Creating Pivot Table Relationship Data Model | Create a Pivot Table from Multiple Sheet in Excel
Переглядів 3566 місяців тому
Creating Pivot Table Relationship Data Model | Create a Pivot Table from Multiple Sheet in Excel

КОМЕНТАРІ

  • @brittokhan5278
    @brittokhan5278 4 дні тому

    sir your tutorials are so helpfull though you dont have much views

  • @brittokhan5278
    @brittokhan5278 5 днів тому

    sir you dont have much views but your tutorials are very helpful

  • @Kingpotash
    @Kingpotash 10 днів тому

    Your sound quality is very poor

  • @paramjeet975singh3
    @paramjeet975singh3 10 днів тому

    Sir agar 4000 rows ho to

  • @khushisingh6468
    @khushisingh6468 11 днів тому

    Amazing 👏👏

  • @Jitenderkumar-yp1rn
    @Jitenderkumar-yp1rn 18 днів тому

    Bahut badhiya sir...👍🏻

  • @officenoproblem
    @officenoproblem 25 днів тому

    nice

  • @asimali5820
    @asimali5820 Місяць тому

    Good one

  • @Noumanjavedshamsi
    @Noumanjavedshamsi Місяць тому

    Nice video sir

  • @rupalichittodiya6963
    @rupalichittodiya6963 Місяць тому

    Sir please core and advance excel basic se sikhao apka explain krne ka tarika bahut unique hai

  • @sunilsomanath623
    @sunilsomanath623 Місяць тому

    Nice explanation 👍

  • @khushisingh6468
    @khushisingh6468 Місяць тому

    Apke Vlookup ke Videos bahut helpful rehte hain, Thank U Keep Growing 👏👏

  • @rupalichittodiya6963
    @rupalichittodiya6963 Місяць тому

    Sir apne is channel par core and advance excel course starting se sikhao Ap bahut acche se sikhate ho

  • @khushisingh6468
    @khushisingh6468 Місяць тому

    Very Informative 👏👏

  • @thenworld3262
    @thenworld3262 Місяць тому

    Tussi Gr8 ho sir ji 🎉🎉

  • @sushantkumar907
    @sushantkumar907 Місяць тому

    Very good trick❤❤❤

  • @arvindtech408
    @arvindtech408 Місяць тому

    😊

  • @arvindtech408
    @arvindtech408 Місяць тому

    Apk jaisa koi UA-cam par nhi h sir ji practical problem aap sikhate ho bilkul simple way mein

  • @arvindtech408
    @arvindtech408 Місяць тому

    Practice File to Dijiyr Sir

  • @arvindtech408
    @arvindtech408 Місяць тому

    Pivot se bhi to kar sakte h sir ji

  • @arvindtech408
    @arvindtech408 Місяць тому

    Sir meri 7 branch hai Bihar mein aur hum un 7 branch se purchase karte hai to 50 Lakh cross hote hi hmr 94Q k tahat TDS katna hota hai us party ka aur TDS katane k baad firse agar koi purchase aati hai to us par bbi TDS katana hota hai monthwise to koi formula btaiye jissey monthwise TDS calculate hota rahe 50 Lakh Exemption limit cross karne k baad....Pivot table to aggregate bta deta hai.....wo breakup nhi deta hai

  • @arvindtech408
    @arvindtech408 Місяць тому

    Fils download nhi hi rha h

  • @shivameducationworld
    @shivameducationworld Місяць тому

    Video Re-uploaded Friends 👍

  • @shivameducationworld
    @shivameducationworld Місяць тому

    Dear Friends video mein kuch technical problem ho gayi hai, I will re-upload this video soon

  • @khushisingh6468
    @khushisingh6468 Місяць тому

    Amazing

  • @tanmaypandya1102
    @tanmaypandya1102 Місяць тому

    Red में highlight कैसे होता है

  • @jitendramahapatra1239
    @jitendramahapatra1239 2 місяці тому

    Vba course ek series wise upload kijiye please

  • @HemanthKumar-ft9nv
    @HemanthKumar-ft9nv 2 місяці тому

    Very useful 👍How to do the same from different workbook

  • @sachinpathare9060
    @sachinpathare9060 2 місяці тому

    sir alt+down arrow se data validation list kaise banayee. please explain me. unique value kisi list kaise banaye.

  • @AlimKhan-bl5sh
    @AlimKhan-bl5sh 2 місяці тому

    Tiino cell colour nahii ho rahe hai.. Aeisa ku sir

  • @AlimKhan-bl5sh
    @AlimKhan-bl5sh 2 місяці тому

    Sir mene bht acche se bar bar check kar liya.. Conditional formatting sirf ek hii cell par apply ho raha hai.. Jo selection me rakh raha hu uska upar wala cell color ho raha hai

  • @madhukarshinde4914
    @madhukarshinde4914 2 місяці тому

    How vlook is used to produce mark sheet of students, which choose six subject out of 10 Such as out of language Marathi Hindi and Sanskrit some students take Marathi while some take Hindi and remaining text Sanskrit

  • @dpcomm
    @dpcomm 2 місяці тому

    Char(10) is new for me. Thanks a ton.

  • @Harishckt1
    @Harishckt1 2 місяці тому

    Super

  • @AlimKhan-bl5sh
    @AlimKhan-bl5sh 2 місяці тому

    Sir ek baat bataiye apne jo sumproduct se question kara tha.. Star laga kar.. Usko double negative se kar raha hu to.. #value ye error aa raha hai.. Ku aeisa ku sir

  • @bishanjppharma
    @bishanjppharma 2 місяці тому

    great boss

  • @aweshmemon5453
    @aweshmemon5453 2 місяці тому

    Samjha nahi paa rahe ho

  • @AlimKhan-bl5sh
    @AlimKhan-bl5sh 2 місяці тому

    Are Han sir... Me bhool gaya tha... Sumproduct se nahii hoga.. Ku k sumproduct intersection se value thodi lakar deta hai.. Kya mene sahii bola sir?

  • @AlimKhan-bl5sh
    @AlimKhan-bl5sh 2 місяці тому

    Sir ye question sumproduct se ho sakta hai na?...

  • @amitamit1799
    @amitamit1799 2 місяці тому

    Very Very Helpfull video sir 😃

  • @Freeky27
    @Freeky27 2 місяці тому

    😂😂😂😂

  • @ravindrakumar5147
    @ravindrakumar5147 2 місяці тому

    Sir please share your mobile number

  • @khushisingh6468
    @khushisingh6468 2 місяці тому

    Amazing Tricks 👏👏

  • @anilkumarsingh6738
    @anilkumarsingh6738 2 місяці тому

    Thank you sir ji 🙏🙏

  • @feelgoodspace
    @feelgoodspace 2 місяці тому

    amazing explain

  • @devshah7936
    @devshah7936 2 місяці тому

    Sir mera macro jaha mene ye shortcut banaya hai vahi show kr raha hai me aesa chahta hu ki jiska me button click kru to vo mujhe direct uski sheet pr le jaye

  • @arnyanderson4955
    @arnyanderson4955 2 місяці тому

    Better and efficient way to nest Match function or xmatch

  • @Ayesha-w9m
    @Ayesha-w9m 2 місяці тому

    Wonderful 👏🏻

  • @abdulsalam935
    @abdulsalam935 2 місяці тому

    EXCELLENT

  • @SouravKumarRoy651
    @SouravKumarRoy651 3 місяці тому

    Sir, I have a question ⁉️ One of the condition for SUMPRODUCT to function properly is, that the arrays selected within it should be of compatible dimensions i.e. all the arrays selected within it should have equal no. of rows and columns, else it would show error. However, in the 2nd last example, where you showed its use for 2-way lookup, the arrays selected were not having equal no. of rows and columns e.g. the name column had 13 rows and one column but the month row had one row and 12 columns. Still it worked properly. How was it possible?😮 Please reply ASAP 🙏🙏🙏🙏