AC1105 Digital Accounting & Analytics with Microsoft Tools

This course aims to equip accounting students with practical, job-relevant digital competencies by enabling them to effectively apply Microsoft Excel, Power BI, and Power Automate in contemporary accounting contexts. The course is designed to bridge core accounting knowledge with modern digital tools, preparing students for an increasingly data-driven and technology-enabled accounting profession. Specifically, the course develops students? ability to design, analyse, and interpret data-driven accounting models using Microsoft Excel to support financial analysis, budgeting, forecasting, and audit procedures. Students will learn to structure and validate accounting data, apply appropriate analytical techniques, and interpret results. The course further aims to build students' capability to create clear, insightful, and decision-useful dashboards using Power BI. Students will learn to transform accounting data into meaningful visualisations that communicate financial performance, risks, and trends to management and other stakeholders. In addition, the course introduces students to process automation using Power Automate, focusing on the identification and automation of routine, rules-based accounting tasks. Students will learn to design simple, well-controlled automated workflows to improve efficiency, timeliness, and accuracy in accounting processes. Overall, the course aims to prepare students to apply digital tools across a range of accounting and related professional roles, including audit, financial reporting, management accounting, sustainability and ESG reporting, and advisory services. Upon completion of this course, students will be better positioned to contribute to organisational decision-making, enhance process efficiency, and adapt to ongoing technological change within the accounting profession.