How to Build a Recruitment Funnel Chart in Excel

แชร์
ฝัง
  • เผยแพร่เมื่อ 1 ธ.ค. 2024

ความคิดเห็น • 25

  • @daniellegarner8346
    @daniellegarner8346 ปีที่แล้ว +1

    Thank You so much for creating these videos. I'm a new recruiter for a small company with limited funds and these have been AMAZING!!! I LOVE recruiting and I know we had data and we had data with no intentional direction of HOW to translate it from a business perspective. These videos allow me to solve the data problem and paint a comprehensive picture of where improvements need to be made. thank you !!!

    • @indzara
      @indzara  ปีที่แล้ว

      You are welcome. We are glad that our template was helpful. Thank you for sharing your valuable feedback.
      I would like to let you know that we also have premium version of the template with more insights. Following is the link to the template for quick reference:
      indzara.com/product/hr-excel-templates/recruitment-manager-excel-template/
      We also have a Power BI template to handle end to end HR process with 29 reports and 87 metrics:
      www.hrreportingtools.com/power-hr
      Best wishes.

  • @siddharthrealityoperations2654
    @siddharthrealityoperations2654 5 ปีที่แล้ว +1

    Sir, you have resolved my problem very easily, thank u so much and "God bless you"

    • @indzara
      @indzara  5 ปีที่แล้ว

      Glad to hear. Thanks for feedback.
      Best wishes.

  • @srunsophal1969
    @srunsophal1969 3 ปีที่แล้ว +1

    Could you provide more about headcount planning, headcount fill in date, report by monthly or annual, and beauty full dashboard. Thanks

    • @indzara
      @indzara  3 ปีที่แล้ว

      Thank you for showing interest in our template.
      Requesting to check our Recruitment Manager template which has the required features. Following is the link to the template:
      indzara.com/product/recruitment-manager-excel-template/
      Best wishes.

  • @clanzon97
    @clanzon97 ปีที่แล้ว +1

    Can these tables be imported to power bi?

    • @indzara
      @indzara  ปีที่แล้ว

      Thank you for showing interest in our template.
      We have similar template in power BI. Following is the link to the same for quick reference:
      indzara.com/recruitment-tracker-2023-free-recruitment-template-in-power-bi/
      Following is the premium version of the template:
      indzara.com/product/hr-excel-templates/power-bi-templates-recruitment-dashboard-excel-templates/
      Best wishes.

  • @cardstrades
    @cardstrades 2 ปีที่แล้ว

    Hi you have been very helpful. Thank you for the information on the last video. I can’t seem to the formula @4:13. I have poor eye sight

    • @indzara
      @indzara  2 ปีที่แล้ว +1

      Thank you for sharing your valuable feedback.
      Following is the formula typed during the specified time frame:
      =IF(Sheet1!$I$1="HIRED",COUNTIFS(T_APPS[STAGE],B4),COUNTIFS(T_APPS[STAGE],B4,T_APPS[STATUS],"Closed"))
      Best wishes.

  • @AvinashRed
    @AvinashRed 5 ปีที่แล้ว +1

    You are doing nice work...

    • @indzara
      @indzara  5 ปีที่แล้ว

      Thank you for the feedback. Feedback such as yours helps me keep doing this.
      Best wishes.

  • @karthikp1297
    @karthikp1297 3 ปีที่แล้ว

    Hi, thanks for your time and support. I am getting error while I am adding =countifs(T_APPS[stage],c5). can you help me to solve this please.

    • @indzara
      @indzara  3 ปีที่แล้ว

      Thank you for using our template.
      Requesting to share your sheet to support@indzara.com along with some screenshot highlighting your requirement/concern to check further.
      Best wishes.

  • @gemmabangma5092
    @gemmabangma5092 5 ปีที่แล้ว

    Hello Indzara, Thank you for the great video. I am having difficulty with the =COUNTIFS(T_APPS[STAGE],B4) formula. I keep getting an error code for this formula.
    Would you have any suggestions on what I might be doing incorrectly?
    Thankyou,
    Gemma

    • @indzara
      @indzara  5 ปีที่แล้ว

      You are welcome.
      Please ensure the T_APPS[Stage] has the correct values. What error do you get?
      Best wishes.

  • @jojykuriappilly4339
    @jojykuriappilly4339 5 ปีที่แล้ว

    Hi Indzara, Great video, Thank you. I am getting error while I am using this formula. IF(sheet1!I1$!$I1..... Could you please post exact formula here?

    • @indzara
      @indzara  5 ปีที่แล้ว

      Thank you.
      Please see this for the complete file with formulas: indzara.com/2015/09/recruitment-tracker-free-excel-template/
      Best wishes.

  • @on2fashion300
    @on2fashion300 4 ปีที่แล้ว

    Can we copy this tracker in google sheet? if yes then how, please explain

    • @indzara
      @indzara  4 ปีที่แล้ว

      For a Google sheets template for recruitment tracking, please see indzara.com/2020/01/recruitment-tracker-for-google-sheets-free/
      All Google sheets templates: indzara.com/free-google-sheet-templates/
      Best wishes.

  • @lukejones5095
    @lukejones5095 3 ปีที่แล้ว

    what if i want to change from 4 steps to 5 6 or 7?

    • @indzara
      @indzara  3 ปีที่แล้ว

      You will have top repeat the same steps used to add 4 stage.
      If you want to get a template with 6 stage and advance report, requesting to check the below link:
      indzara.com/product/recruitment-manager-excel-template/
      Best wishes.

  • @melissajimenez6697
    @melissajimenez6697 2 ปีที่แล้ว

    mentioning how to highlight two columns of information that are not right next to eachother would be hel[ful

    • @indzara
      @indzara  2 ปีที่แล้ว

      Sorry, I do not understand your concern, can you share some screenshot of your requirement to support@indzara.com to check further.
      Best wishes.

    • @indzara
      @indzara  2 ปีที่แล้ว

      If you meant selecting two columns not next to each other, please press and hold the Control key while clicking on column headers. thanks & best wishes.