Please register to access Best Practices for Getting Insights from Reports. ×
Please register to access Using Pivot Tables. ×
Please register to access Introduction to Parameters. ×

Introduction to Parameters

Learn to use parameters to run different scenarios with adjustable values, without creating or modifying the constants in formulas for each new value.

rate limit

Code not recognized.

About this course

A Parameter is a container or a placeholder such as a number, date, or string that can replace a constant value or a list of values.

Parameters can be created in Worksheet and Answers, with the focus of this course being on using parameters in Answers. Adding Parameters to Worksheets will be discussed in the Data Expert learning path.

Topics covered

  • Defining parameters
  • Listing the use cases of parameters
  • Creating parameters
  • Using parameters in formulas

Prerequisites

Previous courses in the Business Analyst eLearning Path.

Curriculum30 min

  • Welcome
  • Course Overview
  • Introduction to Parameters
  • Introduction to Parameters 4 min
  • Practice: Using Parameters 7 min
  • Dynamic Parameters 4 min
  • Dynamic parameters
  • Course Review
  • Review 5 min
  • Knowledge Check 5 min
  • Feedback

About this course

A Parameter is a container or a placeholder such as a number, date, or string that can replace a constant value or a list of values.

Parameters can be created in Worksheet and Answers, with the focus of this course being on using parameters in Answers. Adding Parameters to Worksheets will be discussed in the Data Expert learning path.

Topics covered

  • Defining parameters
  • Listing the use cases of parameters
  • Creating parameters
  • Using parameters in formulas

Prerequisites

Previous courses in the Business Analyst eLearning Path.

Curriculum30 min

  • Welcome
  • Course Overview
  • Introduction to Parameters
  • Introduction to Parameters 4 min
  • Practice: Using Parameters 7 min
  • Dynamic Parameters 4 min
  • Dynamic parameters
  • Course Review
  • Review 5 min
  • Knowledge Check 5 min
  • Feedback