Blog

Employee Leave Manager – Step by Step User Guide

This article will walk you through how to use the Employee Leave Manager Excel Template. If you are new to Excel templates, please visit the Support Page where there is important information that you should know about using Excel templates. Overview of Steps ENTER ONE-TIME SETTINGS Enter Leave Types (up to 12) Choose Weekend Enter [...]

Employee Leave Manager Excel Template – Step by Step User Guide & FAQs

Thanks for visiting the support page for Employee Leave Manager Excel Template which can help simplify leave tracking in your organization. The following are the support articles to help you get started with using the template. If there are any questions not addressed here, please drop a comment and I will add article/video demo about that [...]

2014 Indian Lok Sabha Elections Results in Excel

It is election season now, with results of 2019 Lok Sabha Elections in India to be announced in a few days on 23rd May 2019. I wanted to develop a simple template in Excel that can allow us to view 2009 and 2014 Election results, and gain insights through simple data visualization techniques. Download this […]

2019 Excel Calendar Template – 19 Calendar Designs – Free Download

Download this new 2019 Excel Calendar Template and create your own personalized calendars in Excel. The calendar template can be used to create calendars for any year.  You can choose from 19 different calendar designs, including annual (yearly), monthly, weekly and daily calendars. All in one file, free to download. Topics in this post (2019 Calendar [...]

Ask Your Excel Question – New Video Series – How to create drop down list in Excel

Welcome to a new series ‘Ask Your Excel Question’. In this series, I provide solutions (with video demos) to questions that I receive from our community. These videos will be short and to the point, addressing a specific feature or concept or a formula. If you would like to be notified of these videos, please [...]

Employee Timesheet Template – Excel Time card & Work Hours Calculator

If you are looking for a simple and effective Timesheet template or Time Card template, you have reached the right place. In this blog post, I will present a free time sheet template in Excel and explain step by step how we can use it to calculate hours worked. You can enter time card entries […]

Kerala Heat Map by District – Free Excel Template for Data Visualisation

In this blog post, we will discuss the Kerala State Heat Map by District Excel template. This is a free Excel template that you can use to create heat maps instantly. You will learn how you can enter your own data in the template to create heat maps. You will also learn the features and [...]

Resource Capacity Planner Excel Template – Step by Step User Guide

In this blog post, we will see step by step how we can use the Resource Capacity Planner Excel template. We will take a simple example planning scenario and see how the template can help us in smarter planning. The Resource Capacity Planner template is designed to determine the available resource capacity, compare with demand and [...]

Recruitment Manager Excel Template – Most Frequently Asked Question

In this blog post, we will cover the most frequently asked question about Recruitment Manager Excel template. To learn more about the template's features, please visit the product page. To learn how to use the template, please visit the support page. Before we begin, we are assuming that the template’s formulas have not been edited/modified. [...]

How to extend calendar view in PTO Manager Excel Template

Our Small Business PTO Manager Excel template can be used to calculate and report PTO balances for employees in a company. One of the features of the template is the Calendar which shows the monthly view of PTO taken/scheduled by the employees. By default, this sheet was limited to show 40 employees at a time [...]

World Heat Map by Continent – Free Excel Template for Data Visualisation

World Heat Map by Continents Excel Template is a free Excel template that you can use to create heat maps of the world instantly. You will learn how you can enter your own data in the template to create heat maps. You will also learn the features and options available within the template to customize [...]

How to increase tracking period in PTO Manager Excel Template

The Small Business PTO Manager allows tracking PTO accruals and balances for employees. For more about the template – Product Page It is designed such that we can continue to use the same file for many years. By default, the tracking period is set to 2 years. This was set so that the file size [...]

More uses of Geographic Heat Map Excel Templates

We have already published some Geographic Excel heat map templates on indzara.com. The primary purpose of the templates is to visualize data by geographical region. For example, we have country templates (India, United States, Canada, Australia) which allow visualizing data by state in that country. We have state templates (Tamil Nadu) which allow visualizing data [...]

How to add tiers to the Tenure table in PTO Manager

In this blog post, we will discuss the simple 4 step process to add tenure tiers to the Small Business PTO Manager Excel Template. Small Business PTO Manager Template is a solution to manage employees' PTO data in Small Businesses In the PTO Manager template, we can set the PTO accrual to be based on a [...]

Tamil Nadu Heat Map by District – Free Excel Template for Data Visualisation

In this blog post, we will discuss the Tamil Nadu State Heat Map by District Excel template. This is a free Excel template that you can use to create heat maps instantly. You will learn how you can enter your own data in the template to create heat maps. You will also learn the features [...]

How to extend limits (tasks, time periods) in Gantt Chart Maker?

Our Gantt Chart Maker Excel Template allows creation of instant customized Gantt charts with a variety of options and features. Gantt Chart Maker Excel Template   In order to keep the template file very light and fast, we establish some limits on the scope. For example, the template handles up to 100 tasks, as the [...]

Free Course on Excel Charting – Closes on Apr 21st

One of the commonly used methods of data visualization in Excel is a Chart. Excel offers many types of Charts and they can be harder to understand initially.  This is why I am so excited to share with you a resource to get you started with Excel Charts. My friend Chandeep who runs the website [...]

Team Vacation Planner Excel Template – Support

This article will present step by step instructions on how to use the Team Vacation Planner Excel template.   Purpose The template is designed to help calculate number of employees available on any day and compare with number of employees needed on that day in the company. This will help us identify if there are any [...]

Retail Inventory Tracker – Free Inventory (Stock) Management template

I am glad to present a simple and effective way to manage orders and inventory for your retail business. If you are getting started with a retail business where you plan to buy products from your suppliers and then sell them to customers with a margin, then you would need a tool to track your […]

Sales Pipeline Tracker Template – Track sales leads in Excel – Free Download

Whether you are a small business owner looking for a tool to manage the data on your sales leads, or a sales person needing a simple CRM software, you have come to the right place. I am glad to present a simple Sales Pipeline Management tool to track and manage your sales leads.

Excel Calendar Template – 17 Calendar Designs in Excel – Free Download

I am very pleased to present the new Excel Calendar template. Download this new Calendar Excel template and create your own personalized calendars in Excel. In this post, we will be discussing the following. Features of the Calendar template Link to download template for free Instructions to use the template 17 Calendar designs Tips to further [...]

Small Business PTO Manager – User Guide – Step by Step Tutorial

In this article, we will go through the steps involved in using the PTO Manager Excel template. To learn more about the features of the template, please visit the Product page. This article is part of a series of support articles for PTO Manager Excel Template. For more support, please visit the Support Page.   Overview of Steps [...]

Small Business PTO Manager Excel Template – Support

Thanks for visiting the support page for PTO Manager Excel Template. The following are the support articles to help you get started with using the template. If there are any questions not addressed here, please drop a comment and I will add article/video demo about that topic.   Support Articles 3 Tips to know before [...]

Employee Vacation Tracker to track leave & attendance – Calendar & Report

Whether you are a HR Manager, a Small Business Owner or a Project Manager who is responsible for tracking leave/vacation/time-off taken by employees, you will find this simple and effective vacation tracker template useful. This leave tracker Excel template enables vacation tracking in an organized way, calculates employee attendance, presents a calendar view of leave […]

2016 U.S. Presidential Election Tracker – Excel Template

It's election day in the U.S. and almost everyone is interested in knowing the results. Surveys say that more than 80% of U.S. voters are not pleased with the campaigns so far. My opinion about politics continues to go lower and lower with every election cycle (India & U.S.). No, this post is not about [...]

Sales Report Excel Template – Top 10 & Bottom 10 Products by Sales

This Sales Report Excel template is designed to help identify the best and worst performing products easily. Enter your sales data and instantly identify the top selling products. Compare Week over Week, Month over Month and Year over Year. If you are a business owner, you can find which products are selling the most (Top [...]

Reporting on Rental Business Performance – Monthly Metrics, Top Products & Top Customers

Reporting in Rental Business Manager Excel template is fully automated and very extensive. We have reporting to help us get an accurate view of business performance in multiple areas (inventory, sales & finance) from multiple dimensions (product and Customer). Reporting is available on inventory levels, accounts receivable, monthly metrics, top and bottom performing  product and [...]

Accounting and Finance Management in Excel for Rental Businesses

Rental Business Manager template enables simple and effective finance management for rental businesses. We have options to enter taxes and discounts. We can track payments made by customers on orders. In addition, we can also record operational business expenses. In this article, we will see these features in more detail.   This article is part of a series [...]

How to create and print invoice for rental orders in Excel?

Creating invoices for rental orders using the Rental Business Manager is very easy.  In this article, we will see how we can create them on-demand and then print or export to PDF.   This article is part of a series of support articles of Rental Business Manager Excel template. For more information on the product, [...]

How to use Rental Availability Calendar for your rental business?

Let's learn how to use rental availability calendar to track available assets in our rental business.   This article is part of a series of support articles of Rental Business Manager Excel template. For more information on the product, please visit Rental Business Manager Excel template.   As we keep entering multiple orders (how to [...]

How to Enter Rental Orders in Rental Business Manager Excel Template?

In this article, we will see how we can enter rental orders in the template. If you have any questions, please leave a comment below.   This article is part of a series of support articles of Rental Business Manager Excel template. For more information on the product, please visit Rental Business Manager Excel template. [...]

Getting Started with Rental Business Manager Excel Template – Initial Setup

In this post, we will see how we can do the initial set up for the template to customize it for our rental business.   This article is part of a series of support articles of Rental Business Manager Excel template. For more information on the product, please visit Rental Business Manager Excel template.   [...]

Free Upgrade for Employee PTO Calculator & Vacation Tracker

I am very glad to announce that an upgraded version of Employee PTO Calculator is now available. There were several requests from users for new features to make the template meet the requirements of businesses. I am pleased to say that I have incorporated those requests in this new version. PTO Calculator and Vacation Tracker - Excel [...]

Social Media Dashboard – Free Excel Template to report social media metrics

Social Media Dashboard (Excel Template) is designed to consolidate metrics across multiple Social networks such as Facebook, Twitter and YouTube and present in a single-page dashboard. If you are trying to create a monthly view of business impact of content posted across all the social networks by your business, then download this free template to create an instant [...]

Group Shared Expense Calculator – Free Travel Expense Sharing Template

This Group Shared Expense Calculator template can be used to calculate each person's share of expenses in a group. For example, when you go on a trip with your friends where multiple people pay for shared expenses. At the end of the trip, you would need to calculate how much each person owes and to whom. Another [...]

2016 Olympics Dashboard – Explore Rio Olympics data in Excel

The purpose of this 2016 Olympics Dashboard is to create an interactive tool to access and explore results of the recently concluded Rio Olympics (link to Wikipedia).   This was the first Olympics that I watched with my son and so it’s very special to me. 🙂   Another important objective is to openly share the [...]

Free Excel Inventory Template for Manufacturing Businesses

This free inventory tracker template is designed for small businesses which manufacture or assemble products from raw materials. You can use this to automatically calculate the current raw material stock as well as determining how many units of each product you can make using the raw materials available. We can input simple Bill of Materials (BOM) where [...]

Free Inventory Management Excel template from ExcelChamps

I am very glad to share a new inventory management template that my friend Puneet from ExcelChamps has published. If you are interested in a very simple-to-use template that uses forms to enter your stock in and stock out, you will find this one very useful. The Dashboard calculates the current inventory level and value automatically. The template [...]

Thank you for the support – Milestone: 200th Video on YouTube

I am happy to announce that I have published the 200th video on indzara.com's YouTube channel. Thank you for the support. 200th Video   I thought of giving an update on indzara.com, as we have reached this milestone.   We have reached 200 videos on YouTube. 100+ are just about Excel templates. 90 of them are [...]

Free Excel Inventory Template for Rental Businesses

If you are a business owner of a rental business where you rent equipment or assets to your customers, you will find this template handy in tracking inventory. This Excel rental inventory management template can help you know how many items are in stock and how many have been rented out. In addition to knowing [...]

Invoice Tracker Template for Small Businesses – Free Download

For small businesses, keeping track of the sales invoices and payments made by customers is a critical task. Use this Invoice Tracker template to keep track of all your sales invoices in one place. You can enter payments made by customers and let the template calculate balance outstanding amounts. Never miss an unpaid invoice. Download [...]

Free Excel Invoice Template – Create Invoices for Small Businesses

If you run a small business selling products, download this Free Sales Invoice Template and create invoices easily in Excel. You can create unlimited invoices and manage them all in one file. You can save time by storing your products and customers once and re-using them for invoices whenever needed. Sales Invoice Excel Template - Free Download [...]

Small Business Product Catalog in Excel – Free Template

Have you wondered if it would be handy to have a product catalog for your small business? Did you know that we can create the entire online product catalog or online store experience within Excel? Without payment processing, of course 🙂  You could use this to share your product info with your prospects and customers in an interactive [...]

User Guide: How to enter data in Recruitment Manager Template?

In this article, we will discuss step by step how to use the Recruitment Manager Excel Template.   DESIGN The template focuses on two key pieces of input information – Jobs and Applications, entered in Jobs and Application sheets respectively. There are two key output sheets. The Dashboard presents a single page summary of Recruiting metrics, [...]

Recruitment Manager Excel Template V2 – Support Page

Thanks for visiting the support page for Recruitment Manager Excel Template which can help simplify your recruitment process tracking. The following are the support articles to help you get started with using the template. If there are any questions not addressed here, please drop a comment and I will add article/video demo about that topic. Support [...]

Enhancements in Recruitment Manager Excel Template V2

As with other templates, we continue to improve our products based on customer feedback. I am glad to announce that the V2 of the Recruitment Manager Excel Template is available now. Recruitment Manager Excel Template v2   The following are the key enhancements in this version. Supports 6 recruitment stages now (compared to 5) Handles multiple [...]

New Employee Checklist – Free Excel Template

This Excel template is designed to document completion of activities in a checklist. HR departments in companies can use this to track or document new employee on-boarding activities. Typically, there is a list of activities that each employee has to complete to 'on-board' to the new company. We can use this one file to track such on-boarding [...]

Project Pipeline Tracker – Free Excel Template

PURPOSE This Excel template allows tracking projects and calculating effectiveness in completing them. This is applicable for scenarios where all the projects go through the same set of pre-defined stages in sequence. In a simple example, each building project may have three stages: Plan - Design - Build. Once planning is completed, designing begins and after designing is completed, build begins. We [...]

Reporting in Retail Business Manager

In this article, we will cover the reporting available in the Retail Business Manager Excel Template. Retail Business Manager Excel Template - Product Page     Support Page We have extensive reporting automatically generated, to help us get an accurate view of business performance in multiple areas (inventory, sales & finance) from multiple dimensions (product [...]

Finance Management in Retail Business Manager

In this article, we will review topics related to finance management in the Retail Business Manager Excel Template. Retail Business Manager Excel Template - Product Page     Support Page   VIDEO DEMO   Order Related Costs When we enter the order line items in the Order Details sheet, we are entering the purchase costs [...]

Viewing and Printing Invoice and Purchase Orders

Let's learn how to view and print invoice and purchase orders in the Retail Business Manager Excel Template. Retail Business Manager Excel Template - Product Page        Support Page   VIDEO DEMO   View Invoice To view the invoice, let’s go to Invoice sheet and enter the order number at the top. If we [...]

Entering Orders in Retail Business Manager

In this article, we will see the different types of orders and how we can enter them in the Retail Business Manager Excel template. Retail Business Manager Excel Template  -  Product Page     Support Page Types of Orders There are 5 types of orders that can be handled by this template. Before we look at [...]

Getting Started (Initial Setup) – Retail Business Manager

In this article, we will discuss how we can do the initial setup of our Retail Business Manager Excel template. Retail Business Manager Excel Template - Product Page   Support Page One of the important features of our templates is that they are simple to learn and use. We can complete the initial setup in just [...]

Retail Business Manager – Excel Template – Support

Welcome to the support page for Retail Business Manager Excel Template. The following articles will provide information on how to use the template. Please follow the links provided to read more about each topic.   If you prefer to watch video demonstrations, instead of reading articles, please watch this playlist. https://www.youtube.com/playlist?list=PLPA6EhiqturQd8POz8G3gJdPCbbk5z32o   Before We get Started 3 [...]

Gantt Charts in Project Manager Excel Template

In this article, we will cover the options and features available in the Gantt Charts in Project Manager Excel Template. Gantt Chart is a commonly used visualization method to display project timelines. Project Manager template allows planning and managing a project from start to finish. It includes a GANTT sheet which builds automatic Gantt charts. It [...]

Design your own Calendar Layout – Event Calendar Maker

In this article, we will learn how we can create our own calendar layout design. The Event calendar Maker Excel template comes with 7 different layouts (Yearly, Yearly with Events, Monthly, Monthly with Events, One Month, Weekly and Daily). However, if we need to have any other layout, we can do that easily using Excel's [...]

Automatic Scheduling in Project Management

Our previous article on Project Management Framework had set the background for how a ‘Schedule’ forms the foundation for all calculations in Project Management. One of the huge highlights in our Project Management templates (Example: Project Manager Excel Template) is the ‘Automatic Scheduling Engine’ which, as the name suggests, automates the schedule creation step and [...]

Project Management Framework

In this article, we will discuss the Project Management Framework that we apply in the Project Management Excel Templates available from indzara.com. Projects can be of different types and Project management techniques also vary with the type of projects. The simplified framework we will see now applies to most common project scenarios.   PROJECT MANAGEMENT [...]

XLYOURFINANCES – Review

I came across this Excel workbook from Brad Hoffer (XLYourFinances), which will make finance management easier & I wanted to share it. XLYourFinances In Brad's words, "Xlyourfinances is an automated Excel spreadsheet that will give you control over your finances and save you time in the process. With import tools, auto-categorization and unlimited years of [...]

Project Management Toolkit – Excel Templates – Support

This is the support page for the Project Management Toolkit - Excel Templates. Project Management Toolkit - Excel Templates This product is a bundle of 6 individual Excel Templates. The following are links to those individual templates and their support pages. Please visit them for help material around each of them. If you have questions about [...]

Terms used in Project Manager Excel Template

The Project Manager Excel template uses the following terms. This list is also provided in the template itself. The list includes user input fields and calculated ones. The calculated ones are shown in green font below. Click to know more about the features in the template   TASKS TASK ID Unique Task ID (Required) TASK NAME Task [...]

Project Manager Excel Template – User Guide

In this article, we will cover the overview of how to use the Project Manager Excel Template. Then, we will use a simple project to illustrate how to use the template. SIMPLE OVERVIEW OF INSTRUCTIONS PLANNING Enter basic inputs in SETTINGS Enter task details in TASKS Review Baseline Plan summary in PROJECT_REPORT Take action to [...]

Project Manager Excel Template – Support Page

This page will host support material for Project Manager Excel Template. To read about the template's highlights and purchase, please visit Project Manager Excel Template. If there are questions about the product, please leave them in the comments section below.   SUPPORT ARTICLES Fundamentals Project Management Framework Automatic Scheduling - What is it and why [...]

How to edit colors by data range in U.S. State Heat Map Excel Template?

In the previous article, we learnt how to change the gradient colors used in the U.S. Geographic State Heat Map Excel Template. In this article, we will edit the colors used in the 'Colors by Data Range' option in the same template. Please visit product page to understand the features of the U.S. Geographic State [...]

How to change Gradient colors in U.S. State Heat Map Excel Template?

In this article, we will learn how to change the gradient colors used in the U.S. Geographic State Heat Map Excel Template. Using the template, you can create a geographic heat map at the state level for 50 states of U.S using your own data. Please visit the product page to understand the features of [...]

Earned Value Management – Free Excel Template

Earned Value Management (EVM) is a technique (Wikipedia) used in project management to measure progress of a project with respect to cost. In this article, we will cover the basics of EVM, why it is useful and also a free Excel template which will help calculate the metrics for us.   Why EVM? Let’s take [...]

How to do Monthly Team Capacity (Hours) Planning? – Case Study

In this article, we will be taking up monthly capacity planning for a team. SCENARIO We are responsible for planning our team’s capacity every month. We need to have a realistic view of how much work can be done by our team next month, taking into account the availability of each of our team members [...]

How to filter events to display on calendars?

In this article, I will explain how we can filter events in calendars using our Event Calendar Maker Excel Template. The template allows creating customized event calendars easily with 7 different designs automatically created based on your input event data. Sometimes, when you print or export those calendars, you may want to display only certain event [...]

Resource Capacity Planner – Excel Template – Support

This page will host supporting information for the Resource Capacity Planner Excel Template which can be used to plan resource capacity, compare versus demand and identify over-utilization and under-utilization. To know the features of this template, please visit the product page. The latest version (v2) was published in July 2018. The following are the support articles [...]

How to implement predecessor tasks in Gantt Charts?

While building project plans, you will most often have dependencies between tasks. For example, Task 3 cannot begin until Task 2 is complete. In that scenario, Task 2 is called the predecessor to Task 3. In our Project Planner (Advanced) Excel Template, a task can have up to 2 predecessors. The template will then automatically [...]

How to skip non-business days for recurring tasks?

When you have recurring tasks and one of the instances/occurrences happens to fall on a holiday, you may like to skip that occurrence. You may want to remove just that one occurrence and keep all the others. You can do that easily in our Task Manager (Advanced) Excel Template.  This article explains how to do that with [...]

5 reasons why events are not displayed on Calendar

In this article, we will cover the reasons why your events may not be displayed on the calendars in our Event Calendar Maker Excel Template. You may enter some events data in the 'Events' sheet, then go over to the Calendar design sheets and be disappointed not to see those events displayed on the calendars. Let's [...]

How to use Custom Columns in Task Manager (Excel Template)?

This article will demonstrate how we can leverage the custom columns available in the Task Manager (Advanced) Excel Template. Though I use this specific template in this article, the concepts apply to other templates on indzara.com, where custom columns are used. To begin with, what are 'Custom Columns'? I use this phrase to indicate columns [...]

How to prioritize events on multi-event days?

In this article, we will see how we can control the order in which events appear on days that have multiple events. We will be using the Event Calendar Maker Excel template. You can watch this video or follow the instructions in text further below.   First, in the Home sheet, let's create three event types and assign [...]

Product Rating Report (5 Star Ratings) – Free Excel Template

As I was compiling the summary of product ratings I received for indzara.com products, I built a simple template to help me. I wanted to share it so that others can also use and benefit from it. If you have any suggestions to improve the template and make it useful for more people, please post them in [...]

How to create U.S. holidays on Calendar?

In this video, I create official U.S. holidays on calendar using our Event Calendar Maker Excel template. It is to illustrate the functionality of the template where creating events such as 3rd Monday of a month and last Monday of a month is simple and easy. Watch the video to learn how you can also create [...]

Thank you!

As 2015 comes to an end, I would like to take the opportunity to say Thanks. Thanks to all of you for your support to indzara.com. It has been an eventful year. This site was launched with the store in mid-Jan 2015 and all the blog content (indzara.blogspot.com) were migrated over here. I left my job in September to [...]

How to create annual events on Calendar?

It is very easy to create annual events such as Birthdays or Anniversaries, using our Event Calendar Maker Template. In the video below, I explain how to create such events and then re-use the same template year after year. There are multiple ways to create the desired effect. I create events that occur every 12 [...]

How to create Payroll Calendars using Event Calendar Maker?

In this short video, I explain how easy it is to create Payroll calendars using our Event Calendar Maker Excel Template.     For more support information on this Excel template, please visit the product support page. Thank you.

How to Skip Non-Business Days while creating recurring events?

In this short video, we take a look at how we can skip (or exclude) non-business days (weekends or holidays) while creating recurring events. We use the Excel Calendar Maker template in this demo.     For more support information on this Excel template, please visit the product support page. Thank you.

Announcing v2 of Task Manager (Advanced) Excel Template

Merry Christmas and Happy Holidays to Everyone. I am very glad to announce that v2 of Task Manager (Advanced) Excel Template  is now available. As always, existing customers get the upgrade for free. An email will be sent along with the new file. Thanks for your feedback. New users can purchase the template from the product page. [...]

How to add Event Location and Time to Calendar

The following video demonstrates how to add Location and Time to calendars using Event Calendar Maker Excel Template. We will be using the Event Name field to store other information such as location and time so that they get displayed on the Yearly, Monthly and Weekly calendar designs.    

Announcing Event Calendar Maker Upgrade

I am glad to announce that Event Calendar Maker has been upgraded. The new version (v3) has several additional features based on requests from customers. Most frequently requested features have been added.  As always, existing customers get the upgrade for free. I will be sending an email today with the file to everyone. The product [...]

Event Calendar Maker Excel Template – v3 – Support

This post will contain information related to the support of Event Calendar Maker Excel Template v3. v3 was published in December 2015. Please read further below for the list of articles.   5 reasons why events are not displayed on calendar How to add event location and time to calendar? How to skip non-business days [...]

Gantt Chart Maker Excel Template – Support

Support information related to Gantt Chart Maker Excel Template will be posted here. Please post any of your questions on this product in the comments below. I will respond as soon as I can. Thank you,   BROCHURE Download Gantt Chart Maker brochure   VIDEO DEMO   SUPPORT ARTICLES How to implement predecessors in Gantt [...]

How to handle projected delays in projects – Advanced Scenario

While planning for projects, you may come across scenarios where a project is projected to end later than preferred. This articles discusses options to handle such projected delays, in a scenario where tasks have predecessors. In the previous article, I addressed the scenario where predecessors are not involved. The Project Planner (Advanced) Excel template is used for [...]

How to handle projected delays in projects – Simple Scenario

While planning for projects, you may come across scenarios where a project is projected to end later than preferred. This articles discusses options to handle such projected delays, in a simple scenario where tasks do not have predecessors. In my next article, I address the scenario where predecessors are involved. The Project Planner (Advanced) Excel template is used [...]

Recruitment Manager – Excel Template – Support

This is the support page for the V1 of Recruitment Manager Excel Template. A new and improved V2 is available now. Please visit the product page for details and the new Support Page for V2.     SIMPLIFIED DATA ENTRY The template focuses on three key pieces of input information – Jobs, Candidates and Applications. [...]

Activity Pattern Heat Maps – Free Excel Template

This Excel template can be used to visualize activity patterns. Some of the scenarios where you could use this would be visualizing call arrival patterns in call centers, support request arrival patterns in contact/support/service centers, website traffic and order placements. By understanding the arrival patterns, you could make decisions around staffing (in contact/call center example) and [...]

Circular References in Project Planner Excel Template

This article discusses reasons for the ‘Circular Reference’ error that you may come across in the Project Planner (Advanced) Excel Template, and how to avoid them. ‘Circular Reference’ is the concept where one formula depends on its own result as its input.

Recruitment Tracker – Free HR Excel Template for Recruiters

Are you in the process of recruiting for an open job/position? You can use this simple Excel template to track status of the applicants (candidates) in an organized way. You can get an instant view of how many applicants are in the pipeline and where in the funnel applicants are dropping off. You can also easily view [...]

Employee PTO Tracker & Calculator – Free Excel Template

Do you want to easily find out how many days of PTO (Paid Time Off) you have available? Wondering if there is a simple spreadsheet that can be used as vacation tracker and PTO vacation accrual calculator? You have come to the right place - Employee PTO Tracker Excel Template. You can download this free Excel template to [...]

Employee Vacation Planner – Free Excel Template

This Excel Template is designed to help assess coverage of team members' availability during a month. As a Team leader or a Manager of a team, it is important to know the staff coverage available every day, especially during the holiday season. This Excel template can be used every month to ensure that you are aware of exact [...]

Project Planner (Advanced) Excel Template – Expanding Number of Projects/Tasks

This post is a tutorial on how to increase the number of projects and tasks that the Project Planner (Advanced) Excel Template - v2 can handle. To increase the number of tasks, please do the following. Unhide a sheet named Scheduler   Project Planner (Advanced) Excel Template - Unhiding Scheduler   Go to cell OC253. You [...]

Project Planner (Advanced) Excel Template – v2 – Enhancements

This post presents the key features that were added to the v2 of the Project Planner (Advanced) Excel template. Thanks to the hundreds of customers who have purchased the v1 and a special thanks to those who have taken the time to provide feedback on the template. As always, the current customers will get the upgraded [...]

Project Planner (Advanced) – Excel Template – v2 – Support

Welcome to the support page for Project Planner (Advanced) template v2. This page will contain instructions on how to use the template and other relevant links. Links Product Page v2 - Enhancements made in v2 v2 - How to expand the number of Projects and Tasks v2 - Circular Reference Errors - Reasons and Remedies v2 - [...]

Manufacturing Inventory & Sales Manager Excel Template – Migrating from v1 to v2 in 10 mins

This post explains how to migrate data from v1 of Manufacturing Inventory and Sales Manager Excel Template (Product page) to v2.  Please read about the Enhancements in v2 You can migrate your data from v1 file to the new v2 file in less than 10 minutes. Please watch the video below where I demonstrate how to […]

Upgrades to Manufacturing Inventory and Sales Manager Excel Template

I am glad to announce that the Manufacturing Inventory and Sales Manager Excel Template has been upgraded from v1 to v2.  Customers who have already purchased receive the v2 for free. Please create an account with indzara.com and you can log in to access all your files anytime. If you would like to continue using […]

Manufacturing Inventory and Sales Manager v1 – Excel Template – ARCHIVED

The v1 of the Manufacturing Inventory and Sales Manager was retired in July 2015.  Latest version is Manufacturing Inventory and Sales Manager Excel Template v2 (released in July 2015). This post contains information related to v1. If you are still using v1, please see below for help.   ABOUT THE EXCEL TEMPLATE This Excel template helps […]

Rental Business Manager – Inventory and Sales – Excel Template – Support

This page will provide the support information for the Rental Business Manager Excel Template. You will find links to articles and video tutorials on how to use the template. I am continuing to add material to this page. Please post any questions in the comments section below. I will be happy to answer. The second version of this template [...]

Announcing Manufacturing Inventory Manager – Excel Template

Friends, I am glad to announce that I have published a new Excel template. The Retail Inventory and Sales Manager is the most popular premium Excel template at indzara.com. It is applicable to retail businesses, but not for manufacturing type of businesses.   The new Manufacturing Inventory and Sales Manager Excel template can be used in […]

Manufacturing – Inventory and Sales Manager – Excel Template Support

This is the Support page for the Manufacturing – Inventory and Sales Manager – Excel Template. Please post any questions related to this template in the comments below. Product Page: Manufacturing – Inventory and Sales Manager – Excel Template Version History: v2 published July 24, 2015 v1 published Apr 25, 2015 Useful Links: How to […]

Inventory Management Excel Template – Migrating data

This post demonstrates how to migrate data from the free Inventory and Sales Management Excel template to the premium version. It should take less than 10 minutes to migrate and get all the additional benefits of the premium Excel template. The following video demonstrates the process and the steps are also explained in the post below. [...]

Cricket World Cup 2015 – Free Excel Dashboard

Cricket World Cup 2015 Excel Dashboard is my attempt to capture the world cup in Excel. Though the team I support (India) came close but didn't win, Australia deserved to win. I have attempted to calculate all the stats based on raw match data (thanks to ESPNCricinfo). I have tried to keep it really simple [...]

Buy One, Post Review and Get One Free Template

I am glad to announce a special offer for our customers. Buy one product and get equal value for free by simply posting your honest review. Buy One Post Review Get One Free   For example, if you pay $25 for a product and post a review using steps outlined below, you will receive a [...]

Personal Finance Manager – Excel Template v2

Hello Everyone, I am glad to announce that the Personal Finance Manager template has been upgraded with the following key enhancements. The files are available for download in the same page. Increased number of accounts – Now can handle 20 bank accounts, 20 credit card accounts and 20 cash accounts. Increased number of categories and […]

Free Excel Course – Exercise Files available now

57 exercise files associated with the free Excel Course ‘Useful Excel for Beginners‘ have been uploaded. They are available as one zipped file (3.4 MB) to download. You can use these files to follow along the course which is an on-demand video based course. The entire course is available for free. Please visit the course page […]

Project Manager – Excel Template – Support

PLEASE VISIT PROJECT MANAGER EXCEL TEMPLATE FOR THE CURRENT VERSION. PURPOSE This Excel template can be used to plan and manage a project. The template saves time by auto-scheduling of tasks. It provides smart visual feedback (example: identifying tasks that will not complete) and thus helping to tweak the project plan and improve. Actual work [...]

Welcome

Welcome to indzara.com. The site has been launched with the essential content. The content from the blog at www.indzara.blogspot.com has been moved over here. It is exciting to have all the content on own domain. The payment process has also been improved. The site will continue to be improved. If you find any bugs, please […]

Australia – Geographic State Heat Map – Excel Template

This is a simple Excel template using which you can create instant heat maps for Australia using state level data.  REQUIREMENT:  Microsoft Excel  Compatible versions:  Microsoft Excel for Windows (2007, 2010 and 2013) Microsoft Excel for Mac (2011) FEATURES Instant heat maps in Excel for 6 states and 2 territories of Australia Easy to print […]

Event Calendar Maker v2 Features

Update: New version was launched in Nov 2014 ———————————————————- The next version of the Event Calendar Maker will be out soon. The customers who have purchased the first version will receive the upgrade for free. Based on the feedback received from customers, the following are the features being considered for the next version of Event Calendar Maker.  Add […]

Task Manager (Advanced) – Excel Template – Support

This page will host support material for the Task Manager (Advanced) Excel template. Click to view Product Page This Excel template is designed to help create and update status of tasks easily. This can be used by project managers who handle multiple tasks and manage multiple team members. This can also be used by individuals [...]

Project Planner (Advanced) – Excel Template – v1 – Support

This is the support Page for Project Planner (Advanced) Excel template v1. A new version of Project Planner is now available. -------------------------------------------------------------------------- Plan your projects quickly with the new Project Planner (Advanced) v1 template. The template can help you to Determine if and when projects will complete given each project's tasks, task duration, resource assignment [...]

Geographic Heat Map (India) – Updated with Telangana

A new state of Telangana has been created earlier this month. Our Geographic Heat Map (India) has been updated with the new state. Please visit the page to download the updated file. 

Retail Inventory and Sales Manager – Excel Template – Support

The Retail Inventory and Sales Manager is suited for managing inventory and sales if you are running a business of buying products from suppliers and selling to customers. This Excel document will assist in knowing the inventory levels of each product and understanding which products to re-order. You can also create invoices instantly and print or […]

U.S. Geographic State Heat Map – Excel Template – Support

Welcome to the support page for the U.S. Geographic State Heat Map Excel template. You can create a geographic heat map at the state level for 50 states of U.S using your own data. REQUIREMENTS You need a copy of Microsoft Excel to open this file. The product has been tested in Microsoft Excel 2007 and [...]

Event Calendar Maker – Excel Template – v2 – Support

This is the support page for the Event Calendar Maker Excel template. It is an Excel workbook (.xlsx) that you can use to create your own personalized event calendar.  v2 released in Nov 2014   REQUIREMENTS   You need a copy of Microsoft Excel to open this file. Event Calendar Maker has been tested in  [...]

All-Purpose Calendar Maker now for Excel 2007

I wish everyone a happy and peaceful 2014.  I am glad to inform that the All-Purpose Calendar Maker is now compatible with Excel 2007. Please visit the page and download the latest version which works in Excel 2007, Excel 2010 and Excel 2013 for Windows. The new file replaces the older file. All the features have […]

Useful Excel for Beginners – Course

If you are interested in learning Microsoft Excel, you can try my course ‘Useful Excel for Beginners’. This course has been developed with beginners in mind. If you have never used Excel before or if you are a beginner level user, you will find the course useful.  The course includes 89 videos running for 9.5 […]

Invoice Builder (Basic) – Free Excel Template

This is a simple template that helps in creating invoices for businesses. If you are running a small business, you will have the need to create invoices. However, you don’t need a sophisticated and expensive software. If your requirements are specific and simple, this template may help.  Update (July 2016):  A new and improved version [...]

Inventory and Sales Manager – v2 (for 2000 products)

Several of you have left comments or e-mailed me asking for the Inventory and Sales Manager template to support more than 100 products. I have posted a new version (v2) of the template that will allow 2000 products. All the other features remain the same. Please visit the original post to download the new version. […]

Changing the Colour Gradient in the Heat map

I have received requests around how to change the colour gradient for the Geographic Heat Map (India) Excel template. In this quick tutorial, I will explain how to do it.   Step 1: Download and open the Geographic Heat Map (India) Excel Template. The map looks like the image below. Step 2: Open Conditional Formatting [...]

Updates planned for Project Planner (Basic)

I have received multiple requests for expanding the Project Planner (Basic) Excel template. Thanks for the feedback. The following are the enhancements I am planning to make to the template.  Increase planning period (currently set as 60 working days) increase number of projects (currently limited to 25) increase number of resources (currently limited to 15) […]

Inventory and Sales Manager (Free Excel Template) for Small Business

This Inventory and Sales Manager Excel template is suited for managing inventory and sales if you are running a small business of buying products from suppliers and selling to customers. (Retail/Wholesale). This retail inventory excel template will assist in knowing the inventory levels of each product and understanding which products to re-order. Also, you can [...]

Videos: Project Planner (Basic) – Excel Template

One of the first templates that I had published is the Project Planner (Basic) Excel template. Now, I have created a three part video series about the template.   The first part introduces the template and the benefits.     The second video discusses how data is entered in the Projects and Tasks worksheets.     […]

All-Purpose Calendar Maker (Free Excel Template)

I have published a couple of calendar templates earlier. The Custom Calendar (U.S.) works for any year and automatically calculates the U.S. Holidays. The Custom Calendar - 2013 (Tamil) displays the Tamil Nadu Government holidays for 2013. Both templates allowed a lot of flexibility such as starting your week with any day and entering up [...]

School Attendance Register and Report v2 (Free Excel Template)

This template is an upgraded version of the School Attendance Register and Report (Excel template). The enhancements are 1) complete flexibility in choosing weekends and 2) accommodation of entry of late attendance by students. For more advanced features, please see Student Attendance Register Excel Template   PURPOSE To use as an attendance register tool To create [...]

Report Card – Basic (Free Excel Template)

PURPOSE The purpose of this template is to automate creation of student report cards and provide meaningful academic performance information to teachers and instructors, with minimal effort. I believe this would be useful for schools and other educational institutions, conducting tests or assessments for their students. FREE DOWNLOAD Report Card (Basic) Excel Template Report Card [...]

Task Manager Excel Template v2

I have made the following enhancements to the Task Manager Excel Template and the Task Manager v2 is now available.  1) I have added an additional option for Task type. v1 had five choices: One-time, Daily, Weekdays, Weekly and Monthly. v2 has an additional option: Every 4 Wks. This allows you to schedule recurring tasks that repeat […]

