Apply Modifiers in Formulas Exercise Guide

Take everything you learned in the Write and Test Formulas learning path and apply it by completing the formulas for the Metrics needed for an Income Statement for WLGY Lemonade. Based on your experience and comfort level with modeling, choose the pace that works best for you: Beginner, Intermediate or Expert. At the end of each exercise, answer the validation questions correctly to move onto the next exercise and unlock a video where a Solution Architect walks you through the correct response.

Who should take this course?

This course is designed for technical users. 

Technical users will apply their comprehension of Dimensionality's impact on formulas and adjusting data using modifiers. The module provides a hands-on approach to learning, with activities designed to gain expertise in applying modifiers in formulas.

Topics Covered

• Use the available shell target Metrics for each exercise to add the appropriate modifiers needed to complete the formulas.
• Validate that you complete each exercise correctly by answering questions related to the data for each exercise.
• Watch the Solution Architect walkthroughs on each exercise to learn more about why each specific modifier is used in a formula.

Content Type

• On-Demand

Course Duration

About 3h30 minutes for all 7 exercises

• Exercise 1: 10 minutes
• Exercise 2: 20 minutes
• Exercise 3: 20 minutes
• Exercise 4: 15 minutes
• Exercise 5: 75 minutes
• Exercise 6: 15 minutes
• Exercise 7: 45 minutes