![Genius World](/img/default-banner.jpg)
- 247
- 1 362 815
Genius World
United States
Registrace 7. 04. 2020
Description
Welcome! It's great to have you here!
I share videos related to Office Productivity.
My goal is to help you provide the most effective and efficient ways on excel that will not only save our time but also help us to think out of the box to get the solutions that we have never thought about.
I create videos on sections that will help us to analyze the perspective from different angles.
- MS Excel - Challenge Section
- MS Excel - Short
- MS Excel - Tutorial Book
I love to learn new tools and techniques and share these with you. I hope to inspire you to experiment and share with others.
My background: Masters in Finance / Bacheclors in Finance / Finanacial Anayst / Financial Advisor / Business Consultant / Finance Model Expert / Enterpenuer
Subscribe if you'd like to improve your skills.
Don't forget to subsribe the Channel
You can also visit our facebook page, whose link is mentioned below;
MS-Excel-World-102496165764420
Welcome! It's great to have you here!
I share videos related to Office Productivity.
My goal is to help you provide the most effective and efficient ways on excel that will not only save our time but also help us to think out of the box to get the solutions that we have never thought about.
I create videos on sections that will help us to analyze the perspective from different angles.
- MS Excel - Challenge Section
- MS Excel - Short
- MS Excel - Tutorial Book
I love to learn new tools and techniques and share these with you. I hope to inspire you to experiment and share with others.
My background: Masters in Finance / Bacheclors in Finance / Finanacial Anayst / Financial Advisor / Business Consultant / Finance Model Expert / Enterpenuer
Subscribe if you'd like to improve your skills.
Don't forget to subsribe the Channel
You can also visit our facebook page, whose link is mentioned below;
MS-Excel-World-102496165764420
🔥 Power of VLOOKUP & MATCH Function In Excel | Easy Method
#howtouse #howtocreate #vlookup #vlookupformula #vlookupformula #vlookupinexcel #vlookupfunction #vlookuup #dropdown #dropdownlist #dependent #datavalidation #vlookupformula #vlookupinexcel #xlookup #msexcelxlookup #xlookupformula #max #maximum #maxformula #vlookupinexcelinhindi #msexcel
#msexcel2016 #msexcelfullcourse #GeniusWorld #@geniusworldteam
CZcams Handle : @geniusworldteam
Download Training File
docs.google.com/spreadsheets/d/19cSQZETwni2gX7GFLObHufK9ua4ZC3tw/edit?usp=sharing&ouid=100928782733267800224&rtpof=true&sd=true
In this video we will learn simple use of VLookup and learn it in very simply and easily. VLookup also known as Vertical Lookup in Microsoft Excel.
Here we will show multiple result for single lookup using VLookup Formula.
Please Subscribe to my channel and keep your support!!
#Matchfunction
#matchfunctioninexcel
#vlookupinexcel
#vlookupformula
#vlookup
#microsoft_excel_tutorial
Don't miss out on mastering these essential Excel functions - watch now and take your Excel skills to the next level!
Follow along as we walk you through the process step by step.
Timestamps:
0:00 Introduction
2:10 Use Data Validation In Excel
2:39 Test Data Validation Function
3:10 Use Data Validation in Heading
3:40 Use VLOOKUP & MATCH Function
5:10 Test VLOOKUP & MATCH Function In Excel
#Power of VLOOKUP & MATCH Function In Excel | Easy Method
*************** Kindly Like and Subscribe for Support ***********************
**************** Please Support our Page by Follow it ********************
MS-Excel-World-102496165764420/
The Channel URL also mentioned below;
youtube.com/@geniusworldteam
Excel Tutorial :
czcams.com/channels/5mb_OR4V3ryCJPONSQV89A.html
Don't forget to subscribe to our channel for more great Excel tutorials!
Visit us at: Genius-World...
#msexcel2016 #msexcelfullcourse #GeniusWorld #@geniusworldteam
CZcams Handle : @geniusworldteam
Download Training File
docs.google.com/spreadsheets/d/19cSQZETwni2gX7GFLObHufK9ua4ZC3tw/edit?usp=sharing&ouid=100928782733267800224&rtpof=true&sd=true
In this video we will learn simple use of VLookup and learn it in very simply and easily. VLookup also known as Vertical Lookup in Microsoft Excel.
Here we will show multiple result for single lookup using VLookup Formula.
Please Subscribe to my channel and keep your support!!
#Matchfunction
#matchfunctioninexcel
#vlookupinexcel
#vlookupformula
#vlookup
#microsoft_excel_tutorial
Don't miss out on mastering these essential Excel functions - watch now and take your Excel skills to the next level!
Follow along as we walk you through the process step by step.
Timestamps:
0:00 Introduction
2:10 Use Data Validation In Excel
2:39 Test Data Validation Function
3:10 Use Data Validation in Heading
3:40 Use VLOOKUP & MATCH Function
5:10 Test VLOOKUP & MATCH Function In Excel
#Power of VLOOKUP & MATCH Function In Excel | Easy Method
*************** Kindly Like and Subscribe for Support ***********************
**************** Please Support our Page by Follow it ********************
MS-Excel-World-102496165764420/
The Channel URL also mentioned below;
youtube.com/@geniusworldteam
Excel Tutorial :
czcams.com/channels/5mb_OR4V3ryCJPONSQV89A.html
Don't forget to subscribe to our channel for more great Excel tutorials!
Visit us at: Genius-World...
zhlédnutí: 360
Video
How To Create Winner Template In Excel | VLOOKUP & MAX In Excel
zhlédnutí 45Před 21 dnem
#howtouse #howtocreate #vlookup #vlookupformula #vlookupformula #vlookupinexcel #vlookupfunction #vlookuup #dropdown #dropdownlist #dependent #datavalidation #vlookupformula #vlookupinexcel #xlookup #msexcelxlookup #xlookupformula #max #maximum #maxformula #vlookupinexcelinhindi #msexcel #msexcel2016 #msexcelfullcourse #GeniusWorld #@geniusworldteam CZcams Handle : @geniusworldteam Download Tra...
How To Create Drop Down List In Excel | Easy & Quick Method In Excel
zhlédnutí 438Před 28 dny
#howtouse #howtocreate #drop #dropdown #dropdownlist #dependent #datavalidation #vlookupformula #vlookupinexcel #xlookup #msexcelxlookup #xlookupformula #vlookupfunction #vlookupinexcelinhindi #msexcel #msexcel2016 #msexcelfullcourse #GeniusWorld #@geniusworldteam CZcams Handle : @geniusworldteam Download Training File docs.google.com/spreadsheets/d/1A8fZdjzNBcM_mqtx8OxS5N0jlACzoJDW/edit?usp=sh...
How To Use XLOOKUP Vs VLOOKUP Function In Excel | VLOOKUP Vs XLOOKUP In Excel Example
zhlédnutí 221Před měsícem
#howtouse #howtocreate #xlookup #vlookup #vlookupformula #vlookupinexcel #xlookup #msexcelxlookup #xlookupformula #vlookupfunction #vlookupinexcelinhindi #msexcel #msexcel2016 #msexcelfullcourse #GeniusWorld #@geniusworldteam CZcams Handle : @geniusworldteam Download Training File docs.google.com/spreadsheets/d/1Eyo7Dar84oihYzczoh3QgdyjOZJlrol-/edit?usp=sharing&ouid=100928782733267800224&rtpof=...
Easy Payroll System In Excel
zhlédnutí 82Před měsícem
#Advance #InventoryManagement #excelforbeginners #geniusworld Learn How to Create Payroll or Salary Statement in MS Excel. How to Calculate DA, HRA, PF, Gross Salary, EPF, LIC, Total Deductions, and Net Salary in Hindi, also learn how to format or Design Salary Sheet for your employees. Learn Excel basic formulas Sum, Percentage, Subtraction, etc. It is a complete ms excel training tutorial. CZ...
How To Use XLOOKUP Function In Excel | Easy XLOOKUP In Excel
zhlédnutí 938Před měsícem
#howtouse #howtocreate #xlookup #vlookup #vlookupformula #vlookupinexcel #vlookupfunction #vlookupinexcelinhindi #msexcel #msexcel2016 #msexcelfullcourse #GeniusWorld #@geniusworldteam CZcams Handle : @geniusworldteam Download Training File docs.google.com/spreadsheets/d/1VbOExiLjJ-wVgr_-_9z9e86oMHiJ99H7/edit?usp=sharing&ouid=100928782733267800224&rtpof=true&sd=true We learn about XLOOKUP funct...
How To Create Strike Through In Excel and Conditional Formatting In Excel
zhlédnutí 181Před 2 měsíci
#howtouse #howtocreate #data #datavalidation #Create #strikethrough #conditionalformatting #conditionalformattinginexcel #checkboxes #checkbox #conditionalformatting #msexcel #msexcel2016 #dataentryjobs #dataentryjop #dataentryjob #dataentrytips #msexcelfullcourse #GeniusWorld #@geniusworldteam @geniusworldteam CZcams Handle : @geniusworldteam Download Training File docs.google.com/spreadsheets...
Use of Performance FORM and How To Create FORM In Excel | Data Entry Form In Excel
zhlédnutí 156Před 2 měsíci
Use of Performance FORM and How To Create FORM In Excel | Data Entry Form In Excel
Use Of VLOOKUP & DATA VALIDATION Function In Excel | VLOOKUP Vs Data Validation In Excel
zhlédnutí 207Před 3 měsíci
Use Of VLOOKUP & DATA VALIDATION Function In Excel | VLOOKUP Vs Data Validation In Excel
Power of MACRO & IF Formula In Excel | Create & Use Excel Macros
zhlédnutí 67Před 3 měsíci
Power of MACRO & IF Formula In Excel | Create & Use Excel Macros
Use of INDEX & MATCH Function In Excel | How to use Excel Index Match
zhlédnutí 103Před 3 měsíci
Use of INDEX & MATCH Function In Excel | How to use Excel Index Match
Mastering Excel: Updating & Replacing Salary Data Tutorial
zhlédnutí 60Před 3 měsíci
Mastering Excel: Updating & Replacing Salary Data Tutorial
🔥 How to Create DICE GAME Macros in Excel Tutorial | MACRO CLASS # 03
zhlédnutí 93Před 6 měsíci
🔥 How to Create DICE GAME Macros in Excel Tutorial | MACRO CLASS # 03
How to Create Macros in Excel Tutorial | MACRO CLASS # 02
zhlédnutí 463Před 6 měsíci
How to Create Macros in Excel Tutorial | MACRO CLASS # 02
How to Create & Use Excel Macros | MACRO CLASS # 01
zhlédnutí 184Před 6 měsíci
How to Create & Use Excel Macros | MACRO CLASS # 01
🔥 How To Create Purchase Analysis Report In Excel
zhlédnutí 713Před 8 měsíci
🔥 How To Create Purchase Analysis Report In Excel
How to Use Excel Check Boxes | Easy & Simple In Excel
zhlédnutí 389Před 10 měsíci
How to Use Excel Check Boxes | Easy & Simple In Excel
How to Master Excel Tips & Tricks For Fastest Total
zhlédnutí 222Před 10 měsíci
How to Master Excel Tips & Tricks For Fastest Total
How to Master To Create Multiple Check Box In Excel | Thousands Check Boxes
zhlédnutí 1,8KPřed 10 měsíci
How to Master To Create Multiple Check Box In Excel | Thousands Check Boxes
Data Entry Form in Microsoft Excel | Power of Data Entry in Excel
zhlédnutí 188Před 11 měsíci
Data Entry Form in Microsoft Excel | Power of Data Entry in Excel
The Power of VLOOKUP | Use Of VLOOKUP | VLOOKUP In Excel
zhlédnutí 74Před 11 měsíci
The Power of VLOOKUP | Use Of VLOOKUP | VLOOKUP In Excel
🔥 Payroll in Excel | How to Create Payroll in Excel
zhlédnutí 9KPřed rokem
🔥 Payroll in Excel | How to Create Payroll in Excel
Data Entry using Form in Microsoft Excel | Excel Data Entry
zhlédnutí 207Před rokem
Data Entry using Form in Microsoft Excel | Excel Data Entry
Use Conditional Formatting to Apply Strikethrough In Excel
zhlédnutí 8KPřed rokem
Use Conditional Formatting to Apply Strikethrough In Excel
How To Separate Big Data Text Into Different Columns
zhlédnutí 50Před rokem
How To Separate Big Data Text Into Different Columns
Create Professional PayRoll Using VLOOKUP Only | Single Formula Payslip
zhlédnutí 1,9KPřed rokem
Create Professional PayRoll Using VLOOKUP Only | Single Formula Payslip
How To Count and Delete Blank Cells In Excel !!!
zhlédnutí 274Před rokem
How To Count and Delete Blank Cells In Excel !!!
How To Color Specific Text In Excel | Student Report
zhlédnutí 4KPřed rokem
How To Color Specific Text In Excel | Student Report
what if we don't want the "days' just a month/year column?
We can simply use "m" for month and "y" for year. We don't need to use days. If we need only months and years.
Payroll caculation
Thank you for your comment !!!
Thanks bro
Your Welcome !!!
Great
Thank You!!!
Hi, can u show a video of how by typing 0600- 0730 (as in 6.30 am to 7.30am) , in a cell , and it will colour a range of vertical cells? Like how i could easily highlight in colours of all enployees work time in a day, from what time till what time
Thank You for your Comments. Please find the link of How To Create Payroll. We have used Over time and other detail. Hopefully it will be useful. czcams.com/video/c-kd145l0R4/video.htmlsi=R78BKfurVjFqcRuX
Very smart thank you ❤
Your Welcome !!!!
Thanks friend❤❤❤
Your welcome!!!!
Thanks so very much
Your Welcome !!!!
Esme Logic kya hai pleej help
It reflect True for Red Color !!!
Is me ye pta krna hai k agr Red ho to "True" aye werna " False " aye
I like this video ❤❤❤❤
Thank You!!!!!
Ty
Thank You for your comment!!!
Gracias!! me sirvió (:
This is exactly what I needed right now, thank you so much for the help
Your Welcome!!!!
I love that with the power of tutorials, one does not need a college course to learn how to construct spreadsheets
Thank You So Much !!!
Can i do this in excel in office 365 version?
Usually the functions used in Google Spread Sheet and 365 are similar. You can make this function on Excel 365 as well.
Can i do this in excel in office 365 version?
Hi Sir....I want to give yes for greater than zero and no for less than zero and nil for equal to zero...will you please help me formula Sir
Thank You. You can use Yes instead of PASS and Any value like => for Instead of Fail. It works same. Still face issue. Please let me know. I will make formula
@@geniusworldteamSir
@@geniusworldteam Sir...Pass and Fail and nil ... three I need to give... above zero less than zero and equal to zero also condition please help me formula Sir
@karunakarvemishetty1134 Please find the Formula Below =IF(Select Cell>0,"Yes",IF(Select Cell<0,"No","Nill")) Hopefully it will work. If still face issue. Please let me know. I will create video on it in the coming days and share link with you.
Excellent very well done, for small business once they learn to print cheques they don't need to buy payroll software. I use excel for payroll I love it! I think once people truly understand how delightful and easy excel is to use for payroll ie. in small companies there will be far less demand for compensation and payroll software. Our company has less then 20 people, I can just add whatever I need.
Thank You so much !!!!
Sir Aisa koi formula nahi hai jo data ke + - find kare
Please explain further we can convert all negative into positive etc
Ok
Don’t understand 😁
Nice ...very informative video
Thank you !!!!
I don't have a result there, but a Value. Why? 😢
Please use formula same formula and make sure nature / format of data is correct !!!
Thanks bro
Your welcome brother !!!
Neat work
Thank You !!!
thanks bro
Thank you so much this is very simple and helpful 🙏🙏
Your welcome!!!
Sorry, das geht heute wirklich besser und einfacher!
Yes, we can make it more easier and simpler or even complex as per requirement!!!
Thanks for the video however why the accent?
Your welcome !!!!
What is the use of this data & chart 📊 😢
It is helpful to Summarize large data set in visual form in one of the simplest format !!
@@geniusworldteam this simply shows a simple data 75% in visual form... 😵 That's all... If this could atleast capture individual scores in each subject over a period of time, say 3 semester a chart 📊 could be useful 👍but here, a simple data, just percentage does not call for usage of chart 📊. As a matter of fact one person in comments 📝 had asked if this could be used for whole class... 😵 May be there a chart 📊 is required... 😵.. That's why I asked...
Hi do you have tutorial if 3 choices are needed? for example, pending, incomplete, complete?
Apologize but we can make multiple scenarios like Pending, Work in process, complete and Cancelled bu using the same technique that has been used for normal scenarios. We will try to make video on multiple scenarios in near future. Thank you for your feedback!!!
Promo>SM
How i remove the color
You can use Conditional Formatting option to add, remove or change the color.
Please write the steps, thanks
@mrittikachowdhury7388 Hopefully these steps will work in the formatting, here are the steps to apply conditional formatting to change cell color in Excel: 1. Select the range of cells you want to apply the conditional formatting to. 2. Go to the "Home" tab on the Excel ribbon. 3. Click on "Conditional Formatting" in the Styles group. 4. Choose "New Rule" from the dropdown menu. 5. In the New Formatting Rule dialog box, select "Format only cells that contain" from the Select a Rule Type section. 6. Set your desired conditions under the "Format only cells with" dropdown menus. 7. Click on the "Format" button to choose the format you want to apply, including the font, border, and fill color. 8. Click "OK" to confirm the format. 9. Click "OK" again in the New Formatting Rule dialog box to apply the conditional formatting.
Simplified very well
Thank you for your feed back !!
It works in my laptop. But if I want to use in my tablet or phone. It seems the checkbox disappeared.
Thank you for your feedback. You can check by installing different versions of Ms Office in order to support your file features.
Thank you very much.😊
Your welcome !!!
tq dear really helpful 💛😊
Thank you so much !!!
@@geniusworldteam brother sometimes coming like this the formula is missing an opening or closing parenthesis please tell me
Thank you. You need to insert opening parenthesis but it for closing, you can insert or it will automatically create by own
Thanks very much 😊
Your welcome !!!
Great and very helpful
Thank You !!!!
Thanks bro
How do u select the numbers like that
You can select simpy by click on cell and drag till last. It will gives reference of selected cells
Super
Thank you!!!
I like this. Will be using it in my payroll journey
Thank you for your feedback!!!
Yes I use excel for our small company too, works well. Just added a cheque printing template.
Excel sheet me tabal hai multiple copy kaise karre
Copy formula and Paste with correct cell addresses.
Hopefully it will works
Superb. Short and to the point 👍
Thank you
This is one of the simplest video ever
Thank you so much !!!
Super sir...thank you so much 🎉🎉🎉🎉
Your welcome
Yes thank you so much I have exam tomorrow and I was looking for this exact video thank you From Palestine 🇵🇸
Thank you so much & May God bless you !!!
I got full mark thanks bro
Your welcome!!!
Bravo