The Financial Accounting Practice Sets with Excel course contains several accounting practice sets, encompassing all of the accounting skills covered in introductory financial accounting courses. Each practice set is preceded by instruction covering the Excel skills needed to complete the practice set. Practice sets are graded based on the correctness of the accounting problem as well as the correct use of Excel functions. Excel functions used in this resource include, but are not limited to the following list:
VLOOKUP
COUNTIF Function
Conditional Formatting
Cell References
Basic Calculations (add, subtract, divide, multiply)
IF Statement (including nested IF Statements)
PV Function
SUMIF Function
SUM Function
DATEDIF Function
Drop-Down Lists
Absolute Cell References
Cell Formatting
Displaying Decimal Places
The practice problems and assignments are paired with an intelligent, robust, and detailed grading engine that automates the grading process and provides students with immediate and clear feedback.
Click here to email us for more information about the book, assignments, and course.