- 252
- 1 607 627
Genius World
United States
เข้าร่วมเมื่อ 7 เม.ย. 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
How To High Light Rows In Excel | Conditional Formatting Technique
#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
TH-cam Handle : @geniusworldteam
Download Training File
drive.google.com/file/d/1WPEoTrS9tu_cCnUv5MgoeDKDOKrSjZlp/view?usp=sharing
In this video we will learn the use of conditional formatting to high light rows in excel. We need to create simple technique that will help us to high light rows whenever we click on it.
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
0:39 Use Conditional Formatting Technique
0:57 Use Formula To High Light
1:35 How To Write Code In Work Sheet
2:03 Test Our Formula
#How To High Light Rows In Excel | Conditional Formatting Technique
*************** 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 :
th-cam.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
TH-cam Handle : @geniusworldteam
Download Training File
drive.google.com/file/d/1WPEoTrS9tu_cCnUv5MgoeDKDOKrSjZlp/view?usp=sharing
In this video we will learn the use of conditional formatting to high light rows in excel. We need to create simple technique that will help us to high light rows whenever we click on it.
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
0:39 Use Conditional Formatting Technique
0:57 Use Formula To High Light
1:35 How To Write Code In Work Sheet
2:03 Test Our Formula
#How To High Light Rows In Excel | Conditional Formatting Technique
*************** 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 :
th-cam.com/channels/5mb_OR4V3ryCJPONSQV89A.html
Don't forget to subscribe to our channel for more great Excel tutorials!
Visit us at: Genius-World...
มุมมอง: 561
วีดีโอ
🔥 How To Create Income, Saving & Expense Donut Chart In Excel
มุมมอง 4528 วันที่ผ่านมา
#howtouse #howtocreate #vlookup #vlookupformula #vlookupformula #vlookupinexcel #vlookupfunction #vlookuup #dropdown #dropdownlist #dependent #datavalidation #vlookupformula #vlookupinexcel #xlookup #msexcelxlookup #xlookupformula #max #maximum #maxformula #vlookupinexcelinhindi #msexcel #donut #progresschart #chartanalysis #challenge #income #expensetracker #expenses #savings #saving #msexcel2...
🔥 Power of VLOOKUP & MATCH Function In Excel | Easy Method
มุมมอง 4543 หลายเดือนก่อน
#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 TH-cam Handle : @geniusworldteam Download Tra...
How To Create Winner Template In Excel | VLOOKUP & MAX In Excel
มุมมอง 803 หลายเดือนก่อน
#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 TH-cam Handle : @geniusworldteam Download Tra...
How To Create Drop Down List In Excel | Easy & Quick Method In Excel
มุมมอง 4813 หลายเดือนก่อน
#howtouse #howtocreate #drop #dropdown #dropdownlist #dependent #datavalidation #vlookupformula #vlookupinexcel #xlookup #msexcelxlookup #xlookupformula #vlookupfunction #vlookupinexcelinhindi #msexcel #msexcel2016 #msexcelfullcourse #GeniusWorld #@geniusworldteam TH-cam 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
มุมมอง 2663 หลายเดือนก่อน
#howtouse #howtocreate #xlookup #vlookup #vlookupformula #vlookupinexcel #xlookup #msexcelxlookup #xlookupformula #vlookupfunction #vlookupinexcelinhindi #msexcel #msexcel2016 #msexcelfullcourse #GeniusWorld #@geniusworldteam TH-cam Handle : @geniusworldteam Download Training File docs.google.com/spreadsheets/d/1Eyo7Dar84oihYzczoh3QgdyjOZJlrol-/edit?usp=sharing&ouid=100928782733267800224&rtpof=...
Easy Payroll System In Excel
มุมมอง 1863 หลายเดือนก่อน
#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. TH...
How To Use XLOOKUP Function In Excel | Easy XLOOKUP In Excel
มุมมอง 9804 หลายเดือนก่อน
How To Use XLOOKUP Function In Excel | Easy XLOOKUP In Excel
How To Create Strike Through In Excel and Conditional Formatting In Excel
มุมมอง 3594 หลายเดือนก่อน
How To Create Strike Through In Excel and Conditional Formatting In Excel
Use of Performance FORM and How To Create FORM In Excel | Data Entry Form In Excel
มุมมอง 1685 หลายเดือนก่อน
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
มุมมอง 2305 หลายเดือนก่อน
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
มุมมอง 885 หลายเดือนก่อน
Power of MACRO & IF Formula In Excel | Create & Use Excel Macros
Use of INDEX & MATCH Function In Excel | How to use Excel Index Match
มุมมอง 1076 หลายเดือนก่อน
Use of INDEX & MATCH Function In Excel | How to use Excel Index Match
Mastering Excel: Updating & Replacing Salary Data Tutorial
มุมมอง 676 หลายเดือนก่อน
Mastering Excel: Updating & Replacing Salary Data Tutorial
🔥 How to Create DICE GAME Macros in Excel Tutorial | MACRO CLASS # 03
มุมมอง 1029 หลายเดือนก่อน
🔥 How to Create DICE GAME Macros in Excel Tutorial | MACRO CLASS # 03
How to Create Macros in Excel Tutorial | MACRO CLASS # 02
มุมมอง 4729 หลายเดือนก่อน
How to Create Macros in Excel Tutorial | MACRO CLASS # 02
How to Create & Use Excel Macros | MACRO CLASS # 01
มุมมอง 1919 หลายเดือนก่อน
How to Create & Use Excel Macros | MACRO CLASS # 01
🔥 How To Create Purchase Analysis Report In Excel
มุมมอง 94811 หลายเดือนก่อน
🔥 How To Create Purchase Analysis Report In Excel
How to Use Excel Check Boxes | Easy & Simple In Excel
มุมมอง 408ปีที่แล้ว
How to Use Excel Check Boxes | Easy & Simple In Excel
How to Master Excel Tips & Tricks For Fastest Total
มุมมอง 224ปีที่แล้ว
How to Master Excel Tips & Tricks For Fastest Total
How to Master To Create Multiple Check Box In Excel | Thousands Check Boxes
มุมมอง 2.1Kปีที่แล้ว
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
มุมมอง 194ปีที่แล้ว
Data Entry Form in Microsoft Excel | Power of Data Entry in Excel
The Power of VLOOKUP | Use Of VLOOKUP | VLOOKUP In Excel
มุมมอง 78ปีที่แล้ว
The Power of VLOOKUP | Use Of VLOOKUP | VLOOKUP In Excel
🔥 Payroll in Excel | How to Create Payroll in Excel
มุมมอง 14Kปีที่แล้ว
🔥 Payroll in Excel | How to Create Payroll in Excel
Data Entry using Form in Microsoft Excel | Excel Data Entry
มุมมอง 215ปีที่แล้ว
Data Entry using Form in Microsoft Excel | Excel Data Entry
Use Conditional Formatting to Apply Strikethrough In Excel
มุมมอง 9Kปีที่แล้ว
Use Conditional Formatting to Apply Strikethrough In Excel
How To Separate Big Data Text Into Different Columns
มุมมอง 52ปีที่แล้ว
How To Separate Big Data Text Into Different Columns
Create Professional PayRoll Using VLOOKUP Only | Single Formula Payslip
มุมมอง 2.3Kปีที่แล้ว
Create Professional PayRoll Using VLOOKUP Only | Single Formula Payslip
Hupp
Thanks Sir 👍
Your welcome !!
Gross Pay = (pay per hour)(total hours worked) + (overtime pay per hour)(total overtime hours) Income Tax = Gross Pay * income tax rate (%) Net Pay = Gross Pay - (Gross Pay * income tax rate %) - other deductibles Pay: Hourly wage or salary rate. Total Hours Worked: Total regular hours worked in a given period. Overtime: Additional pay rate for hours worked beyond regular hours, typically higher than regular pay. Total Overtime Hours: The number of hours worked beyond the regular work hours. Gross Pay: Total earnings before deductions (includes regular and overtime pay). Income Tax: Percentage of Gross Pay deducted for taxes. Other Deductibles: Additional deductions like insurance, retirement contributions, etc. Net Pay: Final earnings after all deductions (Income Tax and Other Deductibles).
Nice to see your video, but if it fails here how to get out
Thank You and Yes, You can get different criteria in IF function to perform your desired outcome. !!!
Please can you do a video of excel for beginners
Thank You So much for your feedback. We are working on the course in two sections Ms Excel for Beginners and Advanced Ms excel. Hopefully we will start both simultaneously soon !!!
Thank you
Your Welcome !!!
Very simple to understand
Thank You !!!!
Young Elizabeth Miller Kenneth Jackson Mary
How did you get the other deductibles?
We have used the main elements that usually found in any organisation !!!!
Hi you provide online course
Apologize but we are working on it. Soon we will provide online course !!!
Lee Jennifer Davis Eric Hernandez Sharon
what money is represented by column pay, i thought it is gross but it is not,
Thank You for your comment. We have used the general formula in order to make it simple. We can add mutiple columns like medical expense or allowances to make it more realistic. Thank You.
thanks ❤❤
Your Welcome !!!!
Indeed you are a genius mate. Thanks for the help.
Thank you so much !!!
Nice❤
Thank You !!!
Not working
Please share reason or error. It will be helpful to identify error ???
@@geniusworldteam please send me your email i send you the raw file
Thank you so much bro🎉🎉
Your Welcome !!!
th-cam.com/video/3xu0dfK9pHQ/w-d-xo.htmlsi=Y5W1Odo9qV25C1kP
Good for students
Thank You for your feedback !!!
Thank you soo much sir for saving my time Tomorrow is my practical ❤❤
Your Welcome and Best of Luck for your Practical !!!!!
@@geniusworldteam thanks 💗💗 I really needed it 💜
Thanks🌉 for your accurate banking statement and ielts certificates💯 that was be done by @RAINTOOLZ
If I have more than 100 check box whether I need to link each every one one by one?
Thank You for your comment. You can use Google Excel sheet or Ms Excel 365 to create more than 100 check boxes. It will save time to link it. Otherwise you will need to link each cell separately.
hey thank you so muchhhh. hope you have a great day
Thank You and same to you!!!!
Can we do the same using between values
Yes, We can perform the same task with values as well.
🎉
Thank You
You need an award, you saved a soul bro. Thanks alot
Thank You very very much! Your kind words matters alot. It gives us encourage and support. Thank You !!!!!
Hello sir, could you help me with calculate a shipping price in excel, with 2 parameters? cant quite get it to work
Thank You. Yes, I will try to make it but kindly provide more detail. It will be helpful to assist in the calculation.
More over, I have also created short video on How to calculate shipping cost. Hopefully it will be helpful to you. Please find the link below; th-cam.com/users/shortsjrjBbqS3Uz8?feature=share
NICE INFORMATION,THANK YOU
Your Welcome!!!!
Very helpful, thank you
Thank You So Much!!!
🦵🦵🦵🦵🦵🦶🦶🦶🦶🦶🦵🦶🦶🦶🦶🦵🦵🦵💪🦶🦶🦶🦶😡👊😁😁👊👊👊
In some places its haooening but in someplaces itsays #NA
Thank You for your comment. Please make Table Array constant by pressing F4 after selecting table array. It will gives exact result.
What is background song name please ??
You can find the different background music in the TH-cam Music Library
It's what I'm looking, thanks
Thank you so much !!!!
🎉well deserved appreciate
Thank you so much !!!!
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. th-cam.com/video/c-kd145l0R4/w-d-xo.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!!!!