Advanced Analytics for Accounting and Finance

(3 Credit Hours) · Undergraduate

This course will advance your skills in the analytical tools most commonly used in current accounting and financial consulting practices, and will include applications in regulatory compliance, financial management and reporting, investment analysis, forecasting, valuation and simulations, operations management, forensics, and financial analysis. You will use advanced Excel techniques in forensic and financial analytics, as well as extraction, transformation, visualization, regression, natural language processing, and data management tools in Tableau, R, Alteryx, and Python. These analytical skills will allow you to identify areas where you can add value by identifying anomalies with respect to fraud, internal controls, or key financial, audit risk, and/or tax positions and the associated risks or opportunities for clients and stakeholders. Moreover, you will have confidence in the topics incorporated into the new CPA Evolution 2024 for applied technology, including: relational databases, normalization of data, structured and unstructured data, data extraction and transformation, forecasting to model financial results, cybersecurity, sensitivity analysis, and predictive analytics.