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.
We cannot connect excel

“We can’t connect to” in Excel

0
"We can't connect to" pop-up! If you have ever received an Excel document sent to you loaded with Macros, chances are...

_xlfn. prefix in Excel

0
The Excel _xlfn. prefix indicates that your workbook contains a function that is not supported by your version of 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...

Pivot Tables

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

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

GOAL SEEK in EXCEL – What-If Analysis

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

Delete Multiple Rows of data

0
In some cases, there is a need to delete multiple rows of data in Excel. When dealing with large data sets, there...

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

Latest Tutorials

PPMT-Function

PPMT Function

NPER Function

NPER Function