My name is Dinesh Natarajan Mohan and my background is in reporting and analytics. I have led teams of managers, analysts and developers in building strong reporting and analytical platforms that helped make sound business decisions in Marketing and Operations domains of large corporations in U.S.  LinkedIn profile.

I believe that simple tools can lead to effective solutions for common needs at home and in business environments. These tools, developed to leverage the power of computers and commonly available software, can vastly improve decision making. It can help us save time, money and energy. My goal is to build and share such tools/solutions. I also hope to learn a lot along the way.

In order for my solutions to reach a wide audience, I decided to choose from the most commonly available software applications on computers worldwide. I chose Microsoft Excel as it is not only one of the most widely available and used applications in the world, it is also one of the most powerful ones. Though I have used it for more than 13 years (on and off), I am not even close to an Excel expert. I learn a lot everyday from Excel experts (List of Excel Experts that I learn from) The users need to have just Microsoft Excel installed in their computers in order to benefit from my solutions.
I am now creating and sharing Microsoft Excel templates. Even though I am calling them ‘templates’, they are just Excel documents (.xlsx) that you can download and use for your purpose with your own data. They are built with the following in mind:
  • Ease of use:
    • My solutions do not require expertise in Excel. They are built with Excel beginners in mind. I take steps during template creation to eliminate occurrence of errors due to wrong data entry. I also provide actionable error messages where appropriate.
  • Practical functionality
    • The template should actually be useful for the user in a real-life scenario.
  • Clear instructions
    • I provide detailed blog posts and video tutorials about the features of the templates and how to use them.
  • Support
    • I listen to user feedback and improve the templates in order to make them useful for as many as possible.
The templates help with:
  • Making smarter decisions
  • Automating recurring tasks and saving time
  • Eliminating manual errors
  • Assisting in information management and retrieval
So far, I have created Excel templates for Small Businessesproject management, HRfinance management, calendars, Data Visualization and School. I hope you find this site useful. If you like it, please share with others. If you have any feedback, please e-mail me (indzara@gmail.com)  or post your comments here.
Thanks for your support.

101 thoughts on “About

  1. Resource Capacity Planner :
    The formula isn’t taking into account the start date put in the ‘Capacity’ sheet, its only taking the project start date in the ‘Settings’ sheet.
    The problem that I am facing is, a Resource with a particular skill is working on 2 projects simultaneously, and after a period of time will be working only one project.

    Example: Resource 1 is working on Project A for 6 hours from 10th May – 21st May and on Project B for 2 hours from 10th May – 21st May, after which(assuming May 24th) the resource will be spending 8 hours on Project B till the end of the project. How can one input data for the same? As of now its aggregating 16 hours everyday from the 10th of May, when I Input another line in the Capacity sheet. Can you kindly help out??
    (P:S – Project time line 1st May – 31st August)


  2. If you want use this in another country that is not US, how can you change it monetary value sign of that country.

    1. Select the all the cells required to change the currency format and press CTRL + 1. Check the below link for more details:


      Best wishes.

  3. What if the capacity of my resources is greater than 100? Currently I have more than 200 resources, do the files still work well? Also, can I use the collection of templates on Google Excel, I know you mentioned about Onedrive, but not sure about Google Excel. Another question just came into mind: I wanted to buy “Project Management Toolkit Excel Templates”, but I have this concern…for example, I want my employees to submit a day-off request via Google form. And I want that information to be automatically reflected on related files, such as Project planners,… can I do that or can you add that?

    1. Thank you for showing interest in our template.

      Currently following three templates in Project Management tool kits has resource limitation. But sorry to say non of them support more than 200 resource limit.

      Project Manager – Max 30 on Purchase / On Request we can provide 60 resource limitation file post purchasing the template.
      Project Planner (Advanced) – Max 30 on Purchase / On Request we can provide 60 resource limitation file post purchasing the template.
      Resource Capacity Planner – Max 100 on purchase/On request we can provide 200 resource limitation file post purchasing the template.

      Regarding Google sheet:

      The excel templates cannot be used in google sheet, since some of the features in Excel is not available in Google sheet. And currently our excel templates are not linked with other templates, hence leave records has to be entered separately in each sheet.

      Best wishes.

  4. Hi there,
    Do you have any templates such as the inventory tracker (below link) that can be used with a Shopify platform??



    1. Thanks for your message.

      Please review our templates for small businesses at https://indzara.com/small-business-excel-templates/

      Best wishes

  5. It looks like your Paypal payment processing is down. I am not able to purchase one of your templates. Please advise.

    1. Thanks for your interest. Apology for any inconvenience. Can you please clarify what error message you see? The payment processor appears to be working.
      Please let us know.
      Thanks & best wishes.

  6. Dear Sir

    I am Kali Chavan And I am Using Your Excel Format Of Inventory And Sales Management But Now Its Not Working Properly
    Whenever I Click On Manufacturing Business Or Rental Or Retail Business It Will Automatically Opens The Home Page Of
    Indzara website. Kindly Give Me The Solution For These

    Kindly Reply My Comment As Soon As Possible.

    Thanks And Regards

    1. Thanks for using our template.

      Please share your file along with the list of issues to contact@indzara.com

      Best wishes

  7. Just wanted to let you know how great full I am for these templates, I appreciate you sharing this with all of us to help.

    1. Thanks!!!

  8. Hello,
    I need a template for calculating employee Overtime in Factory.

    1. Thanks for your message.

      Please review our Employee Timesheet 2020 – Excel Timecard & Work Hours Calculator at https://indzara.com/2018/09/timesheet-template-excel/

      Best wishes

  9. Hello there,

    My calendar will have hundreds of all-day events per year and many overlap. I’m hoping your product will show accurate event-color-codes when all 12 months are on a single page.

    So: Will a day that has multiple (all-day) event types show ALL the relevant color bands for that day in the 12-month view?

    1. Thanks for your interest. In 12-month view, only one color is shown for each day. We can control which color would show up, but it is limited to one per day.
      Please let me know if any questions.
      Best wishes.

  10. Hi There,

    I have seen your marvelous work. One quick query I Have regarding your Employee leave tracker.

    Can I get 1 more sheet added to the tracker which has a whole year view instead of Monthly view in the team dashboard?

    Please let me know if this is doable.

    Thanks & keep up the amazing work.



    1. Thanks for your feedback. Glad to hear that the template is useful.
      Currently only the employee report is annual. Team dashboard is only for a month. A lot of formulas should be modified to convert that to annual. Sorry about that.
      Best wishes.

Leave a Reply

Your email address will not be published. Required fields are marked *