Learn to create a dynamic name range in Excel
Learn how to use Named Ranges in Excel.
Learn to master Goal Seek in Excel. We cover multiple real world examples.
Learn the difference between A1 vs R1C1 Reference Style in Excel.
Learn to use the INDIRECT Function in Excel.
The Dsum function is used to calculate a specified column in a database that correlates with a specified criteria.
In this tutorial, we will combine the SUMPRODUCT and EXACT Function in a formula to determine the total number of Wins for...
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 nameThis tutorial covers how to split first and last names 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.