Personal Finance Manager (Free Excel Budget template)

EXCEL BUDGET TEMPLATE This is a simple free Excel template that focuses on making it easy for you to know what's happening with your financial situation especially when you have multiple bank accounts, credit card accounts and cash. It also helps you set budgets and see how you are actually doing against your budget. With [...]

School Attendance Register and Report (Excel template)

Update: There is a new enhanced version of this template with 1) complete flexibility in choosing weekends and 2) accommodation of entry of late attendance by students. Please visit School Attendance Register and Report v2 (Excel Template).  PURPOSE To use as an attendance register tool To create class attendance reports To create student attendance reports Can [...]

Geographic heat map – India (Excel template)

I was looking for a way to present/visualize state level data on an Indian map. I was not able to get that from the Bing maps application for Excel. I am sure there are paid applications that might provide this functionality.  I think this is a very basic need and I decided to prepare a [...]

Task Manager (Free Excel template)

The purpose of the Task Manager Excel template is to assist in remembering tasks that need to be done. This checklist template could be used by anyone who needs to keep track of tasks (one-time or recurring) and avoid forgetting them in a busy daily life. To Do List Template - Dashboard    The Task [...]

Quiz Master (Excel template) to conduct quizzes

An Excel template that can be used to conduct quizzes. Customize Questions and Answers easily.  Quiz Template in Excel - Screenshot FREE DOWNLOAD Download Quiz Master Excel template for free   PURPOSE Suited for conducting quiz events at work, school or home Suitable for groups of people forming teams, or individuals (1 to 4) Font [...]

