How to

How to create a drop down list in Excel?
In this tutorial, we are going to see how we can create a simple drop down list in Excel. Video (How to create drop down list in Excel)   If you would ...
Tue, 9 Jun, 2020 at 12:07 PM
How to enter and delete data in Excel Tables?
I use Excel Tables in all of the templates you can find on https://indzara.com. Excel Tables allow storing information and they also make it easy to retriev...
Tue, 9 Jun, 2020 at 12:07 PM
How to refresh data and calculations?
Many of the Excel templates from https://indzara.com use Pivot tables for calculations. In such cases, when input data changes, you have to tell Excel to re...
Tue, 9 Jun, 2020 at 1:25 PM
How to use Check Box form control in Excel?
In this blog post, we will learn how to create a check box form control in Excel, use it to receive user input and store it in a cell. A sample implementat...
Tue, 9 Jun, 2020 at 1:26 PM
How to view large datasets? (Freeze Panes)
Freeze Panes is an Excel feature that allows viewing datasets that are very wide (lot of columns) and/or very tall (lot of rows). In this video, I demonstra...
Tue, 9 Jun, 2020 at 1:26 PM