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?
All About Excel TablesI use Excel Tables in all of the templates you can find on https://indzara.com.  Excel Tables allow storing information and they also...
Sat, 18 Jun, 2022 at 6:52 AM
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 demonst...
Fri, 17 Jun, 2022 at 3:10 AM