Skip to main content Skip to book tools

Financial Accounting Practice Sets with Excel


Nate Stephens, PhD, CPA
Brigham Young University–Hawaii
Nick Ball, PhD
Utah Valley University
Gove Allen, PhD
Brigham Young University
Edition 1
(rev. 604)

The Financial Accounting Practice Sets with Excel course contains several accounting practice sets, encompassing most of the accounting skills covered in introductory financial accounting courses. Each practice set provides instructions covering the Excel skills needed to complete the practice set. Instructions are embedded within each Excel practice set as well as in the online text resource both in written and video form. Practice sets are graded based on the correctness of the accounting problem as well as the correct use of relevant Excel functions. Excel functions used in this resource include, but are not limited to the following list:


  • COUNTIF Function

  • Conditional Formatting

  • Cell References

  • Basic Calculations (add, subtract, divide, multiply)

  • Absolute Value

  • 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. Optional LMS integration provides for automatic recording of grades into the LMS, as well as the option to embed assignments directly into the LMS.

Click here to email us for more information about the book, assignments, and course.

  • Any Device, Any Location, Any Time

    The course reader looks great on desktops, laptops, tablets, phones, and just about any other device. Students are able to read, watch, and listen how, where, and when they want.
  • Embedded, Customizable Assessments

    Your students complete assessments inline with the text, making for a seamless, engaging experience. As the instructor, you can customize existing assessments or create entirely new ones within the text.
  • Advanced Analytics

    Monitor the progress of your class collectively as well as students individually. Course analytics provide you with student engagement and performance in reading, videos, and assessments. Analytics help you focus directly on those topics or students that need it.
  • Flashcards

    Flashcards are a great way to learn the key terms. Each course comes pre-loaded with cards for every term. Students can also make their own to enhance their learning experience.
  • Searchable Glossary

    A searchable glossary is available at any point in the course reader, allowing students to search for any key term they want and jump straight to that word in the text - no matter where they're reading.
  • Highlights and Notes

    Students can highlight the text and make notes throughout the content using their touch screen or mouse.
  • Text, Video, Audio, Assessments

    Course content is provided in multiple ways, allowing your students to learn the way they learn. The HTML5-based course reader works like any other web page--the way the web was meant to be used.