Home Excel Excel Basics

Excel Basics

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

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

Average Annual Growth Rate (AAGR)

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

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

GOAL SEEK in EXCEL – What-If Analysis

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

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.

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

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

INDIRECT Function with Named Ranges

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

Latest Tutorials