Loan Comparison and EMI Payment Calculator (Excel template)

This is a simple template to help one in decision making on loans. There are two version of this template, one using the Indian Rupees as the currency and the other one without any currency formatting. Both versions function in the exact same way and hence the following information applies to both versions.   DOWNLOAD [...]

Project Planner – Free Excel template for Project Planning

If you are looking for a project management tool or software that can make project planning simpler, you have come to the right place. In this post, you will learn about a simple project planning framework and how to plan your projects smartly. You can download the free Project Plan template and start planning your […]

2013 Tamil Calendar with Tamil dates and Tamil Nadu Holidays (Excel template)

If you are looking for a printable tamil calendar with tamil months and Tamil Nadu government holidays, you may find this post useful . As with the calendars I published earlier, there are two options: Non-customizable PDF calendars and Customizable Excel template. The Excel template lets you add your personal events and then print the […]

Custom Printable Calendars (Excel template)

If you are looking for more features, you can try my Event Calendar Maker. It's that time of the year. Time to change calendars, as we are stepping into another new year. These days, calendars are everywhere. The device you are using to read this post has an in-built calendar  and many  applications you use (for [...]

72 thoughts on “Blog

  1. Amazing, this is a great article! I did enjoyed reading it, keep your post .

    1. Thanks!!!

  2. Thank you for sharing this kind of blog with us.

    1. You are welcome!!!

  3. Hi,
    I Need Inventory Software where I can use Sales order, purchase order, sales invoice, payments, receipts, Stock dispatched thru Delivery Challan, Dispatched details. so can you customize for us.

    1. Hello

      Thanks for sharing your requirements. We have templates for small businesses at https://indzara.com/small-business-excel-templates/

      Best wishes

  4. Hi.
    I would like to tell you that I’m using this site for a long time and you write very god info.

    I shared your latest article on tumblr aand got a llot off positive feedbacks.

    Hope you put new content soon.

    1. Thanks

Leave a Reply

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