Excel for Accountants: Volume 2

Learn how to build formula-based reports and more.

Created by: Jeff Lenning
Microsoft Certified Trainer

What Will I Learn?

• 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

Requirements

• To work on the exercises, please have Excel 2007/2010/2013 for Windows.

Target audience

• This course is designed for accountants seeking to use Excel to complete their tasks more quickly.
• This course is not designed for people seeking generic Excel training, as the features covered are relevant to accountants.