Excel Basics

Learn the basics of Excel by reviewing easy to follow tutorials, tricks, and tips.

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

Autofilter in Excel

AutoFilter Excel offers an easy way to search or modify complex data sets using the AutoFilter feature. In order to use...

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.

Pivot Tables

Overview: Pivot tables are one of the most versatile and powerful tools available in Excel. They allow you to...

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

Find and Select

This tutorial is going to review the Find & Select button in the Home section of the ribbon. Let’s say...

Mortgage Calculator in Excel

Need to figure out how much home you can afford? Let's create a mortgage calculator in excel. Want it be flexible and...

Find and Replace in Excel

Learn how to use the Find and Replace feature in Excel. This handy tool can save you a ton of time and...

Creating a Template in Excel

To create a new template in Excel, follow the steps below. In this example, we will be creating the structure for a...
video

Randomly Sort Data in Excel

Learn to randomly sort data in Excel by using this simple trick. The RAND Function can be used to randomly sort a data set by applying a numerical number.

Latest Tutorials