Blog

All Purpose Calendar Maker – Free Google Sheet Template

This Google Sheet template is an all purpose calendar Maker template.  It can be used in any scenario (schools, companies, libraries, etc.) and any country (as it does not have any feature that is country specific). It has more flexibility: you can choose the weekend(s) as any day(s) of the week and you get to [...]

School Attendance Register – Free Google Sheet Template

This template is a simple version of the Student Attendance Register and Report. The highlights are 1) complete flexibility in choosing weekends and 2) accommodation of entry of late attendance by students.  This template is designed for Google sheets, but if you are looking for an Excel template, please visit the SchoolAttendance Register and Report [...]

Human Resource Toolkit – Excel Templates – Support

This is the support page for the Human Resources Toolkit – Excel Templates. Our Human Resource Toolkit – Excel Template Page This product is a bundle of 8 individual Excel Templates. The following are links to those individual templates. Please visit them for help material around each of them. If you have questions about the bundle, […]

Employee Retention Dashboard Google Sheet Template – User Guide

In this article, we will explain step by step how to use the Retention Dashboard Google Sheet Template. To learn more about the features of the template and to download, please visit the Product page. OVERVIEW OF STEPS Enter data in Employees Data sheet Refresh Calculations View/Interact with 3 Dashboards STEP 1: ENTER DATA IN [...]

Invoice Manager Google Sheet Template – User Guide

This article provides step by step instructions on how to use the Invoice Manager Google sheet template.   Step by Step Instructions Enter Invoice data in Invoices sheet Invoices Sheet The fields required are Invoice Number: Unique identification of invoices. The Invoice number should not be repeated. You can have any method to come up [...]

Team Vacation Planner Google Sheet Template – Support

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

PTO Balance Calculator (Hourly) – Free Google Sheet Template

