Rating 4.55 out of 5 (204 ratings in Udemy)

• Recall at least three keyboard shortcuts and the arguments of at least three functions
• Identify which Excel function can be used to perform a multicolumn list comparison
• Recognize which Excel function can return the last day of the month
• Recall the arguments for the SUMIFS function
• Recognize the Excel feature that removes duplicate values within a range
• Recall the number of required and optional VLOOKUP arguments
• Recall the arguments of the INDEX, IF, and IFERROR functions
• State which function allows you to substitute a value for an error
• Recall which Excel function returns the count of the number of cells that meet specified conditions
• Recall the arguments of the DATE function
• State an Excel function that returns the year of the date
• Recall which function joins multiple text values
• Recognize the function that would add up an amount column including only rows where the date is between two dates
• Identify a technique that helps Excel translate a data label to a report label
• State which feature can be used to provide a filter for dynamic digital reports
• Identify which function can help build dynamic report headers