Advancing Your Excel Game
CHOOSE The CHOOSE() function is one of my favorite functions! It quickly allows me to “choose” from a defined list of values when aspecific events occur. CHOOSE Formula =CHOOSE(Index Number, Value1, [Value2], [Value3],…) The CHOOSE function allows you to choose from a list of values using the index number as Continue Reading
Heat Maps Heat Maps allow you to display large volumes of data in a comprehensive and concise way. Because of their intuitive nature, Heat Maps are great way to visually compare data. Using a sample data set of video game sales, we will walk through the steps creating a Heat Continue Reading
COUNTIFS Countifs, Sumifs, and Averageifs are some of the most used formulas in Excel. COUNTIFS() allows you to count the values within specified ranges conditionally if criteria is met. COUNTIFS Formula =COUNTIFS(criteria_range1, criteria1, [criteria_range2], [criteria2],…) COUNTIFS will count the values in the range only if the values in the criteria Continue Reading
SUMIFS Countifs, sumifs, and Averageifs are some of the most used formulas in Excel. SUMIFS() allows you to sum the values within a specified range conditionally if criteria in other ranges are met. SUMIFS Formula =SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2], [criteria2],…) Sumifs will sum the values in the range only if Continue Reading