Excel and Data Analytics

This subject will commence in 2025

Awards offering Excel and Data Analytics

This unit is offered as a part of the following awards:

• Bachelor of Business
• Bachelor of Business (Business Analytics)

Unit Content

Curriculum Objective

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