Home Excel Excel Basics

Excel Basics

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

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.

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

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

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

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

Average Annual Growth Rate (AAGR)

Learn how to calculate the Average Annual Growth Rate (AAGR) in Excel.

Latest Tutorials

time value


Excel Tip Calculator

Tip Calculator Template

sum if date is greater

Sum if date is greater than

Calculate Work Days in Excel