Unit Content
Outcomes
- Explain and employ pivot tables, macros and other advanced Excel functions;
- Critically evaluate and select various data analysis methods and statistical tools within Excel to explore, interpret, and derive insights from datasets;
- Create dynamic reports and dashboards within Excel which enhance data communication and decision support;
- Apply Excel and data analytics skills to solve real-world business problems.
Subject Content
- Advanced Excel Functions and Formulas
- Data Cleaning and Transformation in Excel
- Data Visualization in Excel
- Pivot Tables and Pivot Charts
- Data Analysis Tools in Excel
- Statistical Analysis in Excel
- Regression Analysis in Excel
- Time Series Analysis and Forecasting
- Automating Tasks with Macros and VBA
- Advanced Charting and Graphs
- Scenario Analysis and What-If Scenarios
- 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
- Project (Excel functions and Analysis) (40%)
- Group Report with Dashboard (30%)
- 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
