Excel Basics

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

Randomly Sort Data in Excel

Learn to randomly sort data in Excel by using this simple trick. The RAND Function can be used to randomly sort a data set by applying a numerical number.

GOAL SEEK in EXCEL – What-If Analysis

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

Create a Dynamic Name Range Table in Excel

Learn to create a dynamic name range in Excel

Data Filtering in Microsoft Excel 2013

Filtering is a fast and easy approach of sorting work with a portion of data so that you are able to display only...

A1 vs R1C1 Reference Style

Learn the difference between A1 vs R1C1 Reference Style in Excel.

Named Ranges in Excel – Setup, Rules, and Uses

Learn how to use Named Ranges in Excel.

Create a Drop Down List

If you want to force user for selecting data from the fixed data items and prevent user from entering custom data for any...

Display Formula and Value Simultaneously

Ever need to display a formula and value simultaneously in the same spreadsheet? This could not be easier to...

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

How to apply Multiple Filters in Excel

We are going to cover how to use Multiple filters in Excel. A Filter is cumulative, this implies that you can apply...

Latest Tutorials

Year Function

YEAR Function

Delete Multiple Rows of data