Create a Dynamic Name Range Table in Excel
Learn to create a dynamic name range in Excel
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.
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.
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.
