How to create an Insurance tracker and manage Insurance policies efficiently using Excel

Поделиться
HTML-код
  • Опубликовано: 15 сен 2024

Комментарии • 16

  • @user-gt9uj2no2t
    @user-gt9uj2no2t Год назад +1

    Thank you very much for this tutorial!!! I got my license as an insurance advisor in 2020. This is a great tool i can use to service my clients! Thank you.

  • @subahn6865
    @subahn6865 4 года назад +1

    This is brilliant! Thank you so much for such a clear and detailed online tutorial. So useful as well.

  • @dhavalbhavsar9684
    @dhavalbhavsar9684 4 года назад +1

    Amazing. This is what I was looking for. Excellent idea and design. Thank You.

  • @graceharney7352
    @graceharney7352 2 года назад +1

    thank you for this video! it's not exactly what i'm looking for, but it's always nice to learn new excel shortcuts! :D *edit* this may help me with what i'm trying to do after all!

  • @dhavalbhavsar9684
    @dhavalbhavsar9684 4 года назад +2

    Followed all steps as per your instruction and it turned out to be amazing. Thank You once again. Just one suggestion there are many months that are missing which do not have any payments so these months are not reflected in the table. As a result the table does not look like a calendar. A calendar look will help more in visualizing the data. Please guide for the same. Thank You. Really love your work. Keep posting amazing organizers/trackers. Thank You.

    • @Excelrush
      @Excelrush  4 года назад +1

      Thank you!
      For the calendar look, just add a row with a sample date of each month only, don't put any other detail, and then refresh the pivot table.

    • @dhavalbhavsar9684
      @dhavalbhavsar9684 4 года назад

      @@Excelrush okay. Thank you

  • @amitpasad
    @amitpasad 4 года назад +1

    Buddy your talent is way above others in excel. How can we manage halfyearly or quarterly premiums, where it calculates automatically the next due date

  • @johnmahugu3527
    @johnmahugu3527 3 месяца назад +1

    template?

  • @dhavalbhavsar9684
    @dhavalbhavsar9684 4 года назад +1

    Also can we get the data in particular year (say 2020) calendar format.

    • @Excelrush
      @Excelrush  4 года назад

      The pivot table concept can be used for it.

  • @bhavneshparikh8283
    @bhavneshparikh8283 2 месяца назад

    how to downlaod this file?

  • @KRISHNAPRASAD-ce1pp
    @KRISHNAPRASAD-ce1pp 3 года назад +1

    Sir can we use these type for LIC agents for managing customers policy?

  • @parthphansalkar8423
    @parthphansalkar8423 2 года назад

    How to keep track of insurance if it has monthly or semi annual premium date?

    • @Excelrush
      @Excelrush  2 года назад +1

      Put 2 entries separately