A Simple Google Sheet template to help you to track the PTO balances of hourly employees. Download this free Google Sheet template to track and calculate Employee’s PTO accrual balances based on hours worked by the employee.  If you need a PTO Calculator that calculates accrual based on employee tenure, please see PTO Calculator (Salaried [...]

Sales Pipeline Manager Google Sheet Template – User Guide

This article describes step by step how to use the Sales Pipeline Manager Google Sheet Template. For more information on the features of the template, please visit the product page. Overview of steps Enter sales stages in your Sales process. Rename if necessary. Entering a new deal in Deals table Change Currency for Deal Value [...]

PTO Balance Calculator (Salaried) – Free Google Sheet Template

A simple Google Sheet Template that can be used as a vacation tracker and PTO vacation accrual calculator. This Google Sheet template can also be used to track and calculate Employee’s PTO (or leave or vacation) accrual balances. This template is designed for Google sheets, but if you are looking for an Excel template, please [...]

Manufacturing Inventory Tracker – Free Google Sheet Template

This Google Sheet is developed as a solution 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.  This template is designed for Google sheets, but if you are looking for an Excel template, please visit the Manufacturing Inventory [...]

Invoice Tracker – Free Google Sheet Template

This Google Sheet is developed as a solution to keep track of the sales invoices and payments made by customers in one place. You can enter payments made by customers and let the template calculate outstanding balance amounts.  This template is designed for Google sheets, but if you are looking for an Excel template, please [...]

Employee Leave Vacation Tracker – Free Google Sheet Template

Whether you are a HR Manager, a Small Business Owner or a Project Manager it is important to track leave/vacation/time-off taken by employees.  This Google Sheet Template is developed to help people in tracking leave/vacation in an organized way, calculating employee attendance. This Google Sheet Template presents a calendar view of leave across multiple employees [...]

Employee Timesheet – Free Google Sheet Template

If you are an employee, no more wondering ‘How many hours did I work?’ or searching for ‘How to calculate hours worked?’. This timesheet template makes it easy by automating all the calculations. If you are an HR (Human Resources) professional who needs a work hours calculator for the employees in the company or team, [...]

Sales Pipeline Tracker – Free Google Sheet Template

As an owner of a small business, you will need a tool to manage the data on your sales leads. This Google Sheet Template is developed to help you in tracking your sales leads and in managing them.  This Google Sheet Template can be effectively used to track the status of your sales pipeline. You [...]

Rental Inventory Tracker – Free Google Sheet Template

As an owner of a rental business, it is important to know the amount of inventory that is available and the amount of inventory rented out. This Google Sheet Template is developed to help people in tracking the availability of inventory so that it can be rented out.  This Google Sheet template can also provide [...]

Inventory and Sales Manager – Free Google Sheet Template

If you are struggling in managing your product inventory and sales this Google Sheet is suited for you. For everyone who runs a small business of buying products from suppliers and selling them to customers this sheet will be very helpful. This template is suitable for both retail and wholesale business.  What more? The template [...]

Invoice Manager Excel Template – User Guide

This article provides step by step instructions on how to use the Invoice Manager Excel template. Product page: https://indzara.com/product/invoice-manager-excel-template/   Step by Step Instructions Enter Invoice data in Invoices sheet Invoices Sheet The fields required are Invoice Number: Unique identification of invoices. The Invoice number should not be repeated. You can have any method to [...]

Invoice Manager Excel Template – Support Page

Thanks for visiting the support page for Invoice Manager Excel Template which can help simplify tracking and managing invoices and payments. 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 [...]

Retail Inventory Tracker – Free Google Sheet Template

As an owner of a retail business, it is important to know the availability of inventory to manage orders. This Google Sheet Template is developed to help people in buying products from suppliers and selling them to their customers in a retail business scenario. This Google Sheet Template can be effectively used to determine which [...]

2020 Calendar – Free Google Sheet Template

You can plan ahead for the upcoming year by mapping out holidays and important events on a Google Sheets Calendar. We have provided 20 different design templates for the 2020 Calendar that are customizable and print-ready. The design templates include annual (yearly), monthly, weekly and daily calendars. What more? The templates are expandable so you [...]

New Employee Checklist – Free Google Sheet Template

This Google Sheet is developed as a solution to document the completion of activities in a checklist. The HR departments in companies can use a copy of this template to track or document the new employee on-boarding activities. Ideally, there is a list of onboarding activities each employee has to complete during the onboarding process. [...]

Employee Vacation Planner – Free Google Sheet Template

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 Google Sheet Template is developed to provide a simple and effective solution to help assess the coverage of team members’ availability during a particular month.  This Google Sheet [...]

Sales Pipeline Manager Excel Template – User Guide

This article describes step by step how to use the Sales Pipeline Manager Excel Template. For more information on the features of the template, please visit the product page. Sales Pipeline Manager  Overview of Steps Enter sales stages in your Sales process. Rename if necessary. Entering a new deal in Deals table Change Currency for [...]

Sales Pipeline Manager Excel Template – Support Page

Thanks for visiting the support page for Sales Pipeline Manager Excel Template which can help simplify tracking and managing sales deals. 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 [...]

Recruitment Tracker – Free Google Sheet Template

For a simple and effective solution to manage the recruiting process and truly understand its performance via effective Recruiting metrics, use this Google Sheets recruiting template to track status of the applicants (candidates) in an organized way. Get an instant view of how many applicants are in the pipeline and where in the funnel applicants [...]

2020 Excel Calendar Template – 20 Calendar Designs – Free Download

Download this free Excel template and create your own personalized calendars in Excel. This calendar template contains 20 designs that can be used to create calendars for any year.

Retention Dashboard – Excel Template – Step by Step User Guide

In this article, we will explain step by step how to use the Retention Dashboard Excel Template. To learn more about the features of the template and to download, please visit the Product page. OVERVIEW OF STEPS Enter data in Employees Data sheet Refresh Calculations View/Interact with 3 Dashboards VIDEO DEMO STEP 1: ENTER DATA [...]

Retention Dashboard – Excel Template – Support Page

Thanks for visiting the support page for Retention Dashboard Excel Template which can help simplify employee retention 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 [...]

PTO (Paid Time Off) Balance Calculator for Hourly Employee

Download this free Excel template to track and calculate Employee’s PTO accrual balances based on hours worked by the employee. Automatically calculates current PTO balance and projected future balance.

PTO Policy for Hourly Employees & How to calculate PTO Balance

In this article, we cover the common components of a PTO (Paid Time Off) policy for hourly employees. PTO Policy is an important part of a company’s Employee Benefits package. It is one of the factors being considered by candidates when they decide to join a company. An effective employee PTO policy will benefit both [...]

Combinations Generator Excel Template

Download this free Excel template to create all combinations of 6 lists of values instantly. Enter your own lists of values and instantly view all combinations. This template can be used for up to 500 combinations. This sheet can be expanded.

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

Download this free Excel template that allows us to view 2009 and 2014 Election results, and gain insights through simple data visualization techniques. Also, find techniques that can be applied on other topics or datasets.

2019 Excel Calendar Template – 19 Calendar Designs – Free Download

Download this free Excel template to create calendars for any year. Choose from readily printable 19 different calendar designs, including annual (yearly), monthly, weekly and daily calendars.

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 2020 – Excel Time card & Work Hours Calculator

Download this free Excel template to print weekly, Biweekly & monthly timesheets by just entering the time card entries like time in, time out & break time. Contains automated calculations
& reports on multiple timesheets.

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

Download this free Excel template to enter your own data and create heat maps instantly. Enter data by district, choose a color range and create readily printable heat maps.

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

Download this free Excel template to create heat maps of the world instantly. Enter your own data in the template, customize the features and options and print.

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

Download this free Excel template to create heat maps instantly. Data on each district can be entered in any order and color values can be customized. The generated heat maps are printable.

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 2020 – Free Inventory (Stock) Management template

If you are running a retail business, download this free template to track where you plan to buy products from your suppliers and then sell them to customers.

Sales Pipeline Tracker Template – Track sales leads in Excel

Download this free Excel template, to manage the data on your sales leads. Also, this template helps in determining the weak area of your sales funnel & identify bottlenecks in the sales process.

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

Download this free Excel template to create your own personalized calendars in Excel. This template contains 17 calendar designs. Customizable holidays and events. Readily printable, Exportable to PDF.

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 [...]

2020 Leave Tracker & Vacation Tracker Free Excel Template

Download this free Excel template to calculate employee attendance, provides a calendar view of leave for multiple employees and also print an annual employee report. Track vacation of multiple employees including partial days of leave.

2016 U.S. Presidential Election Tracker – Excel Template

Download this free Excel template to view the results of the 2016 U.S presidential election. Simply enter data and view the results on the map. The data can be used for analyses of the election performances.

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

Download this free Excel template to identify the best and worst-performing products easily. Automated reports with a lot of customization options. Compare sales data to attain clarity.

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

Download this free Excel template to consolidate metrics across multiple Social networks and present it in a single-page dashboard.

Group Shared Expense Calculator – Free Travel Expense Sharing Template

Download this free Excel template to calculate each person’s share of expenses in a group. This template really helps to calculate how much each person owes and to whom.

2016 Olympics Dashboard – Explore Rio Olympics data in Excel

Download this free Excel template to access and explore the results of the Rio Olympics. This dashboard template has an Olympic view, country view, and sports view. Accounts for unusual scenarios.

Free Excel Inventory Template for Manufacturing Businesses

Download this free Excel template 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.

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

Download this free Excel template to keep track of all your equipment or assets rented out to your customers. Also, determine the expected inventory in the future, based on future dated rental orders/contracts.

Invoice Tracker Template for Small Businesses – Free Download

Download this free Excel template to keep track of all your sales invoices in one place. Enter payments made by customers and let the template calculate balance outstanding amounts.

2020 Excel Invoice Template – Create Invoices for Small Businesses

Download this free Excel template, to create professional sales invoices for your small business instantly. This template handles tax rates and discounts at the product level.

Small Business Product Catalog in Excel – Free Template

Download this template, If you are looking for a product catalog to share your product info with your prospects and customers. This catalog is very handy and is available without payment processing.

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 2020 – Free Excel Template

Download this free Excel template to track the onboarding activities of a new employee. This template is extremely customizable and provides a printable checklist for each employee. Maintain data of all employees in one file.

Project Pipeline Tracker 2020 – Free Excel Template

Download this free Excel template to track projects and calculate the effectiveness in completing them. Obtain information about all the projects that are on various stages of progress.

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.   Before We get Started 3 Important [...]

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

Download this free Excel template to measure the progress of a project with respect to cost. Calculate cost and performance to estimate the project completion values to understand the status of the project.

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

Download this free Excel template to create a report on product rating (5 Star Ratings) data. By entering the product’s rating data in a simple table, the report is automatically generated for the product comparison.

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

Download this free Excel Template to visualize activity patterns. By understanding the patterns this template uses you can make important decisions. This template uses simple formulas and conditional formatting.

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 2020 – Free HR Excel Template for Recruiters

Download this free Excel template to track status of the applicants (candidates) in an organized way. Get an instant view of how many applicants are in the recruitment pipeline and where in the funnel applicants are dropping off.

Employee PTO Tracker & Calculator 2020 – Free Excel Template

Download this free Excel template to calculate PTO balances where PTO is accrued based on tenure. This simple sheet associated with data validations can be used as a vacation tracker and also a PTO vacation accural calculator.

Employee Vacation Planner 2020 – Free Excel Template

Download this free Excel template to assess the coverage of team members’ availability during a month. This Excel template can be used every month to ensure that you are aware of exact coverage and plan the work accordingly.

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

Download this free Excel template to calculate all the stats based on raw match data and present it in a dashboard. There are three views available. Cup view, Team view & Match view. Change data to view corresponding metrics changes.

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 2020 (Free Excel Template) for Small Business

If you are running a small business, this template helps in managing inventory and sales of buying products from suppliers and selling to customers. (Retail/Wholesale).

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)

