Details for BUS220 Excel and Data Analytics

This subject will commence in 2025

Quick Stats

  • Currently offered by Alphacrucis: Yes
  • Course code: BUS220
  • Credit points: 10

Subject Coordinator

Contact studentsupport@ac.edu.au for more information.

Unit Content

Outcomes

  1. Explain and employ pivot tables, macros and other advanced Excel functions;
  2. Critically evaluate and select various data analysis methods and statistical tools within Excel to explore, interpret, and derive insights from datasets;
  3. Create dynamic reports and dashboards within Excel which enhance data communication and decision support;
  4. Apply Excel and data analytics skills to solve real-world business problems.

Subject Content

  1. Advanced Excel Functions and Formulas
  2. Data Cleaning and Transformation in Excel
  3. Data Visualization in Excel
  4. Pivot Tables and Pivot Charts
  5. Data Analysis Tools in Excel
  6. Statistical Analysis in Excel
  7. Regression Analysis in Excel
  8. Time Series Analysis and Forecasting
  9. Automating Tasks with Macros and VBA
  10. Advanced Charting and Graphs
  11. Scenario Analysis and What-If Scenarios
  12. Data Analysis with Power Query and Power Pivot

This course may be offered in the following formats

  • Face to face on site
  • E-learning (online)
  • Intensive
  • Extensive

Please consult your course prospectus or enquire about how and when this course will be offered next at Alphacrucis University College.

Assessment Methods

  1. Project (Excel functions and Analysis) (40%)
  2. Group Report with Dashboard (30%)
  3. Presentation (30%)

Prescribed Text

Winston, W. (2023). Microsoft Excel Data Analysis and Business Modeling (Office 2021 and Microsoft 365), 7th edition. Microsoft Press.
Check with the instructor each semester before purchasing any textbooks