Home Excel Excel Basics

Excel Basics

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

Average Annual Growth Rate (AAGR)

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

Add a Checkbox in Excel

0
Learn to add a checkbox in excel. This tutorial will provide a simple way to gain more usability from standard spreadsheet.

Autofilter in Excel

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

Linked Checkbox – True / False

0
Before starting this tutorial, please ensure that you are familiar with adding a checkbox into an Excel worksheet. Also, it may help...

Pivot Tables

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

Data Validation Techniques in Excel

0
We are going to cover Data validation techniques in Excel. Data validation is a very important feature of Excel document. This feature...

GOAL SEEK in EXCEL – What-If Analysis

0
Learn to master Goal Seek in Excel. We cover multiple real world examples.

Mortgage Calculator in Excel

0
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

0
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

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

Latest Tutorials

NPER Function

NPER Function

CUMPRINC Function

CUMPRINC Function

YEARFRAC Function

YEARFRAC Function