Home Excel

Excel

Learning Excel has never been easier. Review hundreds of Excel tutorials geared towards beginners all the way to experts.

video

Create a Dynamic Name Range Table in Excel

Learn to create a dynamic name range in Excel
video

Named Ranges in Excel – Setup, Rules, and Uses

Learn how to use Named Ranges in Excel.

GOAL SEEK in EXCEL – What-If Analysis

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

A1 vs R1C1 Reference Style

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

INDIRECT Function

Learn to use the INDIRECT Function in Excel.

DSUM Function

The Dsum function is used to calculate a specified column in a database that correlates with a specified criteria.

SUMPRODUCT and EXACT Formula

In this tutorial, we will combine the SUMPRODUCT and EXACT Function in a formula to determine the total number of Wins for...

EXACT Function

The EXACT function compares two strings of text. The main limitation of using the Exact function is it is Case Sensitive. If...

SPLIT FIRST and LAST NAMES

Split First and Last nameThis tutorial covers how to split first and last names in excel.
video

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.

Latest Tutorials