Home Excel Excel Basics

Excel Basics

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

_xlfn. prefix in Excel

The Excel _xlfn. prefix indicates that your workbook contains a function that is not supported by your version of Excel.
We cannot connect excel

“We can’t connect to” in Excel

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

Average Annual Growth Rate (AAGR)

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

Delete Multiple Rows of data

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

GOAL SEEK in EXCEL – What-If Analysis

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

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

Autofilter in Excel

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

INDIRECT Function with Named Ranges

In this tutorial, we are going to cover how to use the INDIRECT Function with named ranges in Excel. Before we begin,...

Latest Tutorials