Thank You to my Mentor who gave this Wonderful Trick😇😇😇💯💯💯 Tricks to get more interview calls
Use this LinkedIn hack:
- Go to LinkedIn search bar on top. - Type query like: {job role} and ("hiring" or "requirement") - Example: data engineer requirements - press enter - On the result page select "Posts" as filter - Sort it by Latest - Done
Now you will see requirements which has been posted very recently.
These are requirements that are NOT posted as Jobs and hence go unnoticed
Upcoming video How you can compute group wise rank in excel using SUMPRODUCT. Yes it is same as DENSE_RANK SQL window function. There are two other advantages related to this function. (1.)GROUP wise sum(computing sum of a group in one go.) (2.)GROUP wise percentage of each record(total of individual groups and percentage value of each record.) Till then Keep Learning. Happy Diwali.
Hello Data Enthusiasts, This was my first corporate training session based on Microsoft Excel at our office. The major glimpses from the session were :
1)EXCEL basics and its advantages.
2)All types of lookup techniques-VLOOKUP,HLOOKUP,XLOOKUP
3)Understanding INDEX and MATCH functions
4)PIVOT TABLE:-A PivotTable is especially designed for: Querying large amounts of data in many user-friendly ways. Subtotaling and aggregating numeric data, summarizing data by categories and subcategories, and creating custom calculations and formulas.
5)SUMIF,SUMIFS,COUNT,COUNTIF,COUNTIFS,AVERAGEIF,AVERAGEIFS
6)INDEX MATCH and its advantages over VLOOKUP(explained in the image)
Statistics made Easy
Statistics made Easy
DataCamp Free Week Quality Courses
Do check this Link below 👇
www.datacamp.com/campaign/nov-free-access-week-202…
2 months ago | [YT] | 0
View 0 replies
Statistics made Easy
Thank You to my Mentor who gave this Wonderful Trick😇😇😇💯💯💯
Tricks to get more interview calls
Use this LinkedIn hack:
- Go to LinkedIn search bar on top.
- Type query like: {job role} and ("hiring" or "requirement")
- Example: data engineer requirements
- press enter
- On the result page select "Posts" as filter
- Sort it by Latest
- Done
Now you will see requirements which has been posted very recently.
These are requirements that are NOT posted as Jobs and hence go unnoticed
But now you can grab all these as well.
10 months ago | [YT] | 0
View 0 replies
Statistics made Easy
Upcoming video
How you can compute group wise rank in excel using SUMPRODUCT.
Yes it is same as DENSE_RANK SQL window function.
There are two other advantages related to this function.
(1.)GROUP wise sum(computing sum of a group in one go.)
(2.)GROUP wise percentage of each record(total of individual groups and percentage value of each record.)
Till then Keep Learning.
Happy Diwali.
2 years ago (edited) | [YT] | 0
View 0 replies
Statistics made Easy
Hello Data Enthusiasts, This was my first corporate training session based on Microsoft Excel at our office. The major glimpses from the session were :
1)EXCEL basics and its advantages.
2)All types of lookup techniques-VLOOKUP,HLOOKUP,XLOOKUP
3)Understanding INDEX and MATCH functions
4)PIVOT TABLE:-A PivotTable is especially designed for: Querying large amounts of data in many user-friendly ways. Subtotaling and aggregating numeric data, summarizing data by categories and subcategories, and creating custom calculations and formulas.
5)SUMIF,SUMIFS,COUNT,COUNTIF,COUNTIFS,AVERAGEIF,AVERAGEIFS
6)INDEX MATCH and its advantages over VLOOKUP(explained in the image)
KEEP LEARNING
KEEP GROWING
HAPPY DIWALI
2 years ago (edited) | [YT] | 4
View 1 reply
Statistics made Easy
Happy Diwali Everyone
2 years ago | [YT] | 3
View 0 replies