Important Dos and Don'ts

Important to know before starting to use the Excel templates from indzara.com

3 Tips Before Starting to use the templates
Excel templates from indzara.com use certain approaches to keep the files simple to use, but at the same time very effective in solving real-life needs. We ...
Tue, 9 Jun, 2020 at 10:29 AM
5 Tips Before Starting to use the Templates (with Pivot Tables)
Excel templates from indzara.com use certain approaches to keep the files simple to use, but at the same time very effective in solving real-life needs. We ...
Tue, 9 Jun, 2020 at 10:29 AM
Do not edit calculated cells
Each template has several calculated fields and most are protected from editing. However, some are not protected. It is strongly recommended that these fiel...
Mon, 13 Apr, 2020 at 5:14 PM
Input Data is always visible & can be edited easily
In most business applications, we may have a form where we enter data and click submit to push that data to the database behind the scenes. Until you click ...
Mon, 13 Apr, 2020 at 5:17 PM
Backup by saving file regularly
Microsoft Excel has its default data recovery process if the Excel application crashes. Other than that, there is no special backup system in this file. Thi...
Mon, 13 Apr, 2020 at 5:19 PM
Do not rename fields used in Pivot Tables
Some Templates use Pivot Tables for calculations and in such templates, please do not rename fields used in Pivot Tables. Such fields are highlighted and al...
Mon, 13 Apr, 2020 at 5:21 PM
Refresh Calculations when Pivot Tables are used
In templates that use Pivot Tables, after we enter/edit data, we need to refresh so that calculations are updated. Otherwise, the calculations will not refl...
Mon, 13 Apr, 2020 at 5:23 PM