Excel Basics

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

Randomly Sort Data in Excel

0
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

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

Create a Dynamic Name Range Table in Excel

0
Learn to create a dynamic name range in Excel

Data Filtering in Microsoft Excel 2013

0
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

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

Named Ranges in Excel – Setup, Rules, and Uses

0
Learn how to use Named Ranges in Excel.

Create a Drop Down List

0
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

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

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

How to apply Multiple Filters in Excel

0
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