- Видео 19
- Просмотров 149 106
bit by curiosity
Индия
Добавлен 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
Просмотров: 547
Видео
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: ruclips.net/video/fL2b3OJnLrk/видео.html Link to calculate median in Pivot table: ruclips.net/video/MgbUeW0Xhvk/видео.html
What is Compa Ratio, How to calculate compa ratio in excel for employee data PART 1
Просмотров 2,5 тыс.3 года назад
This video covers explanation of compa ratio and method to calculate for multiple employee data Link to calculate median in Pivot table: ruclips.net/video/MgbUeW0Xhvk/видео.html
Retention Rate Explanation, Formula and Calculation in Excel || Employee Retention Rate
Просмотров 15 тыс.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
Просмотров 6023 года назад
In this video, I will explain the Filter Function in Ms Excel. It is available for office 365 users. Link to Xlookup: ruclips.net/video/JfU4wo08WQg/видео.html
HR Recruitment Dashboard.. connecting Picture with Slicer and making Funnel Chart
Просмотров 8 тыс.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
Просмотров 31 тыс.4 года назад
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.
Просмотров 44 тыс.4 года назад
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
Просмотров 2574 года назад
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
Просмотров 1604 года назад
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
Просмотров 1164 года назад
Create Dependent Drop-down list in excel
Creating Dropdown list in excel|| Data Validation list in excel
Просмотров 1654 года назад
Creating Dropdown list in excel|| Data Validation list in excel
Calculate Median in Pivot table (PowerPivot) || Median in excel
Просмотров 4 тыс.4 года назад
Calculate Median in Pivot table (PowerPivot) || Median in excel
Create Dummy Data using Rand(), Randbetween() and Choose() functions|| Generate Random data in excel
Просмотров 4354 года назад
Create Dummy Data using Rand(), Randbetween() and Choose() functions|| Generate Random data in excel
thank you
how shall we connect with you for doubts clarification?
very intriguing to use. thank you so much for sharing.
this is so helpful! thank you for this. but i cant seem to find the tick box for adding this data to the data model. anyone who can answer me?
Thank you Mam! Excellent
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
ruclips.net/video/tgBXh6-DFQQ/видео.html how can we make this one could please make video on this