Data Validation Techniques in Excel
We are going to cover Data validation techniques in Excel. Data validation is a very important feature of Excel document. This feature helps to prevent user from entering …
Excel Basics
Learn the basics of Excel by reviewing easy to follow tutorials, tricks, and tips.
Pivot Tables
Overview: Pivot tables are one of the most versatile and powerful tools available in Excel. They allow you to display data in a table format with multiple filters, …
Linked Checkbox – True / False
Before starting this tutorial, please ensure that you are familiar with adding a checkbox into an Excel worksheet. Also, it may help to download the demonstration file. Download …
Add a Checkbox in Excel
Learn to add a checkbox in excel. This tutorial will provide a simple way to gain more usability from standard spreadsheet. In order to add check boxes in …
Autofilter in Excel
AutoFilter Excel offers an easy way to search or modify complex data sets using the AutoFilter feature. In order to use this tool, it is useful to understand …