- 185
- 1 671 012
SYT Hindi
India
Registrace 26. 08. 2017
The main purpose of this CZcams channel is to tell us about computer applications like Microsoft Office, Photoshop, Tally etc.
About Computer Software and applications as well as New Technology and Computer Related, Tips and Tricks, You can know and learn on our CZcams channel "SYT Hindi".
इस यूट्यूब चैनल का मुख्य उद्देश्य है माइक्रोसॉफ्ट ऑफिस, फोटोशॉप, C Language ,C++ ,टैली ,जैसे कंप्यूटर एप्लीकेशन इत्यादि के बारे में बताना |
कंप्यूटर एप्लीकेशन और साथ-साथ नई तकनीक और कंप्यूटर संबंधित, टिप्स और ट्रिक्स
आप हमारे यूट्यूब चैनल "SYT हिंदी" पर जान सकते हैं और सीख सकते हैं।
► Visit the Website: sythindi1.blogspot.in/
► Like the Facebook Page: SYTHindi/
► Subscribe My CZcams Channel: czcams.com/channels/ZJm3q_OfmEzXppKDRSqUOw.html
► Follow on Google+: plus.google.com/u/0/116096307234955717987
► Follow on Twitter: SYTHindi1
About Computer Software and applications as well as New Technology and Computer Related, Tips and Tricks, You can know and learn on our CZcams channel "SYT Hindi".
इस यूट्यूब चैनल का मुख्य उद्देश्य है माइक्रोसॉफ्ट ऑफिस, फोटोशॉप, C Language ,C++ ,टैली ,जैसे कंप्यूटर एप्लीकेशन इत्यादि के बारे में बताना |
कंप्यूटर एप्लीकेशन और साथ-साथ नई तकनीक और कंप्यूटर संबंधित, टिप्स और ट्रिक्स
आप हमारे यूट्यूब चैनल "SYT हिंदी" पर जान सकते हैं और सीख सकते हैं।
► Visit the Website: sythindi1.blogspot.in/
► Like the Facebook Page: SYTHindi/
► Subscribe My CZcams Channel: czcams.com/channels/ZJm3q_OfmEzXppKDRSqUOw.html
► Follow on Google+: plus.google.com/u/0/116096307234955717987
► Follow on Twitter: SYTHindi1
Use INDEX and MATCH to Find the Three Highest Paying Employees in Excel
Use INDEX and MATCH to Find the Three Highest-Paying Employees in Excel
Introduction
Welcome to our tutorial on Excel! In this video we show you how to apply a method that is powerful enough to enable you find the top 3 employees on the basis of their salary using Excel’s INDEX and MATCH functions. If you want to identify your highest-paid employees quickly, whether as a team leader or somebody who deals with salary data, this approach serves you well.
In this tutorial, you will learn:
Using INDEX formula: Find out how to retrieve data from a particular location in your list;
Using MATCH Formula: Find out how specific values can be located within your dataset;
Combining INDEX and MATCH: Understand ways of ranking and retrieving 3 highest salaries through these formulas;
Dynamic Array Formula (Optional): Discover today's newest productivity features in Excel that simplify it all.
What You Need:
Basic understanding of Excel functions;
Sample salary data available on an Excel sheet.
Step by Step Guide
Set up your data:- Such as your employees’ pay should appear in a table;
Create helper columns:- Helper columns can be used for ranking salaries or finding top 3 highest salaries;
Apply the INDEX and MATCH Formulas:- Use these formulas together to get names and amounts paid to the 3 people with the highest amounts;
Display results:- Make the formatting easier to read and interpret for presentations
Please watch this video to get more information about this topic.
#Excel #INDEX #MATCH #ExcelTutorial #SalaryAnalysis #TopEmployees
► Visit the Website: sythindi1.blogspot.in/
► Visit the Website: pcitechno.weebly.com
► Like the Facebook Page: SYTHindi/
► Subscribe CZcams Channel: czcams.com/channels/ZJm.html...
► Follow on Twitter: SYTHindi1
Introduction
Welcome to our tutorial on Excel! In this video we show you how to apply a method that is powerful enough to enable you find the top 3 employees on the basis of their salary using Excel’s INDEX and MATCH functions. If you want to identify your highest-paid employees quickly, whether as a team leader or somebody who deals with salary data, this approach serves you well.
In this tutorial, you will learn:
Using INDEX formula: Find out how to retrieve data from a particular location in your list;
Using MATCH Formula: Find out how specific values can be located within your dataset;
Combining INDEX and MATCH: Understand ways of ranking and retrieving 3 highest salaries through these formulas;
Dynamic Array Formula (Optional): Discover today's newest productivity features in Excel that simplify it all.
What You Need:
Basic understanding of Excel functions;
Sample salary data available on an Excel sheet.
Step by Step Guide
Set up your data:- Such as your employees’ pay should appear in a table;
Create helper columns:- Helper columns can be used for ranking salaries or finding top 3 highest salaries;
Apply the INDEX and MATCH Formulas:- Use these formulas together to get names and amounts paid to the 3 people with the highest amounts;
Display results:- Make the formatting easier to read and interpret for presentations
Please watch this video to get more information about this topic.
#Excel #INDEX #MATCH #ExcelTutorial #SalaryAnalysis #TopEmployees
► Visit the Website: sythindi1.blogspot.in/
► Visit the Website: pcitechno.weebly.com
► Like the Facebook Page: SYTHindi/
► Subscribe CZcams Channel: czcams.com/channels/ZJm.html...
► Follow on Twitter: SYTHindi1
zhlédnutí: 40
Video
Welcome to the Python Programming Syllabus Series! 🐍📚
zhlédnutí 25Před 7 hodinami
The initial video of our extensive course on Python illustrates the foundation of your programming expedition. This series caters to transforming total novices into able Python developers and the introduction serves as first step. In This Video: Course Overview: This is an overview of what to expect in the entire series, including key subjects and skills. Why Python?: Find out why Python is a b...
MIS Job Interview Tips & Tricks for Mastering SUMPRODUCT Formula
zhlédnutí 61Před 12 hodinami
MIS Job Interview Tips & Tricks for Mastering SUMPRODUCT Formulas! 📊 Are you looking to prepare yourself against all chances when it comes to facing difficult questions during a MIS (Management Information Systems) job interview?If yes, then you are definitely at the right place! In this video, we dive deep into essential tips and tricks that will help you stand out in your interview. 🔍 What Yo...
Flash Fill in Excel: The way to master it for an MIS interview and day-to-day usage
zhlédnutí 43Před 14 hodinami
Welcome to our channel! In this video, we are going to explore one of the most powerful features of Excel-Flash Fill. Whether you are preparing for the Management Information Systems interview or simplifying your daily tasks at work, understanding Flash Fill will prove to be very beneficial. Flash Fill: Understand what Flash Fill is and how it works for auto-filling the data based on patterns. ...
Double VLOOKUP in Excel || Step by Step Tutorial
zhlédnutí 73Před 19 hodinami
In this easy-to-follow video, learn how you can do a double VLOOKUP in Excel. You will be walked through using two VLOOKUP functions together to cross-reference data from two different tables. The technique is great for complex analysis where you have to fetch information according to more than one criterion. What You'll Learn: How to set up your data for a double VLOOKUP, step-by-step guide on...
Use IFERROR Formula to Handle Errors in VLOOKUP
zhlédnutí 94Před 14 dny
Dealing with error prompts on Excel can be tasking? You can master the use of IFERROR function using VLOOKUP in this short and straightforward tutorial! 🚀 Here, we demonstrate on how to combine IFERROR with VLOOKUP so that you can easily tackle those annoying #N/A and related error messages. If you are just starting out with Microsoft Excel or want to improve your expertise, this piece will sho...
Mastering Journal Entries in Tally Prime Step by Step Guide
zhlédnutí 61Před 21 dnem
Mastering journal entries aspect the powerful Tally Prime potential with this well detailed guide on how to do it. Whether you are new to Tally Prime or an experienced accountant willing to gain further skills, in this tutorial we shall cover everything on creation and management of journals in Tally Prime. In this video we will: Give you a brief introduction into journal entries. Demonstrate w...
How to Use Vouchers in TallyPrime | Complete Guide
zhlédnutí 111Před měsícem
Welcome to our complete guide on the use of vouchers in TallyPrime! In this video, we're going to walk you thru the entirety you need to recognise approximately vouchers in TallyPrime, from knowledge their types to creating, altering, and handling them efficaciously. In This Video: Introduction to Vouchers in TallyPrime Types of Vouchers: Sales, Purchase, Payment, Receipt, Journal, Contra, Debi...
How to Alter a Ledger in Tally Prime | Step-by-Step Guide
zhlédnutí 135Před měsícem
Welcome to our Tally Prime tutorials series! This video will guide you on how to modify an existing ledger in Tally Prime. Step by step guide suitable for both beginners with no experience at all and experts who need some tips on changing their ledger details easily will enable you to do so and keep updated records. 📝 What You'll Learn: How to navigate to the ledger alteration screen in Tally P...
Microsoft Word Tutorial हिंदी Complete MS Word Tutorial
zhlédnutí 175Před měsícem
Welcome to our complete Microsoft Word educational! Whether you're a newbie simply starting out or a sophisticated user seeking to refine your capabilities, this step-by means of-step manual has the entirety you want to grasp Microsoft Word. In this educational, we cover: 00:00 Introduction Overview of Microsoft Word Benefits of getting to know Word 03:00 Getting Started with Microsoft Word Pro...
How to Create a New Ledger & Understand Groups in Tally Step-by-Step Guide.
zhlédnutí 108Před 2 měsíci
Welcome to our Tally tutorial! In this video, we'll walk you through the process of creating a new ledger in Tally and explain what is under a group. Whether you're a beginner or looking to refresh your skills, this guide will help you understand the basics of ledger creation and grouping in Tally. Download Link: rb.gy/0se429 || rb.gy/hlpg2w || rb.gy/ar892i What You'll Learn: How to create a ne...
What is TallyPrime? | How to Create a New Company in TallyPrime
zhlédnutí 63Před 2 měsíci
What is TallyPrime? | How to Create a New Company in TallyPrime
Mastering Trade and Cash Discounts in Tally Prime | Complete Guide
zhlédnutí 73Před 2 měsíci
Mastering Trade and Cash Discounts in Tally Prime | Complete Guide
Mastering Journal Entries in Tally ERP 9: Step-by-Step Guide for Beginners
zhlédnutí 608Před 3 měsíci
Mastering Journal Entries in Tally ERP 9: Step-by-Step Guide for Beginners
Journal Entries of Accounting for Tally Prime
zhlédnutí 145Před 3 měsíci
Journal Entries of Accounting for Tally Prime
Classifications of Accounts & Golden Rules
zhlédnutí 134Před 5 měsíci
Classifications of Accounts & Golden Rules
Tally Prime for Beginners Course in Hindi | Tally Tutorial in Hindi | Part-1
zhlédnutí 308Před 5 měsíci
Tally Prime for Beginners Course in Hindi | Tally Tutorial in Hindi | Part-1
Tally Course Syllabus | Tally Prime Course Content
zhlédnutí 288Před 7 měsíci
Tally Course Syllabus | Tally Prime Course Content
Excel tutoring from basic to advance in hindi
zhlédnutí 4,1KPřed 8 měsíci
Excel tutoring from basic to advance in hindi
EXCEL 🔥 View Tab | Complete Tutorial in Hindi | MS Excel 2021
zhlédnutí 176Před 8 měsíci
EXCEL 🔥 View Tab | Complete Tutorial in Hindi | MS Excel 2021
EXCEL 🔥 Review Tab | Complete Tutorial in Hindi | MS Excel 2021
zhlédnutí 138Před 8 měsíci
EXCEL 🔥 Review Tab | Complete Tutorial in Hindi | MS Excel 2021
Formula Tab Complete Use in Hindi | Excel Tutorial for beginners in Hindi
zhlédnutí 83Před 8 měsíci
Formula Tab Complete Use in Hindi | Excel Tutorial for beginners in Hindi
Date and Time Function in Ms Excel in Hindi | Date and Time Formula in Excel 2021
zhlédnutí 253Před 8 měsíci
Date and Time Function in Ms Excel in Hindi | Date and Time Formula in Excel 2021
Logical Formulas in excel, If, or, and, true, false, in Microsoft Excel 2021
zhlédnutí 215Před 8 měsíci
Logical Formulas in excel, If, or, and, true, false, in Microsoft Excel 2021
Mathematics Formulas in MS Excel 2021
zhlédnutí 139Před 9 měsíci
Mathematics Formulas in MS Excel 2021
Lookup & References formulas in MS Excel 2021
zhlédnutí 106Před 9 měsíci
Lookup & References formulas in MS Excel 2021
Complete MS Excel 2021 Tutorial ~ Day 18
zhlédnutí 158Před 9 měsíci
Complete MS Excel 2021 Tutorial ~ Day 18
Complete MS Excel 2021 Tutorial ~ Day 17
zhlédnutí 127Před 9 měsíci
Complete MS Excel 2021 Tutorial ~ Day 17
Bhiya esme core Python bhi hoga
yes
@@SYTHindi Complete Python hoga q ki bahut sare youtuber half hi syllabus karte hai
But date ka format change ho gya ctr+e
Yes, u can change date format (ctrl +1) -> custom -> type dd-mmm-yyyy
Ok
ਬਹੁਤ ਵਧੀਆ ਜਾਣਕਾਰੀ ਜੀ ♥️👍
Thank you sir
Awesome 👍
Bahut badhiya video hai❤
👍👍
Jaise mai ek sheet me row ya column plus kare to apne aap dusre me column ya row plus hojaye
Ye kaise hoga plz send me tutorial
Plus kya karna hai aapko?
thanks sir g Allah Pak ap ko tareqii Dy Ammeeeen
It didn't work in Philippines
Plz try again..
Thanku
Best way to define
❤❤❤❤❤
Great Bro, lekin jo starting me Syntex ko explain kiya tha, waise hi sabko karna chahiye tha
Please continue tally tutorials ...
Well done ❤❤ sir g
Very nice need more videos like these
Sir you can write in plian English ❤❤ i don't understand Hindi ok sir thanks
Sir I am very interested telly account ❤❤ good luck
Give me number plz
Links is virus really
Links file not working
Hlookup lgany k liye rowa mein table ko kasy convelt krty please guide me
I like this video
Very nice sir ❤
Excellent job🎉
Excel Class Playlist mein Part wise dalo
Microsoft Excel 2019 Complete Course: czcams.com/play/PLVpCABsWeOJ9dgzV9Vxq1IwWkW6hmlck4.html
Useful video.
The file with the commands is not working anymore, Can you share the commands in comment section ? or share me the file again pls
Please double check the link given in the comments below.👍
Thanks sir
Good
V lookup is se accha pure youtube par nahi hai 👍🏻
Sir fir in shape ko htate kaise hain
Select and delete
Excellent example
Bahut achha sir❤❤❤
Excellent Guru❤❤❤
Sir ap to aise samjhate ho ki kisike man me ki doubt hi peda nhi hua. Agar hua bhi to jhat clear ho jayega. kyuki Apne chote chote baat ko bhi clear ki hai. Thanks sir❤
Bhaiya Jha formula use kr the hai uska screenshot le Sakta hu kya please reply
Thanks. But vlookup aur lookup me kya fark hai ?
Vlookup- Vertical database and Hlookup- Horizontal database ko match & specific data ko find karne ke liye use kiya jata hai..
tysm sir!!
Namaste
Thank you, this solved my problem. The file from the video describtion cannot be accessed anymore, but all the commands are show in the video.
Glad it helped
thank you so much aap bohot acche ho
Thanks sir for vodio share
Bahut Acha explain kare sir. Nice explanation
Thank you sir ji
First Thankyou Sir Well Explain and This is very very helpful me
All the best