Excel Basics

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

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

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

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

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

Pivot Tables

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

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

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.

Autofilter in Excel

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

Latest Tutorials

time value


Excel Tip Calculator

Tip Calculator Template

sum if date is greater

Sum if date is greater than