5 Powerful Techniques for Building Advanced Formulas

Previous tutorial on Generating a List of Unique Random Numbers in Excel

If you work with formulas in Excel, or want to learn how, this is the tutorial for you.

This Excel tutorial introduces you to 5 powerful formula building techniques, shows you how to use them, and then shows you how they can be used in a real-world example that combines all of the illustrated techniques.

This tutorial is meant to take you from abstract concept to useful formula, and do so in a way that allows you to apply it to your unique situation and requirements.

The 5 Topics/Techniques Covered in this tutorial:

• Generate Lists with a Formula.
• Create Elastic Ranges.
• Increment a value for every row.
• Make dynamic range references using INDIRECT().
• Use True/False to eliminate values from a list.

Once these topics are explained, I then build the master formula that combines all of these features and shows you how they can be useful.