Excel for Accountants: Volume 2
Learn how to build formula-based reports and more.
4.60 (206 reviews)
993
students
8 hours
content
Dec 2014
last update
$159.99
regular price
What you will 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
Screenshots
Related Topics
219058
udemy ID
5/15/2014
course created date
4/18/2021
course indexed date
Bot
course submited by