5 Powerful Techniques for Building Advanced Formulas

Add to Favorites
Author: | Edits: don

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.

Question? Ask it in our Excel Forum


Downloadable Files: Excel File

Similar Content on TeachExcel
5 Tips for Evaluating Complex Formulas in Excel
Tutorial: 5 simple tips to evaluate any complex formula in Excel! These tips combine to give you th...
Formula Auto-Increment After So Many Rows
Tutorial: This Excel auto-increment formula includes the ability to control the interval of the inc...
Odd or Even Row Formulas in Excel
Tutorial: Formulas to determine if the current cell is odd or even; this allows you to perform speci...
Custom Cool Buttons in Excel - With Animations!
Tutorial: How to make Professional or simply Cool Buttons for Excel! These buttons look good, funct...
3 Tips for Faster and Better VBA Macros in Excel - Simple to Advanced
Tutorial: Make a 3 minute macro execute in less than 1 second! Learn to make faster, better, and mo...
FILTER() Function Excel - Power Lookup for the Future
Tutorial: The new FILTER() function for Excel 365 allows you to do amazing things with a single sim...
Tutorial Details
Downloadable Files: Excel File
Similar Content
5 Tips for Evaluating Complex Formulas in Excel
Tutorial: 5 simple tips to evaluate any complex formula in Excel! These tips combine to give you th...
Formula Auto-Increment After So Many Rows
Tutorial: This Excel auto-increment formula includes the ability to control the interval of the inc...
Odd or Even Row Formulas in Excel
Tutorial: Formulas to determine if the current cell is odd or even; this allows you to perform speci...
Excel Forum