- 19
- 142 664
bit by curiosity
India
Приєднався 24 гру 2020
I have always loved working on data and have been an excel geek. This channel is here to help you learn Excel and other related tools to help you save your time with day to day tasks. I will not only talk about different excel functions and formulas but also their applicability in the corporate world.
My aim is to solve a data-related problem statement and explain the formulas and functions that are used.
Do share the problem statements that you are trying to solve I will be happy to do a related video on the same.
Also if you like my content please subscribe to my channel and show some love by clicking on the thumbs up button... Stay Safe & Keep Learning.
My aim is to solve a data-related problem statement and explain the formulas and functions that are used.
Do share the problem statements that you are trying to solve I will be happy to do a related video on the same.
Also if you like my content please subscribe to my channel and show some love by clicking on the thumbs up button... Stay Safe & Keep Learning.
Learning Dashboard for HR in Excel || HR Learning Dashboard || Connect Multiple Pivot tables PART 1
In this video we will build learning dashboard.
Link to Excel sheet for practice 1drv.ms/x/s!AsLIbzekJMEngiSWi57_CIiHEEnK?e=qDgixM
Link to Excel sheet for practice 1drv.ms/x/s!AsLIbzekJMEngiSWi57_CIiHEEnK?e=qDgixM
Переглядів: 506
Відео
What is Compa Ratio, How to calculate compa ratio in excel for employee data PART 2
Переглядів 1,4 тис.3 роки тому
This video covers a detailed and complex example of calculating compa Ratio. Link for Part 1: ua-cam.com/video/fL2b3OJnLrk/v-deo.html Link to calculate median in Pivot table: ua-cam.com/video/MgbUeW0Xhvk/v-deo.html
What is Compa Ratio, How to calculate compa ratio in excel for employee data PART 1
Переглядів 2,4 тис.3 роки тому
This video covers explanation of compa ratio and method to calculate for multiple employee data Link to calculate median in Pivot table: ua-cam.com/video/MgbUeW0Xhvk/v-deo.html
Retention Rate Explanation, Formula and Calculation in Excel || Employee Retention Rate
Переглядів 14 тис.3 роки тому
Employee Retention Rate, Retention Rate Formula, calculating Retention in Excel. #HRAnalytics #HRDashboard
Attrition Rate Explanation, Formula and Calculation || Employee Attrition
Переглядів 12 тис.3 роки тому
Employee Attrition, Attrition Rate Formula, calculating Attrition and Annualized Attrition in Excel.
Filter Function in Ms Excel... Available in Office 365
Переглядів 5873 роки тому
In this video, I will explain the Filter Function in Ms Excel. It is available for office 365 users. Link to Xlookup: ua-cam.com/video/JfU4wo08WQg/v-deo.html
HR Recruitment Dashboard.. connecting Picture with Slicer and making Funnel Chart
Переглядів 7 тис.3 роки тому
Ladt video in series of 7 videos where you can learn about how to create an HR Recruitment Dashboard. In this video, connecting picture with Slicer and making funnel chart
HR Recruitment Dashboard.. Making Dashboard Dynamic using Slicer
Переглядів 8 тис.3 роки тому
6th video in series of 7 videos where you can learn about how to create an HR Recruitment Dashboard. In this video, we will add slicers to our Dashboard
HR Recruitment Dashboard.. Creating Gender Infographic in Excel
Переглядів 9 тис.3 роки тому
5th video in series of 7 videos where you can learn about how to create an HR Recruitment Dashboard. In this video, we will convert a column chart to a Male, Female infographic
HR Recruitment Dashboard.. add and update emoji using conditional formatting
Переглядів 6 тис.3 роки тому
3rd video in series of 7 videos where you can learn about how to create an HR Recruitment Dashboard. In this video, we will cover adding an emoji using conditional formatting and updating it basis candidate feedback score
HR Recruitment Dashboard.. How to add picture in Excel Bar Charts
Переглядів 6 тис.3 роки тому
4th video in series of 7 videos where you can learn about how to create an HR Recruitment Dashboard. In this video, we will add pictures in Excel Bar Chart
HR Recruitment Dashboard....understanding Recruitment Metrics
Переглядів 29 тис.3 роки тому
2nd video in series of 7 videos where you can learn about how to create an HR Recruitment Dashboard. In this video, we will cover understanding few recruitment metrics and how to calculate them on excel
HR Recruitment Dashboard.. understanding Recruitment Tracker and data set.
Переглядів 42 тис.3 роки тому
1st video in series of 7 videos where you can learn about how to create an HR Recruitment Dashboard. In this video, we will cover understanding the data and a basic recruitment tracker
New Lookup formula in Excel|| XLOOKUP expalined|| 4 features & how to use it for free in the end
Переглядів 2503 роки тому
Are you a VLOOKUP fan or do you dread Vlookup? whichever category you fall into this new Lookup formula can solve multiple problem statements and is super easy to use... I have explained 4 features on Xlookup in this tutorial... Also, stay tuned till the end to know how you can practice it for free if you do not have an office 365 subscription and also a potential problem if you are sharing a f...
Grouping data in Pivot table using Group Field
Переглядів 1573 роки тому
Learn how to group number ranges in the Pivot table without using IF. You can use Group Field to group numbers.
Create Dependent Drop-down list in excel
Переглядів 1143 роки тому
Create Dependent Drop-down list in excel
Creating Dropdown list in excel|| Data Validation list in excel
Переглядів 1623 роки тому
Creating Dropdown list in excel|| Data Validation list in excel
Calculate Median in Pivot table (PowerPivot) || Median in excel
Переглядів 3,9 тис.3 роки тому
Calculate Median in Pivot table (PowerPivot) || Median in excel
Create Dummy Data using Rand(), Randbetween() and Choose() functions|| Generate Random data in excel
Переглядів 4253 роки тому
Create Dummy Data using Rand(), Randbetween() and Choose() functions|| Generate Random data in excel
I am at the age 45 having good recruitment expereince but not able to make data and losing jobs how can I learn from you, is there a way I can put queries to you
Plz provide excel data
Thank you!I have learnt deep, new and useful information. Keep it up!
this is very useful.. thank you
Thanks maam
Good but You should provide raw data also for practice. How to download this Excel?
simple and amazing ❤
Please share the formulas you use in Excel for grouping data in pivot
Please explain the formula for finding missing cells using isblank.
Learn english please stop with that accent is fucking annoyng!
Do you have any tutorials for Campus Recruitment as well?
Nice video... How you got Role A as 20 and Role B as 30
nice put excel file in the description video
I love these videos, I'm trying to create a simple recruitment dashboard and this is is full of simple but creative ideas. The problem I have is the excel formulas, for some reason I 'm not able to get the formula for open positions. I keep getting an error. It would be helpful if you can provide or go a bit slower when explaining the formulas. Can you share your worksheet?
i want this data from where it canget
Thanks for the video . Please share the data sheet so i can practice as guided
Could you pls share me the datasets with me for my portfolio projects
Hi
Hi Do you hav an Instagram account. Your content is very useful
Thank you thank you so much. Am a recruiter and I have been struggling to create dashboards . This is exactly what I wanted
@yanasherine
hey. great video but just one thing can you also add the requirements/purpose of creating the dashboard and in the end if there was any benefit out of it? if you read my comment, can you write a small brief as to what can be written for that?
Working sheet works fine but in recruitment dashboard numbers are not changing in recruitment funnel nor in source mix. please suggest
Fast to understand
excellent didi ji
Wow CTC 🤑
Very nice 👍
Candidate details sheet doesnt contain candidate name, how many candidates were sourced position wise which are important data as far a recruitment tracker is concerned. Appreciate if you have a sheet with those details as well and how we can bring it to the dashboard as a metric
Which software used for Recruitment
Thank you so much. Very useful
Hi I am unable to see manage relationship icon. Can you please help me with this. Also I am not able to see other tables for report connection
hello, I am working on the Excel dashboard and your videos are more relevant. I need some help... how can I connect with you?
Nice work
Great video thank you for sharing. HireMe is the best applicant tracking software for all types of businesses, which helps to ease the hiring process of businesses. With the help of HireME, you can automate the entire recruitment process from job posting to candidate sourcing to hiring.
Thank you so much for sharing the useful information. The recruitment process can be streamlined and simplified by the use of some suitable tools like the Recruitment Management System "HireME cloud". HireMe is the most trusted and useful recruitment management software, currently used by more than 100 companies.
Super useful. Many thanks to you 👍
Thank you! A good idea and explanation ☺️
So interesting and so simple! I have never thought that it works like that. Thank you ☺️
Really useful info and very well explained, all 7 videos. Thank you so much!
Can I have your email id have some doubt
Fantastic
if i will do this in PowerBI than how can i make relationship between these table . Please reply
Really Appreciate! I got the idea ... Thank you
Hello Mam, it was a very informative and helpful video you made. Thank you very much. And keep doing much more videos like this. Thank you once again.
I am not able to calculate average time to fill as it says it cannot be calculated as its not supported calculation for text data types
Please help how to resolve
ua-cam.com/video/tgBXh6-DFQQ/v-deo.html how can we make this one could please make video on this
ua-cam.com/video/tgBXh6-DFQQ/v-deo.html teach how to Make like this one but full version how he make
Hey I have a query - What if we add new Position to the sheet in Position detail, will it reflect the changes in the Unique values because mine is not reflecting.
Thank you
Very Informative Video...Appreciated your effort in making such a video..Keep going...Kindly share the dataset for practice...
Really Appreciated the kind of effort you have put on to make such videos...Make videos on HR analytics...