ACC (0201) 301 - Data Analytics for Accountants Using Microsoft Excel

Credits: 3.00

This course is meant for students who are in the early stages of learning the fundamentals of data analytics. At the end of this course, students will gain exposure to using Excel in efficiently navigating big datasets in different accounting and finance-related scenarios and in creating effective data visualization.

Repeatable: No Grade Type: Regular or Pass/Fail
Course Learning Goals:

Upon the completion of this course, the successful student should be able to

understand the meaning, uses and limitations of data analytics in general and in accounting in particular.
prepare data for analysis and conduct a basic data audit including establishing data internal controls.
demonstrate the ability to sort, rearrange, merge, and reconfigure data to engage in enhanced analysis.
perform different types of data analytics.
communicate the results of data analytics with the use of tables and visuals.
develop reasonable proficiency in written communication through class participation and selected assignments.