Download the free Excel template to create readily printable calendars. Customizable weekends, contains 2 designs, start with any month, highlighted event dates & readily printable.

School Attendance Register and Report v2 (Free Excel Template)

Download this free Excel template to use as an attendance register tool. This template can be used to create class attendance report, student attendance report. The reports are printable.

Report Card – Basic (Free Excel Template)

Download this free Excel template to automate the creation of student report cards and provide meaningful academic performance information to teachers and instructors, with minimal effort. It contains Class view, Subject view & Student view.

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 2020 (Free Excel Budget template)

Download this free Excel template to manage your personal financial situation. Set budgets and see how you are performing against it. Verify your savings and expenses against a category.

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)

Download this free Excel template to generate geographic heat maps for India. The template has a hidden worksheet and conditional formatting is used to create the printable ready to use heat map. Use this template to showcase position of one state.

Task Manager (Free Excel template)

Download this free Excel Template to assist in remembering tasks that need to be done. This template also provides a monthly calendar for reference and print sheet with pending tasks and upcoming tasks. This template handles 6 different tasks and supports updating them.

Quiz Master (Excel template) to conduct quizzes

Download this free Excel template to conduct a quiz. Customize your own questions and answers. The template is very suitable for multiple-choice questions. Automatic score board updates.

Loan Comparison and EMI Payment Calculator (Excel template)

Download this Excel template to help in decision making on loans. Calculates EMI, Last payment month, Number of Payments. Print loan comparison. Compare loans from various banks with various interests.

Project Planner 2020 – Free Excel template for Project Planning

Download this free Excel template to make project planning simpler. This template will help in identifying opportunities, determining due dates and allocating resources based on skill matching.

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

Download this free Excel template to create your own personalized customizable tamil calendars. Add your personal events and print the calendars.

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 [...]

74 thoughts on “Blog

  1. It was a pleasure to read this stuff. Thanks for info!

    1. Thanks for your positive feedback.

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

    1. Thanks!!!

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

    1. You are welcome!!!

  4. 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

  5. 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 to Lucia Stone Cancel reply

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